Database view

[tsoct]

How can I join the database views for the three tables shown below? I'm getting an error 'Syntax Error or Access Rule Violation detected by database ((conn=2096030) Unknown column 'jou.sys_created_by' in 'where clause')' when trying to join.

[Brad Bowman]

It seems to work like this, without trying to do any left joins

[tsoct]

Hello @Brad Bowman  

I can see record count but no record is visible. Also when trying to filter user_name contains xxx. I got error message 'Error MessageSyntax Error or Access Rule Violation detected by database ((conn=2099688) Unknown column 'usr.user_name' in 'where clause')'

[Brad Bowman]

Can you view list views of each of the three tables individually?  You won't be able to add a contains to the Where clause, but can do that and other refinements with a query Business Rule using the database view as the table once you can view the records.

[Robbie · Accepted solution]

Hi @tsoct,

See the below tried and tested result on PDI.

Database view:

Results when hitting 'Try it':

Validation on record:

To help others (or for me to help you more directly), please mark this response correct by clicking on Accept as Solution and/or Kudos.


Thanks, Robbie