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?

[thomast63]

Thanks for helping with this.

What we are doing is when the user puts in "Requested For User"

That it will populate the Catalog Default and Phone Default and PC Catalog Fields from the location table. We have the Location FOG also on the Location table and can't get that to pull in. Since we can't dot walk to table.

[john_duchock]

Follow up question:  Are you trying to get location value from a user field (from sys_user.location) ?

[thomast63]

we tried to put those fields on User table but maintenance of them is a pain. So we are trying to pull from Location Table with out luck. Lack of Scripting Knowledge

[john_duchock]

nah...dont do that...give me 10 mins or so....

[thomast63]

Thanks!!!