Using Dot Walked Field Value in Workflow

maxsaber
Giga Contributor

Hi Everyone,

I have a workflow I've build against my change_request table that I need to use a dot-walked field as a switch in the workflow. The dot-walked field doesn't exist on the cmdb_ci table but on the cmdb_ci_server table so I created an additional reference field cmdb_ci == u_ref_cmdbci_server that is hidden on my change request form. The field that I need in the switch is u_vmfolder. On my change request form I am able to see these fields find when I insert the expanded references using Configure > Form Layout.

Here are the fields in the change request:

find_real_file.png

Here is the switch in the workflow:

find_real_file.png

and the switch conditions:

find_real_file.png

If anyone could offer any thoughts or a better way to do this, I appreciate your assistance in advance!

Thanks,
Max

**Edit: forgot to include the error this workflow throws when I request approval: nfo Messa

Workflow 'CHG - Server Remediation' with context 2c6a8fc6dbe12b40f632de82ca961972 terminated 2018-11-05 16:17:48 UTC with : Wrapped ReferenceError: "u_ref_cmdbci_server" is not defined. (Determine Server Tier(34e82736db99e3408efe2736059619ad); line 1) (sys_ui_action.ce610f6a4a36231201083cbc48ac3ad8.script; line 4)

1 ACCEPTED SOLUTION

Ankur Bawiskar
Tera Patron
Tera Patron

Hi Max,

So you created new field "u_ref_cmdbci_server" on change_request table. Does it refer to table cmdb_ci_server?

If yes then dot walk should be allowed. Can you check whether that new field has value in it when you are trying to use it in switch condition. How is that field populated?

Mark Correct if this solves your issue and also mark Helpful if you find my response worthy based on the impact.
Thanks
Ankur

Regards,
Ankur
✨ Certified Technical Architect  ||  ✨ 9x ServiceNow MVP  ||  ✨ ServiceNow Community Leader

View solution in original post

2 REPLIES 2

Ankur Bawiskar
Tera Patron
Tera Patron

Hi Max,

So you created new field "u_ref_cmdbci_server" on change_request table. Does it refer to table cmdb_ci_server?

If yes then dot walk should be allowed. Can you check whether that new field has value in it when you are trying to use it in switch condition. How is that field populated?

Mark Correct if this solves your issue and also mark Helpful if you find my response worthy based on the impact.
Thanks
Ankur

Regards,
Ankur
✨ Certified Technical Architect  ||  ✨ 9x ServiceNow MVP  ||  ✨ ServiceNow Community Leader

Ankur Bawiskar
Tera Patron
Tera Patron

Hi Max,

Any update on this?
Can you mark my answer as correct, helpful if you were able to achieve the requirement. This helps in removing this question from unanswered list and helps users to learn from your thread. Thanks in advance.

Regards
Ankur

Regards,
Ankur
✨ Certified Technical Architect  ||  ✨ 9x ServiceNow MVP  ||  ✨ ServiceNow Community Leader