Direct query - Direct Discovery - Error

[#1]

Hi All,

I am using direct query in one of my Qlik applications, but i am getting the below error

ErrorSource: OraOLEDB, ErrorMsg: ORA-01795: maximum number of expressions in a list is 1000

When i am selecting the filters to populate the table through Direct discovery.

Any help would be highly appreciated.

Thanks..

[#2]

Please post the query

[Vegar]

You are sending to many values into your automatic generated sql where statement. Oracle have a limit on 1000 values in is where statement and you are sending.

WHERE

Field IN value1, value2, ..., value1000, value 1001 etc.

Try limit the number of values in your D discovery. Maybe you could use a dimension and not a transaction key?