Database view joining a referenced field returning 0 results

[Renee-17]

I am trying to create a database view joining sc_request table with xyz_user table.  Note that the xyz_user table extends sys_user table.  The u_user column in the sc_request table is a Reference field that references the xyz_user table.

In the database view, the sc_request is prefixed with req and xyz_user is prefixed with usr. 

The join is as follows:

• req.u_user = xyz.sys_id

Also tried

• req_u_user = xyz_sys_id

In terms of query order I've placed the sc_request table first and placed the join in xyz_user which is called second.  I also tried calling xyz_user first and placing the join in the sc_request where clause which is called second.

Any insight will be greatly appreciated.  I've been able to join other tables with success but not these 2 tables.

[Brad Bowman]

Is this a typo, or did you try with the second table prefix

req_u_user = usr_sys_id

[Renee-17]

Thanks Brad for pointing that out.  It was a typo on my part.  I was using either the usr.  or usr_

[AshishKM]

Hi @Renee-17 ,

can you please share the screen shot of that page.

-Thanks,

AshishKM

[Renee-17]