Siebel Open UI, Tools, Scripting and EAI (MOSC)

MOSC Banner

How to query in eScript for old records

edited Sep 22, 2015 10:31AM in Siebel Open UI, Tools, Scripting and EAI (MOSC) 3 commentsAnswered

bcAccount.SetSearchExpr("[Type] <> 'Residential' AND [Created] < (Today()-daysvar)");

where daysvar can have any value.

Getting below error :

---------------------------

Siebel

---------------------------

[1] The query expression on field 'Created' is not valid. Please revise and try again.(SBL-DAT-00399)

[2] CSSUtcDateTime doesn't support operator '<' with 'CSSInteger'(SBL-DAT-00480)

---------------------------

OK

---------------------------

How to solve this ?

[19-Dec-2014]: I can query successfully when i use Today()-100 i.e. by hardcoding. 'Created' is a system field, not required to be exposed on UI for my requirement. My requirement is simply to query for Account records which are more than a year or 'daysvar' no.of days(configurable).

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center