Hello,
I have a need to query a master table based on values in it AND values in several detail tables. Then I would simply return to the PHPR default list page for that master table with the records that match the search criteria (excluding, of course, such master table rows whose children rows don't match the criteria). That would then allow me to dig into a single master table record.
So I almost have all the "components" available, but would need to tailor somehow the advanced search page to (a) let me select detail table search values and (b) modify the resulting SQL statement accordingly before executing the query and returning to the list page.
What would be the most suitable way of implementing this? Any suggestions? Am I missing something simple? I'm still using version 4.2.
Thanks!