Currently, the search does not actually search on the format as shown in the table... it uses the OutSystems format. Is there a way to change this? If I were to search for '10-01-2023' then it shows blank, if I search as shown below then it finds it... so it is searching the data behind and not the data shown in the grid. How can I change this if it is even possible? I don't want the Grid format to change - I want the search to be able to search the current date format in the grid...
Turns out that this has been fixed in later versions of the grid.
Hello @Nicholas Campbell
Are you using client or server-side search?Can you please share a sample oml so that we can try to help?
Cheers,GM
Hi
Client-side search. I will not get to that for a bit, if no one else answers soon I will do that.
Hi,
With your situation, I would transform the data afterwords. What I mean is, you would insert the '10-01-2023' and after transform to 'FormatDateTime(TextToDate(YourInputVar) ,"dd-MM-yyyy")' and use the output to search in your table.
I may be misunderstanding your idea. But if not, this will not work since we do not have access to the text entered into this search component - it ties with the Grid via Id - the search it not manual where you use the text to filter...