This topic is locked
[SOLVED]

 Filtering list page using sql queries not working

10/14/2016 6:58:32 PM
PHPRunner General questions
C
conejorapido author

Hi!,
First I want to congratulate you for the program <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=24222&image=1&table=forumtopics' class='bbc_emoticon' alt=':D' />
The version i'm using: PHP 9.0 build 27012 (upgrade from 8.1 25268).
I have the next problem: I implement several custom views of the list page (add_ticket, del_ticket, sub_ticket, etc) in a project to facilitate view and filter some fields for the users and I add them like a submenu in the list page and custom views so the users can only see the rows that have only the add_ticket field, del_ticket field or whatever the field they seeking. I tried using the next code in List page:Before record processed:
if ( preg_match( '/^DEL-./', $data["ticket"]))

return true;

else

return false;
But the detail is that it is only hiding the rows that don't match so if i am using the custom view del_ticket filtering by del_ticket and i have 5 list pages with 5 results of del_ticket in each one i need to go through each page to see all the results in place of see all in the first page (i don't want to use the text box to increment the results by page).
So i searched and found that i can use the SQL query filter; I have implemented it in the "ticket" field like:
LIKE 'DEL%'
and the result of the query is the correct but when i build the project it only show the correct number of details found per page but none row, after that i searched in the forum and found that i can use a command in the
List page: Before SQL Query*:
$strWhereClause = whereAdd($strWhereClause,"ticket LIKE 'DEL%'");
but is the same result that in the SQL query filter (I delete previously the sql query filter). I use the inspect option in Google Chrome using both and where it is suppose to be the table with the info it shows nothing, is blank. If i remove the filter and the command it shows the table again.
Can you help me telling me what I am doing wrong??
Thanks in advanced.

C
conejorapido author 10/20/2016

The problem is solved now. I think it was a bug because when I was applying the troubleshooting explained here, I wrote the command, build the program and when i was going to start checking, the filter using the query was doing his job so now i finished <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=80494&image=1&table=forumreplies' class='bbc_emoticon' alt=':D' /> .