Hi
According to this link, Search on the text field search box is case insensitive but it is being sensitive. May i know why? Pls share ur thoughts, would very much appreciate it
Hello @lalprasanth, I have a few questions about the filter you are building out. Is the control built off of the filter or is your filter linked to a parameter that is set by a control?
If the control is built directly from the filter, what is the Filter Type that you selected? It seems like that could affect the way the search functionality is handled. From my testing, if you are using a Filter based control, and the filter is selected as a Filter list, the case insensitive functionality works as expected. Also, I tested on a parameter based control where the control is linked to a dataset field and that worked as well. I may be able to resolve the issue with more information!
@WLS-DM its a search box where u search values and the style is text field search while creating the parameter. And the parameter was applied to the field in the filter section to be able to search its value on the search box. (Here i am not linking any dataset’s field in the parameter)
If the values were in capital letters and if i searched by small letter, the respective data won’t be showing in the tables and visuals.
Hello @lalprasanth, if the search box is not linked to a dataset field, does that mean you manually entered the options to search between? If that is the case, I do believe the search box loses the case insensitive functionality. If the search box control is linked directly to a dataset column, it should perform in the way you are expecting.
@WLS-DM yes i manually search values in the box, but is there a way to make it case insensitive with some calculation for the field?
I used this concat(upper(samecolumn),’ ',lower(samecolumn))
Apart from the above calculation, is there any other ways? Pls let me know
Hello @lalprasanth, I apologize for the delay in my response. I want to make sure I am following because I still don’t believe I fully understand what you have done to create this control field. When you created the filter that has the search functionality, did you write the values that your readers could choose from or did you link your filter to a dataset field?
I am going to send some screenshots below of the various ways that you can create a control for your visuals so you can let me know which you used!
-
Created a control from a filter
-
Created a control from a parameter
-
And if you did create a control from a parameter, did you do it like this where you added the filter options manually?
-
Or did you connect it to your dataset field like this?
Hello @lalprasanth,
I am going to archive this topic since it has been open for an extended period of time and since a follow-up response has not been submitted. If you would still like assistance with this, or if you have a new Quick Sight question, feel free to post a new topic in the community so you will be at the top of the priority list for a response from one of our Quick Sight experts. Thank you!