gliderecord query by state label

[Jim60]

I know this is a bit of an odd question but is there a way to perform a query by the state label instead of the value?   Using state.label does not work. (I'm well aware that using the value is by far the safest.)

[SanjivMeher]

Hi Jim,

Yes, You can query based on display Value. Try something like below using CONTAINS. it worked for me.

var inc = new GlideRecord('incident');

inc.addQuery('category','CONTAINS','Request');

inc.query();

while (inc.next())

{

gs.addInfoMessage('-----------'+inc.number);

}

[Jim60]

Thank you for taking time to reply.   I'm looking specifically for the 'state' field and this does not seem to work.   (Where state of New is a valid label)

var inc = new GlideRecord('incident');
inc.addQuery('state','New');
inc.query();
 while (inc.next()) {
     gs.print('-----------'+inc.number);
}

[Inactive_Us1474]

You can use getChoiceValue(); to get the label for the choice field, but querying the table always works with the name, value pairs.

Hope to see some method like this.

[SanjivMeher]

You didnt use contains. Use below script

1. var inc = new GlideRecord('incident');  
2. inc.addQuery('state','CONTAINS','New');  
3. inc.query();  
4. while (inc.next()) {  
5.     gs.print('-----------'+inc.number);  
6. }