How to filter search?


#1


I’ve set up oracle search now. But I don’t know how to filter search?
select * from t_table1 where companyid=? like this sql, one user can only search his own companyid, how to filter the companyid?
He can also select from begin time 2018-02-01 to end time 2018-02-02 to search. How to make it?


#2

You should read the Query Parameters documentation. Namely the important notice at the bottom.


#3


It’s OK now. But the embed url is not work for the filter, the filter box is ming. How to make it?

image
It also has a bug when I have ‘=’ in the search box, it can’t find search anything.


#4

You might want to actually read the link I sent you, along with the important notice at the bottom.

Use triple quotes, i.e. {{{param}}} instead of {{param}} to aviod HTML escaping of values like =.