Find your people. Pick a challenge. Ship something real. The CreatorCon Hackathon is coming to the Community Pavilion for one epic night. Every skill level, every role welcome. Join us on May 5th and learn more here.

Database view

Go to solution
tsoct
Tera Guru

‎08-29-2024 07:13 AM

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_0-1724940784806.png

 

  • 1,437 Views
1 ACCEPTED SOLUTION

Go to solution
Robbie
Kilo Patron

‎08-29-2024 08:13 AM

Hi @tsoct,

 

See the below tried and tested result on PDI.

 

Database view:

Screenshot 2024-08-29 at 16.10.26.png

 

Results when hitting 'Try it':

Screenshot 2024-08-29 at 16.10.36.png

 

Validation on record:

Screenshot 2024-08-29 at 16.11.10.png

 

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

0 Helpfuls
10 REPLIES 10

Go to solution
Robbie
Kilo Patron
In response to Bert_c1

‎08-29-2024 08:45 AM

@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