1,206
Hi,
I'm creating a form grid view with working calendar dates as the main datasource. User should be able to filter date range using advanced filter like 1/3/2019..31/3/2019
The query range is like Date >= 1/3/2019 && Date <= 31/3/2019.
Is there any way to extract the input values and store 1/3/2019 as FromDate and 31/3/2019 as ToDate?
I'd like to use these values for comparison with each line of it's child data source later.
Thank You.
*This post is locked for comments
Thank you Ievgen. It works.
Here's my completed code in case somebody needs it:
Share
Report
All responses (
Answers (
Query query;
QueryRun queryRun;
QueryBuildDataSource qbdsWorkCalendarDate;
QueryBuildRange qbrProductionDate, dateRange;
int rmFromDate, rmToDate;
str dateRangeValue, fromDateStr, toDateStr;
TransDate fromDate, toDate;
query = new Query();
//define data sources
qbdsWorkCalendarDate = query.addDataSource(tableNum(WorkCalendarDate));
qbrProductionDate = qbdsWorkCalendarDate.addRange(fieldNum(WorkCalendarDate, TransDate));
qbdsWorkCalendarDate.addOrderByField(fieldNum(WorkCalendarDate, TransDate));
queryRun = new QueryRun(query);
if (queryRun.prompt())
{
while(queryRun.next())
{
//After prompt, range is specified. So query is modified. Get modified query range value. Otherwise query only has range but without value.
query = queryRun.query();
qbdsWorkCalendarDate = queryRun.query().dataSourceTable(tablenum(WorkCalendarDate));
dateRange = qbdsWorkCalendarDate.findRange(fieldNum(WorkCalendarDate,TransDate));
dateRangeValue = dateRange.value();
//Extract from date
rmFromDate = strFind(dateRangeValue,"..",1,strLen(dateRangeValue));
fromDateStr = strDel(dateRangeValue, rmFromDate, strLen(dateRangeValue));
fromDate = str2Date(fromDateStr, 123);
//Extract toDate
rmToDate = strFind(dateRangeValue,"..",1,strLen(dateRangeValue));
toDateStr = strDel(dateRangeValue, 1, rmToDate + 1);
toDate = str2Date(toDateStr, 123);
info(strFmt("From %1 To %2", fromDate, toDate));
}
}
Filter you add is effectively a query range. Let's say you have QueryBuildDataSource (qbds), to get range value you do
dateRange = qbds.findRange(fieldNum(MyTable, MyField));
if (dateRange )
{
info(dateRange.value());
}
and you can always get qbds from a query by table id.
#1
André Arnaud de Cal...
292,489
Super User 2025 Season 1
#2
Martin Dráb
231,305
Most Valuable Professional
#3
nmaenpaa
101,156
