Hi Jeevan,

It might work but you need to add 2 more tables in the join/ database view, one for table of request and another one for table of requested_for and use something like:

Where clause

ci_u_user =     stsk_request_item

stsk_request_item = xxx_request

xxx_request = yyy_requested_for

You'll need to test it this.

Regards,

Hi!

I tried this but it seems to require all tables to contain data related to each other.

E.g, I have created a database view to display Problem data and incident data based on Incident related to problem. I also want to display the Country where these incidents were registered.

The database view looks like

View tables:

problem

        where: prb_sys_id=inc_problem_id

incident

        where: inc_problem_id=prb_sys_id

cmn_location

        where: (null)

This only displays one record, since there is only one record where the location on the incident is set and contains country data.

If i remove the cmn_location, the list will display 29 records..

I want to display all the 29 records WITH the country if applicable.

Am I doing wrong?

Hi Mathias,

If not all incidents have the location set, then set the "Left join" flag when you define the "cmn_location" within the Database View.

Telmo

This worked great! Thank you!

above solution worked. thank you