How can I create relationship to show approvers on task level

[SN2024]

I am trying to show approvers for the REQ and RITM on Task level so the resolvers don't have to go to the REQ or RITM to view the approvers.

I tried to create Relationship in system definition but it didn't work. still showing no approvers on Task "Approvers" tab

Relationship :

Applies to Table: Catalog Task [sc_task]

Queries from table: Approval[sysapproval_approver]

with Query:

var enc = "document_id=" + parent.request_item;

current.addEncodedQuery(enc);

Looking for some help and guidance on this.

Thank you.

[Chaitanya ILCR · Accepted solution]

Hi @SN2024 ,

create a relationship

configure related list on sc task and add the relationship to it

Please mark my answer as helpful/correct if it resolves your query.

Regards,
Chaitanya

[shun6]

@SN2024 

Since "document_id"  is sys_id of the record stored at Approval[sysapproval_approver] itself, use the "Approval For" field for queries instead.

current.addQuery("sysapproval", parent.request_item)

Thannks.

[Ankur Bawiskar]

@SN2024 

try this -> the document_id field is wrong field, the correct field is sysapproval

var enc = "sysapproval=" + parent.request_item;
current.addEncodedQuery(enc);

If my response helped please mark it correct and close the thread so that it benefits future readers.

[SN2024]

Thank you for your response.

I have tried this in the developer instance but no luck. It doesn't show approvers list on task level.

 

[Chaitanya ILCR · Accepted solution]

Hi @SN2024 ,

create a relationship

configure related list on sc task and add the relationship to it

Please mark my answer as helpful/correct if it resolves your query.

Regards,
Chaitanya