Hi Community,I have a list of employees displaying basic details and an input search where we can search names of the employees.So is there anyway where I can enter multiple names comma separeted in Input search box and get searched by only those entered names. The search values would be like below.Eg: "Drik,Joy"
I have searched on Forum but didn't got any solution for this. So is there anyway to do this in aggregates or advance sql by applying filter. Can someone please help me with this issue.
Thanks and Regards,Sanji San.
Hi @Sanji San ,
You can use the following filter in your aggregate:
SearchKeyword = "" or SearchKeyword like "%" + Entity.Name+ "%"
'I also attached a sample OML for reference.
Result: