javascript doSelect with date/time

[gm9213]

Hi

How should a doSelect query be formatted if you wanted to select incidents which is older than a certain date?

table: probsummary
query: flag=true and open.time<'2007/05/05 00:00:00'

javascript:
//Initialize file variable
//table: probsummary
var filevar=newSCFile( "probsummary" );
// Select using query: flag=true and open.time<'2007/05/05 00:00:00'
var imselectvar =filevar.doSelect( help required here);

Thanks in advance
Andreas

[tommy]

Try this

filevar.doSelect( "flag=true and open.time<'2007/05/05 00:00:00' ");

[gm9213]

Hi,

It worked fine, thanks!

//Andreas

[dgraham]

I'm trying to do this same thing with SC 6.2 and all I get is SQL syntax errors.

 
 24300( 16032) 04/07/2008 09:35:47   JS I SCL.abdel.log: Running the following query on "SCLabsencedelegationevents":>>>>> start_date<'04/07/08 09:24:47'
 24300( 16032) 04/07/2008 09:35:47  RTE E start_date<'04/07/08 09:24:47' (script.execute,exec.statements)
 24300( 16032) 04/07/2008 09:35:47  RTE E Invalid syntax for query.  Failed parsing (script.execute,exec.statements)
 24300( 16032) 04/07/2008 09:35:47  RAD I -1
 24300( 16032) 04/07/2008 09:35:47   JS I -1

(The '-1' is the returned result of the doSelect, ie: it failed)

I've tried all sorts of date formats (2008/04/07 00:00:00, 08/04/07 00:00:00, 04/07/2008, etc...) and nothing seems to be working.

My JS is:

eventSelectQuery ="start_date<'04/07/08 09:24:47'";
print("SCL.abdel.log: Running the following query on \"SCLabsencedelegationevents\":>>>>> "+ eventSelectQuery);
selectResult =event.doSelect(eventSelectQuery);

Is there a particular date format I ought to use, or is something else wrong? Thanks a lot.

[tommy]

Try replacing the "_" with ".". You should not replace dots with underscore inside strings that are passed as arguments. Its only when you need to reference the field in the javascript you need to do that.

[dgraham]

That fixes it. Thanks for the tip!

[krisman]

Hi tommy. I was just having a similar problem. Thanks for the help!