Database view of change request table with related lists

Sneha59
Kilo Contributor

‎01-15-2020 03:25 AM

I have to create a database view to show all the fields of change request form and present in related lists in one report. what condition should be given in where clause?

Related List

find_real_file.png

Database view

find_real_file.png

Labels:
Preview file
12 KB
Preview file
25 KB
0 Helpfuls
  • 2,681 Views
1 REPLY 1

johnfeist
Mega Sage
Mega Sage

‎01-15-2020 05:26 AM

Hi Sneha,

Here's the link to the documentation on joining tables in a database view.  This is one place where the notation is inconsistent since the table/field notation is table_field rather than table.field and the relationship is via = not ==.

The where clause needs to go on the right side tables, so you won't have it on change_request but will on incident, task_ci, etc. If you are doing secondary joins, the same rules apply.

Hope that helps.

:{)

Helpful and Correct tags are appreciated and help others to find information faster

Hope that helps.

:{)

Helpful and Correct tags are appreciated and help others to find information faster