Urgent : Retrieve Level 1 and Level 2 text (codegroup & reason)

[Former Member]

CRM experts

Please let me know how to retrieve the codegroup and reason details for a CRM service order. We need to display this on the portal iview and hence want to build an rfc for the same.

Alternatively, is their a direct relation between crmd_orderadm_h and crmd_srv_subject or am i missing some links. how to go from guid from crmd_orderadm_h to crmd_srv_subject.

Please clarify.

[KaushalShah]

Don't know whether this reaches you in time or not...

get transaction guid from crmd_orderadm_h.

get guid_set from crmd_link where crmd_link-guid_hi = transaction guid and objtype_set = 29.

select guid from crmd_srv_osset where guid_set = guid_set found above in crmd_link table.

select * from crmd_srv_subject where guid_ref is in all guid's found above.

Regards,

Kaushal