How to query a null value in javascript

[fiona]

Is there any one know how to query a null value field in the javascript?

e.g.

I want search ticket with resolution is Null. I used code below. But it doesn't work.

var incidentFile =newSCFile("probsummary");

var rc =incidentFile.doSelect("resolution=NULL");




Thanks.

[chenrich]

Hace you tried "" insted of null?

[fiona]

Thanks chenrich. I tried. It doesn't work too.

[chenrich]

Are you sure? Have you tested it like this?

var rc =incidentFile.doSelect("resolution=\"\"");

[glg]

when using doSelect, you want the query to be in SC format, not anything JS. So, "resolution=NULL" should work, as should "null(resolution)".

[chenrich]

The Null descriptor is not alwas set. If you want to search a filed in which nothing is inserted then you have to check for an empty string (""). because the field isor was instancieated!

[fiona]

I did debug.

1. print(incidentFile.resolution);

It is print out

[C++ object Datum] @0x01a2b8d8 - {}

for resolution when there is nothing there.

2. print(incidentFile.resolution[0]);

It is print out

null

for resolution when there is nothing there.

3. print(incidentFile.resolution.length());

It is print out

0

for resolution when there is nothing there.

I think I can only use the length. How to use the length in the query?

[mateuszk]

var incidentFile =newSCFile("probsummary");
var rc =incidentFile.doSelect("resolution=NULL");

queries in JS doSelect follow the same rules as all queries in SC.

var rc = incidentFile.doSelect("null(resolution)");

it's the all same with operators like "isin" or functions i.e. "index".

[fiona]

Thanks, mateuszk. It works.