Hello,
I have a folder view form, with a document research in it.
I would like to remove the case sensitive on the search parameters.
Is it possible? I don't see any option to do that in form builder.
Thank you for your help.
Yes you can. You need to modify the underlying DQL for your search result and add the following, i.e. for title.
SELECT * FROM my_doc WHERE LOWER(title) like LOWER('%$title$%') ...
Hello Ahmad,
Thank you for your answer but the problem is that my form is not a search form, it is a folder view.
And the query is not visible, I just can choose condition on the attributes as you can see below.
I see, I am not sure if there's a way, but to use an adaptor. Even if you use the adaptor to convert the user's input to lower/upper, then in your actual DQL, the attribute value (i.e. title) should be converted to upper/lower receptively as well.
It is not possible to modify the query in folder view form.
Do you have Full Text Indexing configured in your repository?
No it is not configured.
