I'm trying to import data from Oracle (Toad), using a select statement - When I pass one or two account in where I get the output. When I try to pass around 10 or more it doesn't fetch any records. It just fetches 0 lines - Not sure what the issue is .
My Statement ends with where c.account_id IN (222,333,444,555,666,777,888,999,1111,2222).
Any idea why the query does not fetch any records?. - Please find attachment for log file.
It seems it is not Qlik related problem.
The syntax of your where condition seems OK, there is no reason why you get rows when: where c.account_id in = (1,2) and don't get any rows at where c.account_id in (1,2,3,4,5,6,7,8,9,10)
There should be other problem.
In Toad does this query gives you 0 records?
I do not know much about SQL but I'd suggest breaking down the table and see where it is not fetching records?
Since you are doing quite a few If else, where conditions etc...
For just 2 accounts it does fetch records, when I add three or more accounts in the IN condition it doesn't fetch any record - It just loops out of the query.