
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-11-2020 07:10 AM
Hi all,
While I looked for the Product documentation for Database views, it shows a example where Variable prefix shows as inc for incident. OK - Variable prefix for incident is defined in the form, look at the Where clause - how does system automatically assume chg is for change?
And can someone explain what is this Left join all about?
In simple terms please. Please do not guide me to Product documentation. I didn't understand, hence I am here.
Solved! Go to Solution.
- Labels:
-
Platform and Cloud Security

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-11-2020 08:21 AM
Hi Anish,
In that case you can setup a view something as below.
Once done you can report on the view created & then add required set of fields.
No need to do a left join unless you want all Stories to be shown from above even if there does not exists any scrum task.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-11-2020 09:48 AM
I owe you a drink some day.
Thank you! You just made my day...
Excellent....

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-11-2020 11:02 AM
Glad to know it helped.
Hope you understood what you wanted & all is clear now in terms of Left join & database view.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-11-2020 11:46 AM

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-11-2020 12:13 PM
Happy Learning & Welcome to the community.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-11-2020 07:27 AM
Hi,
thumb rule is to use prefix which is easy to identify and also keep it on smaller length not more than 3 characters
such as inc, chg
Left join:
Selecting Left join causes the left-hand table in the database view to display all records, even if the join condition does not find a matching record on the right-hand table
Mark ✅ Correct if this solves your issue and also mark 👍 Helpful if you find my response worthy based on the impact.
Thanks
Ankur
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader