Share
Report
13Hi all,
I have a datatable with multiple columns such as , State, Company, Compliance L4 Risk as shown below. I have added a search functionality which can search multiple columns. For ex: If I search for Company A, it will return 2 rows.
However, I want a search capability which can search a string something like Company A Risk 2 ..My datatable is not returning any records when I search this way. How can I achieve this search capability?
In other words, I'm trying to build a highly flexible search functionality that can handle searches consisting of multiple words, potentially in any order, and still return rows where those words are present in the same or different columns within the same row.
PS: The above is just an example. However, I have rows with multiple paragraphs so concatenate doesn't really work here.
Thanks in advance.
Best,
M
All responses (
Answers (
