Database view

tsoct · ‎08-29-2024

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.

Robbie · ‎08-29-2024

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

View solution in original post

Robbie · ‎08-29-2024

@Bert_c1- FYI - The 'sys_created_by' field within the journal table is a string field, not a reference, therefore sys_id will not work.

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