I have a table called personnel which there are two types - temps and employees. I need to build a module for temps separate from the employees. Basically, I need to use a Where clause in the select statement to retrieve all personnel with that type.
Even though the docs state that Where statements are not supported in the GUI, I tried to put my Where clause in there - and it worked.
...Where person_type = 'employee'
Everything works until I try to use the search feature - I am redirected to a PHP error page, that shows the error # and the query that failed. When used, there is a Where clause for the person_type and then another for the where clause generated by the search.
Can anyone throw me a bone on how to get around this issue?
I need Where clauses for my data. I really do not want to split up my data into two tables just for this.
PR