You can translate the question and the replies:

contains search in view

Hi Team, I want to filter the data using contains on particular text column (case insensitive) any method available and also using ODATA also any option available Thanks Satish K
08-03-2021 10:09:35 -0500

1 Answer

Hi, From Denodo Platform 8.0, the [contains]( operator is replaced with **POSITION** function. Hence, in order to filter the data that contains certain values from a specified column, I would follow the below suggestions, * To filter the data by querying the view from Virtual DataPort, for example, * If the query has "field1 containsand ('arg0', 'arg1')" use, ***POSITION(UPPER('arg0') IN UPPER(field1)) > 0 AND POSITION(UPPER('arg1') IN UPPER(field1)) > 0*** * When I use OData interface to query the views from Denodo Platform, I would use the [Advanced Querying]( option to filter the data based on a value contained in a column. For example, ***/denodo-odata.svc/<viewname>?$filter=contains(fieldname,'value')*** Hope this helps!
Denodo Team
10-03-2021 07:27:09 -0500
You must sign in to add an answer. If you do not have an account, you can register here