Trying to make a Join between change_request and sys_user tables

[lonesoac01]

Hello all,

     I am interested in making a join between the two tables of: change_request and sys_user tables.  The original EncodedQuery I have is: 

'approval=rejected^assignment_group.manager=sys_user.sys_id'

I know I am close, I am just not getting it.

[Brad Bowman]

I would first try taking out the first condition to make sure the second works, then when you add it back in use && in place of ^.  Also remove the quotes for a where clause on a database join, and change the Order of one of the tables to 200 (if you're doing a left join, make that table the higher order) and put the Where clause also on that table.

[Brad Bowman · Accepted solution]

In thinking about this some more, you can't dot-walk in a Where clause, that's another table join, so I think this is what you are after - without any left joins, because that doesn't seem to make sense in this case.

[lonesoac01]

Thank you Brad!  This is just what I was looking for!

[Brad Bowman]

Awesome.  Happy to help!