Variable prefix in Database views - How do you decide the prefix?

Anish Reghu
Kilo Sage
Kilo Sage

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.

 

find_real_file.png

1 ACCEPTED SOLUTION

Hi Anish,

 

In that case you can setup a view something as below.

find_real_file.png

 

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.

View solution in original post

9 REPLIES 9

I owe you a drink some day.

Thank you! You just made my day...

Excellent....

Glad to know it helped.

Hope you understood what you wanted & all is clear now in terms of Left join & database view.

Yes, it is.

Happy Learning & Welcome to the community.

Ankur Bawiskar
Tera Patron
Tera Patron

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

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