Inbound Email in different table

[Jeck Manalo]

is there a way to call if the target table is diffent.

let say I like to close the sctask state and not ritm only.

[jMarshal]

the reason why it's not working for you is because there is no single value of "sc_task" associated with an RITM...there can be several/many tasks...which one do you want to update the state of?

You'll need to glide from the RITM table to SCTASK where the parent of the task is the RITM and then another qualifier (all returned associated tasks or certain ones?) -- and then update the state of the returned values.

[Jeck Manalo]

to update the sctask on the RITM which is triggered.

[jMarshal]

right -- except there is a many to one relationship there.

I assume (based on your reply) that your organization just so happens to have most (all?) workflows creating a single sctask from a catalog item...so likely you'll be ok writing this as a glide to the sctask table where the update is on the first task returned by the query...but I would caution this as a solution because you will likely get get unexpected results if/when you ever have a catalog item creating more than one sctask in succession. I'd recommend speaking with the application owner to ensure the requirements are understood -- are you closing ALL associated tasks or a specific one...if specific, how will it be identified (does it have a unique short description, perhaps?).