Background script for printing the INC no.'s that ends with 0(zero)

[amit71]

Background script for printing the INC no.'s  that ends with 0(zero). Please guide this how to achieve.

eg: INC1234430

[amit71]

Hello @Ankur Bawiskar ,

Is is possible to execute without using addEncodedQuery().

Thanks,

Amit

[Jaspal Singh]

You can try

addQuery('number', 'ENDSWITH', '0');

instead of

addEncodedQuery(); 

[Ankur Bawiskar]

Hi,

any reason you don't want to use addEncodedQuery()?

yes it's possible as mentioned by Jaspal

Regards
Ankur

[Ricky S Larsson · Accepted solution]

You could achieve this after the query as well by using the regex test function

var gr = new GlideRecord('incident');
var regex = /[0]$/;
gr.query();
while(gr.next()){
    var endsWithZero = regex.test(gr.number);
    if(endsWithZero)
        gs.print(gr.number);
}

[Pratap Dalai]

Hi Richard,

running the GlideRecord.query() without any condition will fetch all records from the DB.

Then you are applying the regex ,