Database Views help

[Jennifer Red]

I'm trying to use a Database View to connect the asmt_assessment_instance table with the task table. What I'm needing to do is use the task.number to match with the asmt.trigger_id to be able to get the requestor's phone # in their Task ticket. Is this possible? Or will it be more complicated because of the differences between inc and sctask? I'm getting no results when I try to do this database view... even if I do it just with the inc table. I also discovered the asmt.task_id field, but I'm still receiving no results. Thanks for any help!

[Jennifer Red]

@Murthy Ch I was able to make two separate database views... one for the assessment and inc and one for the assessment and sctask. But I don't see an easy way to get to our default variable set. When I try to add a column for variable sets, it wants me to pick for a specific catalog. We have a standard default variable set that we utilize with pretty much all of our catalog builds. Thoughts? I appreciate your help so far!

[Anubhav24]

Hi @Jennifer Red ,

Did you mark the left join as "true".

Please mark helpful/correct if my response helped you.

[Jennifer Red]

@Anubhav24 On which table? I have Left join set to false on both, currently.