Need help getting data from location table to Catalog item

[thomast63]

We are looking for some help with the Service Catalog and routing Catalog Tasks to groups.

I have Fields that were put on the Location table and trying to pull them into the Catalog Items.

We have been told we can only dotwalk 1 level on getting these Fields

“Since these 2 fields exist in the underlying table and not in user, using g_form.getReference you cannot access them.

The temporary and quick fix is to create 2 additional fields in user table and store this data for all users in those fields as well. Then you can access those fields like any other fields using getReference.”

I can pull them in with javascript but if user ID is changed then the update script will not work.   Wondering if you have any ideas for how to handle this situation?

[john_duchock]

excellent...good luck with all your other stuff !!

[thomast63]

John,

1 last question (I hope)

would I be able to pull in a Field called "u_glide_list_1" with this??

[john_duchock]

If it is on the location table, certainly...  just add it to the script include and client script appropriately and it should come over as well. 

As a habit, i typically create my Script Includes to pull more data than i need at the time and instead include any field that i think i will ever need when writing a client script...  that way if i ever need to write a new client script to pull different values, i don't have to update my script include...the data is there waiting on me...

Also, be careful about naming fields and variables "field_1" or "object_2" or "u_glide_list_1" as those become hard to manage when writing advanced scripts.   Give your objects meaningful names like "u_user_list" or "group_member_count"...

[thomast63]

Cool. Thanks again for all your help. you are GREAT!!

[thomast63]

I tried to add the u_glide_list_1 and all it pulled back was numbers (Sysid) I'm guessing.

so not sure that a glide list will pull back. unless I'm doing something wrong.