GlideRecord issue using addNotNullQuery

[ServiceNow Use6]

Hi,

I am working on GlideRecord method addNotNullQuery() and I am facing the issue. I believe I am getting wrong output. Kindly help.

var gr = new GlideRecord("incident");
var shortDesc = gr.addNotNullQuery('short_description');
gr.query();
while(gr.next()){
gs.addInfoMessage("The short description for " + gr.number + " is " + shortDesc);
}

Regards

Suman P.

[Srikanth_Peru · Accepted solution]

Hi @ServiceNow User

Please use this Script :

var gr = new GlideRecord("incident");
gr.addNotNullQuery("short_description");
gr.query();
while(gr.next()){
gs.addInfoMessage("The Short Desription for: " +gr.number +" is "+gr.short_description);
}

Please mark my response Answered and Hit Helpful 

[Hemant Goldar]

Hello,

addNotNullQuery()- a filter that specifies records where the value of the field passed in the parameter is not null.

You may find the below link helpful.

https://developer.servicenow.com/dev.do#!/reference/api/orlando/server/no-namespace/c_GlideRecordSco...

var gr = new GlideRecord("incident");
gr.addNotNullQuery('short_description');
gr.query();
while(gr.next()){
gs.addInfoMessage("The short description for " + gr.number + " is " + gr.short_description);
}

Thanks

Hemant

[Ankur Bawiskar]

Hi,

your script should be like this

var gr = new GlideRecord("incident");
gr.addNotNullQuery('short_description');
gr.query();
while(gr.next()){
	gs.addInfoMessage("The short description for " + gr.number + " is " + gr.short_description);
}

Regards
Ankur