You can try what Shishir has suggested. Or try this
- var inc = new GlideRecord('incident');
- inc.addQuery('state',getState('incident','New'));
- inc.query();
- while (inc.next()) {
- gs.print('-----------'+inc.number);
- }
- function getState(tablename,label)
- {
- var ch = new GlideRecord('sys_choice');
- ch.addQuery('name',tablename);
- ch.addQuery('label',label);
- ch.query();
- if (ch.next())
- {
- return ch.value;
- }
- }
Please mark this response as correct or helpful if it assisted you with your question.
