Can I dot walk between sys_user and a custom field on cmn_location table?

[Lon Landry3]

Need to populate catalog variable with item Requested for & custom field from cmn_location table.

[Hitoshi Ozawa]

Not understanding the question. It's possible to dot walk to a custom field added to cmn_location. The problem is where and how the field is dot-walked.

[Lon Landry3]

Thanks for reply, What I am trying to do is populate a variable on a catalog item with information related to the Requested for field (Defaults to current user but can be changed to another user). I need to pull from a custom field in the cmn_location table to determine Requested for location by (NASA, EMEA, APAC). 

Please let me know if further data required.

I have been using a script Includes & client script but can only seem to pull the location data available in sys_user table.

[shloke04 · Accepted solution]

Hi,

I would suggest there is a easier and no code option available OOB which you can use to auto populate this.

Please find the steps below:

Navigate to your Catalog Item and there is a Related List named "Catalog Data Lookup Definition" as shown below:

2) Click on New button as shown above:

3) Click on new button in Related List "Catalog Matcher Variable Definitions" as shown below:

Now Configure this as shown below:

Now click on New on the other Related List where you can set the values you want as shown below:

Catalog Setter Variable Definitions:

Now just set the variable values which you want:

Here I have set Email. Similarly you can set other variable from User Table

Result:

Hope this helps. Please mark the answer as correct/helpful based on impact.

Regards,
Shloke

[Lon Landry3]

If the custom field is not in list. (Because custom field is only on cmn_location table) Can I reference both tables?