How to write a complex query~

[tianhb]

How to write a complex query�

now,I have a query as follows。

        select tbl.a,

                            tbl b,

                            tbl c

        from   table tbl

    where 1=1

          and   (a.start_date >= '2015-04-01' and a.start_date <= '2016-03-31') or (a.end_date >= '2015-04-01' and a.end_date <= '2016-03-31')

  var tableInfo = new GlideRecord('x_smei_table');

    .........................?

    .........................?

    .........................?

    .........................?

    .........................?

    .........................?

    .........................?

    tableInfo .query();

  How to implement this query?   help~~ï¼� help~~!

[tianhb]

Thank you for your patience.     thank you....

[Geoffrey2]

It has something to do with Application Scoping. gs.dateGenerate() must only be accessible from Global scope.   Try and generate a different query that doesn't use that function.

[tianhb · Accepted solution]

The problem was solved.

var tableInfo = new GlideRecord("x_smei_table");

var startDate = new GlideDateTime();

startDate.setDisplayValueInternal(strStarDate + " 00:00:00");

var endDate = new GlideDateTime();

endDate.setDisplayValueInternal(strEndDate + " 23:59:59");

var dateQuery = "ent_start_dateBETWEEN" + startDate + "@" + endDate + "^ORent_end_dateBETWEEN" + startDate + "@" + endDate;

tableInfo .addEncodedQuery(dateQuery);

tableInfo.query();