question Demand fields aren't displayed after join with Stakeholder table in Community Central forum

Demand fields aren't displayed after join with Stakeholder table

bywater — Tue, 29 Oct 2024 14:10:21 GMT

Here is a snapshot of my database view. I believe I did it right but when I select try it only the Stakeholder fields are displayed and all the Demand table fields are blank or marked (empty)

Re: Demand fields aren't displayed after join with Stakeholder table

Runjay Patel — Tue, 29 Oct 2024 15:18:54 GMT

Hi @bywater ,

See the screenshot and do the same.

-------------------------------------------------------------------------

If you found my response helpful, please consider selecting "Accept as Solution" and marking it as "Helpful." This not only supports me but also benefits the community.

Regards
Runjay Patel - ServiceNow Solution Architect
YouTube: https://www.youtube.com/@RunjayP
LinkedIn: https://www.linkedin.com/in/runjay

-------------------------------------------------------------------------

Re: Demand fields aren't displayed after join with Stakeholder table

bywater — Tue, 29 Oct 2024 15:25:20 GMT

It worked!! Quick question.... why sys_id vs. the demand

Re: Demand fields aren't displayed after join with Stakeholder table

Runjay Patel — Wed, 30 Oct 2024 03:59:24 GMT

Hi @bywater ,

because on stakeholder table we have field called demand which is Refrence to demand table. It means if you are using stakeholder demand then it will give demand sys_id which we can compare with sys_id of actual demand.

hope it is clear to you now.

mark helpful and accept the solution if it helped.