Database view for sysapproval and change request tables?

[therese_erickso]

I am attempting to create a database view for the first time and struggling to join the sysapproval_approver table and the change_request table.

So far everything I have tried as returned no results. Can anybody walk me through this?

Thanks.

[PeterWiles]

What have you tried?

What fields are you attempting to join on? Have you a screenshot of what you have so far?

Pete

[therese_erickso]

Hi Peter,

Here's what I've got so far. The only fields I have currently are:

For change request --- parent, short description, number

For sys approval -- approver, state, sysapproval

Ultimately I would add more fields than this, but I'd like to actually get something working before doing that.

I'm assuming my where clause must be off, but I'm not sure how to correct it.

[PeterWiles · Accepted solution]

Amend "chg_number" to "chg_sys_id"

chg_number is a string field where appr_sysapproval is a reference field and is expecting a sysID

Pete

[therese_erickso]

Thank you! This all it needed. Phew; much appreciated.