Gliderecord query for the table alm_asset

[Hamza Berouil2]

Hi all,

I am facing a weird issue (or maybe I am wrong).

I am trying to run a simple background script to retrieve field values from the tables Asset and Hardware (lets say for example install_status), but the system always return the value "undefined".

Here is my script :

   var myQuery = 'u_configurationLIKE_MANUEL';
   var gr = new GlideRecord("alm_asset");
   gr.addEncodedQuery(myQuery);
   gr.query();
   gs.print('count :'+ gr.getRowCount());
   if (gr.next()) {
   gs.print("status: "+ gr.install_status);
   }

The first "gs.print" returns 23 (what is expected) but the second returns undefined.

If I replace install_status by sys_id, it works fine !!

If I take any other field I always get "undefined" value.

I thought maybe it's due to an ACL, but when I have a look to the Asset list I can see all the fields which confirms that it's not due to an ACL issue.

If I run a similar query for any other table, it works fine.

Any idea guys ? is it something specific to Asset management ?

Thank you in advance

Best regards,

Hamza

[Hamza Berouil2]

Hi Pradeep,

Thank you

Already tested, but it does not work

[Pradeep Sharma]

Hi Hamza,

Thanks for the update.

Is this on your personal dev instance. If yes I can take a look.

[Hamza Berouil2]

Unfortunately it's not my instance and I am not allowed to give you an access

I think I should create a /HI ticket ...

[Pradeep Sharma]

Can you try to reproduce this on your personal dev instance(if you have the one from developer's portal).

[Chuck Tomasi]

Hi Hamza,

Have you checked the system dictionary for the alm_asset table to ensure you have a field called install_status (and ensure that it is active)?