How to filter in execute query by Date range value?

Question

I have to made a Query in executeQuery , and I have to filter by date field, my code is :

public void executeQuery()
{
    utcDateTime dateUTC, datenullUTC;
    query q = new Query();

    QueryBuildRange qbr;
    QueryBuildDataSource qbds ;
    QueryRun queryRun;

    dateUTC = DateTimeUtil::newDateTime(_dateValue, 0, DateTimeUtil::getCompanyTimeZone());

    qbds = q.addDataSource(tableNum(MCRCustCategory) ); 

    qbds.addRange(fieldNum(MCRCustCategory, ValidTo)).value(strFmt ("> %1", dateUTC) );

    queryRun = new QueryRun (q);

    super();
}

In my init I call the executeQuery, but don't filter in my Form.

How to use the date in the Range ?

Thanks all,

enjoy!

Jan B. Kjeldsen · Accepted Answer · 2015-12-01T15:21:29.653

2

You use a table which use date effective. You assume you have to do the selection yourself, this is not true.

Use this instead:

public void executeQuery()
{
    this.queryBuildDataSource().validTimeStateAsOfDate(_dateValue);
    super();
}

If you have an interval, use this instead:

this.queryBuildDataSource().validTimeStateDateRange(fromDate, toDate)

Your code as provided in the question does not do anything at all, as the form does not use the query you build. You buildt the wrong query anyway!

This blog post explains it concisely.

edited Dec 01 '15 at 15:21

answered Dec 01 '15 at 14:52

Jan B. Kjeldsen

17,817
5
32
50

`this.queryBuildDataSource().validateNameCharacters();` I only have this method if I write in _executeQuery_ method form. – ulisses Dec 01 '15 at 15:34
You have it in all datasource methods. Otherwise locate the query by other means. – Jan B. Kjeldsen Dec 02 '15 at 06:12
What has `validateNameCharacters` to do with anything? – Jan B. Kjeldsen Dec 02 '15 at 10:16

How to filter in execute query by Date range value?

1 Answers1

Linked