Demand fields aren't displayed after join with Stakeholder table

[bywater]

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)

[Runjay Patel · Accepted solution]

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

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

[Runjay Patel · Accepted solution]

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

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

[bywater]

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

[Runjay Patel · Accepted solution]

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.