New Breakdown source

[Stimson]

Hi Everyone, 

I'm trying to create a new breakdown source called parent product, I'm referring to a similar indicator source but cannot find out the element. 

Can someone help me find the element's name for the parent product in the choice [sys_choice] table?

New breakdown source:

Reference:

[AndersBGS · Accepted solution]

Hi @Stimson ,

Sure:

1. Create the breakdown source:

2. Create automated breakdown

3. Create breakdown mapping in the automated breakdowns related list.

(Notice that "field" is parent.product)

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

Best regards

Anders

[AndersBGS · Accepted solution]

Hi @Stimson ,

Sure,

What i knew from the start was what you stated initial "element's name for the parent product" and that you referred to the sn_customerservice_case table (due to the screenshot you send).

According to above, I went to the sn_customerservice_case in my PDI and looked at parent field which referred another case in the sn_customerservice_case. Based on this, I looked at the field configuration through the "form Design" as showed below:

This will show that, the field reference "cmdb_model"

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

Best regards

Anders

[Stimson]

That was very helpful @AndersBGS, I have one final question, even though I've added few conditions on the top of the breakdown source. There are duplicates.

When I visited the product model table and grouped the table by parent there are only 122 of them. 

Is it possible to have a group by in the breakdown source?

With the condition on top of the breakdown source, I have  1,12,061 records, So it is impossible to add it breakdown as it goes beyond the limit.

Any idea for resolving it?