How to avoid duplicate gliderecord queries in this case
- obj is an object on hardware table
- assuming country is 'spain' and model is 'laptop' and this value is stored in obj object which I received from bulk import.
var gr = new GlideRecord("asset_tag_rule");
gr.addEncodedQuery("country=" + obj.country + "^model=" + obj.mdl); // we are checking in asset_tag_rule table if spain country and laptop model is there.
gr.query(); // querying and assume I get one record
if (gr.next()) {
var grINCR = new GlideRecord("asset_tag_rule");// how to avoid this step
grINCR.addEncodedQuery("country=" + gr.country + "^u_ctgry_prfx=" + gr.u_ctgry_prfx);// here I am checking asset_tag_rule table if spain country and ctgry_prfx value is present in this table which we get from first glide object(gr)
grINCR.query();
while (grINCR.next()) {
grINCR.net = 3;
grINCR.update();
}
}
- I can have multiple values of u_ctgry_prfx (which I get from gr) and country combination from asset_tag_rule table hence used while in the end to update.
@Ankur Bawiskar or anyone pls suggest a way
