Forum Discussion

Former_Member's avatar
Former_Member
Accelerator III
9 years ago

Parent BOMs where components have been deleted

I want to get the Parent parts for which there have been a deletion of a child component in the BOM structure. I need this data for the last 6 months. Through UI, I get the result by following below steps -
  1. Open the Part.
  2. Go to Part BOM Relationship.
  3. Click on Enable Redline Mode Relationship toolbar, if you see redline in the result, note the Parent part.
But it will take more than a month doing manually as data is very large. I can't really figure out how to do this through query. Please assist. I will really appreciate your help on this.

1 Reply

  • eli_donahue's avatar
    eli_donahue
    Community Manager
    9 years ago
    Hi Jasbir, I would probably approach this problem with a server action or a report that uses a server method. The pseudocode for the method would be something like:
    1. Get all Parts where the modified_on property is within the last 6 months and the major_rev property is not "A" (redline mode only works when a previous version was released).
    2. For each selected Part (Part A):
      1. Get the child Parts of the selected Part (Part A children).
      2. Get the previous version of the selected Part (Part B).
      3. Get the child Parts from the previous version (Part B children).
      4. Compare the config_ids of the Part A children to the config_ids of the Part B children. If the Part A children contain one or more config_ids that are not in the Part B children, one or more child items were removed from Part A's BOM since the previous version.
    Eli Donahue Aras Labs Software Engineer