2. PHPRunner General questions
  3. Ajax lookup
This topic is locked

Ajax lookup

 		2/22/2021 5:50:02 AM
PHPRunner General questions
S
 Steve Seymour author

Hi,
Does anyone know of a way to set the priority of the returned suggestions from an Ajax lookup, or increase the returned list length.

For example, I have a stock table that is used in an ajax lookup. There are many items that contain the word OIL for example.
When the user is searching for the item "OIL 15W 40" for example, it not shown in the ajax list for the word OIL, many other items that contain the word oil are shown before.

The length of the returned list could be used to include all content, but is somehow limited in the number of items it returns. Is there a way to increase the return list length - or prioritize the order of the returns ?
Thank you.

Steve
H
 		Hd_Mersintarim 2/22/2021

<script type="text/javascript">

$("#your button").submit(function(e) {

$.ajax({

type: "POST",

url: 'post.php',

data: $("#yourForm").serialize(),

success: function (response) {

while (response){

loop records

}

}

});
});

</script>
S
 		Steve Seymour author 2/22/2021



<script type="text/javascript">

$("#your button").submit(function(e) {

$.ajax({

type: "POST",

url: 'post.php',

data: $("#yourForm").serialize(),

success: function (response) {

while (response){

loop records

}

}

});
});

</script>


Thanks, that would be a ajax form call with a button, I'm looking to modify the phprunner ajax lookup (EditAs Lookup Wizard) - which works well - except that the returned results are limited in number and/or order..
I think this is the closest I have found so far... https://codeforgeek.com/ajax-search-box-php-mysql/

I need to find the variable that PHPRunner send to the search script and possible modify it in the Edit SQL Query of the Lookup Wizard where clause or alter the limit if thats possible