How to include nested child entitlements in the Entitlement Owner Campaign

[Arbendra]

Hi All,

Is there any way to display all nested child entitlements in the Entitlement Owner campaign?

OR 

How to store all nested child entitlements under parent entitlement?

Existing scenario (data stored in the following way)

Ent1 (Parent)

Ent2(child entitlement of Ent1)

Ent3(child entitlement of Ent2)

Ent4(child entitlement of Ent3) and so on.

To be scenario(Requirement)

Ent1 (Parent)

Ent2(child entitlement of Ent1)

Ent3(child entitlement of Ent1)

Ent4(child entitlement of Ent1) and so on.

Currently, entitlement owner campaign shows only Ent2 as child entitlement of Parent Ent1 but we need to show all nested child entitlements like Ent2, Ent3, and Ent4 under Parent entitlement (Ent1).

[Darshanjain · Accepted solution]

Currently we are not showing the nested entitlements in the campaign . You can raise this in ideas portal as enhancement request if you need.

But if you still want the way the entitlements need to be stored , then all child entitlements must be tagged to only parent entitlement , so for this you need to alter the data and instead of nested you need to add them manually via csv files which is not recommended generally, 

[Arbendra]

Hi Darshanjain,

We have associated all child entitlements with the parent entitlement and are able to launch the entitlement owner campaign now we need to build a custom analytics report which pulls parent entitlement along with all child entitlement

the exact format that we are looking for is attached, please guide us 

[Darshanjain · Accepted solution]

Hi @Arbendra 

You should be able to get the Ent key from the below query, Modify it to get the names and you should be good to go

select cert.cert_name as cert_name,cert.certifier as certifier, cert.status as status,CERT_ENTITLEMENT_VALUEKEY,CERT_ENTITLEMENT_VALUE2KEY from certification cert,certification_entitlement2_status cert2 where cert.certkey=cert2.certkey and cert.cert_name = '{certname}';

Thanks

Darshan

[Arbendra]

Hi Darshan,

names are stored in the certification_entitlement_value table, I didn't find any way to read parent and their corresponding child entitlement names from this table

needs to establish links between the below 3 tables to read decisions on parent entitlement and child entitlement

certification_entitlement_value ( to read names for parent and child entitlements)
Cert_Ent_Values_Status ( to read parent entitlement decision)
Certification_Entitlement2_Status (to read child entitlement decision )

please guide us 

[Arbendra]

Hi Darshan,

Here is my query returning the names that I am looking 

select cert.cert_name as cert_name,cert.certifier as certifier, cert.status as status,cert2.CERT_ENTITLEMENT_VALUEKEY,cert2.CERT_ENTITLEMENT_VALUE2KEY , cevp.ENTITLEMENT_VALUE , cevc.ENTITLEMENT_VALUE as 'Child Ent' from certification cert,certification_entitlement2_status cert2 ,certification_entitlement_value cevp,certification_entitlement_value cevc

where cert.certkey=cert2.certkey
and cevp.CERT_ENTITLEMENT_VALUEKEY=cert2.CERT_ENTITLEMENT_VALUEKEY
and cevc.CERT_ENTITLEMENT_VALUEKEY=cert2.CERT_ENTITLEMENT_VALUE2KEY
and cert.cert_name like '{certname}';

[Darshanjain]

Hi @Arbendra ,

Yes, i just gave you a sample query which you can make use of to get the columns what you wanted. Above query looks fine and happy to hear that you got it resolved.

Thanks

Darshan