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

[Ankur Bawiskar]

Hi,

what debugging have you performed by adding logs etc?

Regards
Ankur

[Manasa23]

HI Ankur,

Ran the below in background  script 

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

[Anil Lande]

Below is correct way when you want to use gr1.addEncodedQuery();

var gr1 = new GlideRecord('alm_hardware');
gr1.addEncodedQuery('model_category.name='+'Computer');
gr1.query();
if (gr1.next()) {

Thanks,
Anil Lande

[Ankur Bawiskar]

Hi,

update query as this

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

Regards
Ankur

[Manasa23]

HI Ankur,

When i pass the direct string in add query, it is working fine.

when I try to addQuery  with a variable, it is not working ...

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