Blox Search Field usage for multiple columns
Hi, I'm creating a dashboard with a table with multiple columns containing text. I've created individual filters for the columns. I tried adding the Blox Search Field widget but it is only allowing me to search one column. I created multiple buttons to search and clear each column. Is it possible to create one button that searches all buttons? Here is an image of the Search Field widget with my current implementation:
janaya71
Posted 1 year ago·Last reply 1 year ago
8 comments
ramansingh89
·1 year agoHi TriAnthony , Do you think we can use this method to satisfy my requirement here?
https://community.sisense.com/t5/help-and-how-to/single-filter-against-multiple-columns/td-p/27079
Tri Anthony
·1 year agoHi ramansingh89, I responded in the thread you opened.
-Tri
Tri Anthony
·1 year agoHi janaya71, could you clarify how you'd like the search to work? Are you expecting a single search button to apply the same input across the three filters (Request ID, Request Name, and Request Text)? If so, these columns have different values (and possibly different data types), so applying the same text values to all three filters will likely lead to no results. Or do you want an OR-based search across these columns to return any matching rows, regardless of which column contains the input?
If the goal is to search one column at a time, how would the button differentiate the user input and determine whether to search it in the Request ID, Request Name, or Request Text filters? Let me know what you're aiming for, and we can explore possible solutions.