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.

[tsoct]

Hello @Robbie ,

Thanks. This is the error when i clicked on try it

[Robbie]

Hi @tsoct,

This is strange. You've copied the database view exactly right...

Can you entertain me (in case of any weird caching etc), can you change the 'Variable' prefix on the 3rd line from 'usr' to 'user' and update the 'where' condition the same please: user_user_name=jou_sys_created_by

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

[tsoct]

This did the trick! Thank you!

[Robbie]

Hi @tsoct - No worries at all.

Happy Thursday ; )

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

[Bert_c1]

try the following for the where clause 'usr_sys_id=jou_sys_created_by' on the 3rd line.

edit: i see that is wrong due to the type of sys_created_by as was pointed out.