List Manager Forum

Need assistance with the Fixed custom filter

User aliwari 2024-04-10 06:49:24

Hi there,

I'm attempting to establish fixed conditions using valid SQL in the fixed custom filter, but I'm not seeing any results in the frontend table. I utilized the query:

SELECT * FROM table_name WHERE field = '123';

Did I overlook something here?





Regards

Moonsoft support 2024-04-10 08:34:49

Hi,
the fixed custom filter only needs to contain the conditions to append to the 'where' statement, so for this example, you only need to enter there

field='123'

Hope this helps, regards

User aliwari 2024-04-10 14:24:43

Hi,

That's really helpful, thank you.



Regards

...
Support/development 40 hours

With the peace of mind of having a professional team at your service (20% discount)

Buy now!
...
CalcBuilder

Create dynamic calculators

Buy now!