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.