I am unable to get to ranges on joined datasource in a query.
(pasting below from debugger)
My query is :
SELECT * FROM TPAPurchLineGlobalTmpCopy(TPAPurchLineGlobalTmpCopy) JOIN * FROM EcoResCategory(EcoResCategory_1) WHERE ((EcoResCategory(EcoResCategory_1).Name = N'SG&A - Professional Fees Other'))}
The problematic line is: (iDS is just a looping variable)
int maxRange = parameterQuery.dataSourceNo(iDS).rangeCount();
maxRange returns zero in this case.
Just to be sure, I tried this
QueryBuildDataSource qbds = parameterQuery.dataSourceNo(iDS);
and confirmed that the statement is accessing correct datasource. Value of qbds is SELECT * FROM EcoResCategory(EcoResCategory_1)
Any idea what I am doing wrong? maxRange should have returned value of 1 since I have a filter on Name.