How to Glide Record the model category field in the alm_hardware table

[Manasa23]

HI,

I'm trying to GlideRecord the model category field in the  alm_hardware table, below is the code. Code is not working..
can someone help me with the correct code.

I tried to glide record the  Asset tag, serial number  and other  fields in alm_hardware using the same code, its working fine !!!

var gr1 = new GlideRecord('alm_hardware');
gr1.addEncodedQuery('model_category', category);
gr1.query();
if (!gr1.next()) {
gs.log("modelcategory is " + category);
 return "Model category is not existing in the system";

}

Thanks,
M

[Anil Lande]

Hi,

Can you please share what is your variable name, what is working what is not working?

Please check the scripts provided in previous response which I have tested and working fine for me.

Thanks,

Anil Lande

[Anil Lande · Accepted solution]

Have you defined category variable in your script:

like below:

var category = 'Computer';
var gr1 = new GlideRecord('alm_hardware');
gr1.addQuery('model_category.name', category); 
gr1.query();
if (!gr1.next()) {
gs.print("model category is not exisit");
}

Thanks,
Anil Lande

[Manasa23]

HI Anil,

Its working fine now.Thanks a lot