You can translate the question and the replies:

Parametrised Query

How can i apply filter on two column at the same time like or in below mentioned URL(What and where should i add second column condition): http://<host of the denodo server>:9090/server/<name of the database>/<name of the REST API>/views/<name of the base view>?$filter=uname%20IN%20(<input parameter1,input parameter2,….input parameterN)
user
19-02-2020 09:56:58 -0500

1 Answer

Hi, When I need to filter by two columns I just separate both conditions with & or *%20AND%20*. The result would look something like any of the two examples below: * <rest of the URL>/my_view?$filter=column_1%20IN%20(1,2,3,4)&column_2=259 * <rest of the URL>/my_view?$filter=column_1%20IN%20(1,2,3,4)%20AND%column_2=259 Those are equivalent to a SQL WHERE condition such as: ``` WHERE (column_1 in (1, 2, 3, 4) AND column_2 = 259) ``` I would read the documentation on [parameters supported by the denodo restful web service and published rest web services](https://community.denodo.com/docs/html/browse/7.0/vdp/administration/restful_architecture/restful_web_service/input_parameters_of_the_restful_web_service#parameters-supported-by-the-denodo-restful-web-service-and-published-rest-web-services) to learn more about these features. Hope this helps!
Denodo Team
19-02-2020 14:07:59 -0500
You must sign in to add an answer. If you do not have an account, you can register here