Map Linked Requests number to a custom field

[Adith]

Hi Team,

We are trying to map the linked requests reference number to a custom field in our workflow. When trying to map the value of Linked Requests, it says 'A count of the number of requests the specified request is related to'. We would need the reference number of the linked requests rather than the count. Is there a way we can get the reference numbers of linked requests on a request.

Could you help in finding a solution for this.

Regards

Adith

[Adith]

Hi Team - Could we please have an update on this ?

 

[Steve Giller]

16 hours ago, Adith said:

When trying to map the value of Linked Requests, it says ...

Can you clarify this please? ... i.e. what says?

[Adith]

hi @Steve Giller - Sorry for the confusion. The tooltip says that, please find below

We thought that we can get the linked requests reference number using 'Linked Requests' parameter, but it only gives the count. Is there a way we can get the actual reference number ?

[Steve Giller]

@Adith I'm afraid I'm still guessing at this point, but is that the Get Request Details node?

8 minutes ago, Adith said:

We thought that we can get the linked requests reference number

This is not available as it could contain 0, 1, or multiple values - how would you envisage the output being presented, and once you had a (potentially unlimited) list of Request References how would this be used?
 

[Adith]

@Steve Giller - yes, that's from Get Request Details node.

Our use case is that, we would like to store the linked requests reference number into a custom field and then generate a report using that custom field value.

For example : to generate a report on Incidents linked to Problem tickets. We thought of getting the problem ticket reference that is linked with the Incident to be stored in a custom field and generate report using that custom field value. 

If there is a much better way of doing this kindly do let me know

[Steve Giller]

Relationships between Entities are stored in the h_sm_relationship_entities table, if you're wanting this information for a report that would be the best starting point.

[Adith]

@Steve Giller Thanks for that. It helped in setting up the report