Date Filter in QueryBuild DataSource

Hi,

qbds1 = q1.addDataSource(tableNum(TableName));
qbds1.addRange(fieldNum(TableName,Date)).value((strFmt(’((Date >= %1) && (Date <= %2))’, date2StrXpp(frmdt),date2StrXpp(todt))));

I didn’t get any data related to my query datasource. What is problem in my above code?Please help me.

Thanks in Advance

Nimisha Patel

hi ,

use this instead of adddatasource method i think it will workout…[:)]

qbds1=q1.dataSourceName(identifierstr(tablename));

Thank you very much for your quick support. It’s working very good as per our requirement.

Regards,

Nimisha Patel

Hi,

You said to use identifierstr …it’s working great…but I can’t fetch data in datewise. I send my code like

Hi,

qbds2=q.dataSourceName(identifierstr(TableName));
qbds2.addRange(fieldNum(TableName,Date)).value((strFmt(’((Date >= %1) && (Date <= %2))’, date2StrXpp(frmdt),date2StrXpp(todt))));

queryRun1 = new QueryRun(q);
while(queryRun1.next())
{
TableName1= queryRun1.get(tablenum(TableName)); }

Not getting data using this code.

Please hepl me asap.

Regards,

Nimisha Patel

try this and lemme know…

as far ur range statement to retrieve date is concerned i dont think there s anything wrong with it…

qbds2=q.dataSourceName(identifierstr(TableName));
qbds2.addRange(fieldNum(TableName,Date)).value((strFmt(’((Date >= %1) && (Date <= %2))’, date2StrXpp(frmdt),date2StrXpp(todt))));

queryRun1 = new QueryRun(q);

queryrun1.reset();

while(queryRun1.next())
{
TableName1= queryRun1.get(tablenum(TableName)); }

Hi Nimisha ,

You can use the QueryRange method instead of using .value method.

As you can see in the below code…

qbds1.addRange(fieldNum(TableName,Date)).value(queryRange(From, To));

I think this will work fine…

Regards,

Janak Talekar

Thank you for your suggestion…it’s work fine…