Applying dynamic WHERE to list

[arnor@icetips.com]

Hi guys,

I have a table with about 50K rows in it. I need to be able to construct a WHERE filter prior to the list loading and applying this WHERE to the SQL query. Prefilter isn't going to work (I use those all over the place) because this needs to be dynamic.

I know I can do this on the URL, but it opens up an option for users to mess with it and potentially make a mess. Is there any way that I can add PHP code to the list PHP plugins to construct the WHERE filter and pass it back into Fabrik for it to use in the query?

Any ideas?

Best regards,

 

[startpoint]

List plug-in PHP EVENTS->OnBuildQueryWhere

 

[arnor@icetips.com]

Hi,

Awesome! Been using Fabrik for 3 years and I guess I never scrolled down far enough! <g>