Hi
I need to have something pattern concept like If I have column in a table with the type of text. I need to fetch matching to that text column the complete row using the pattern.
Hi @Touseef Ahmed ,
Are you trying to filter records on the basis of match? And are you using aggregate to fetch the data or anything else?
Will You Please explain more about your question what exactly you want ?
Hi, If I understand correctly, you’re trying to fetch complete rows based on a text pattern match in a column. In OutSystems, you can handle this using a simple LIKE condition. For example, you can apply a filter like: Column LIKE "%" + SearchText + "%" This will return all rows where the text column contains the given value. You can also adjust it for starts with or ends with depending on your requirement. If you need more control or better performance, you can also use Advanced SQL with the same LIKE pattern. Hope this helps