I work with this example :

IAgileSession session =AgileSessionFactory.createSessionEx(loginParams);
List notifyList =new ArrayList();
IDataObject user =(IDataObject)session.getObject(com.agile.api.IUser.OBJECT_TYPE,"JohnDoe");
notifyList.add(user);
user =(IDataObject)session.getObject(com.agile.api.IUser.OBJECT_TYPE,"JaneDoe");
notifyList.add(user);
IDataObject agileObject =(IDataObject)session.getObject(com.agile.api.IChange.OBJECT_TYPE,"C0001");
boolean urgent = true;
String comment ="Add ECO approver, Notify CA";
String template ="Automated SDK process added ECO approver";
session.sendNotification(obj,templateName,notifyList,urgent,comment);

You can use advanced search and find if you get any result
 if (title block.Number Equal to “parent number” and BOM.Item Number equal to “son number” 
then you continue to next number
else create new row with son number

I used “IUpdateTitleBlockEventInfo” event and check if “Dirtycell”  is not null.

This is example I used to add new value to list  “All Project reference”

// add new porjct to PrjectList
 IAdmin admin = session.getAdminInstance();
 IListLibrary listLib = admin.getListLibrary();
 // Get the Product Lines list
 IAdminList listProdLine = listLib.getAdminList("All Project reference");
 // Add values to the list
 IAgileList listValues = listProdLine.getValues();
 addToList(listValues,"Value name","API name","Description");
 listProdLine.setValues(listValues);

changeStatus(IStatus newStatus, boolean auditRelease, String comment, boolean notifyOriginator, boolean notifyCCB, Object[] notifyList, Object[] approvers, Object[] observers, boolean urgent)

nextStatus = change.getDefaultNextStatus();
 change.changeStatus(nextStatus, false, "", false, false, null, null,null, false);

Use this code :

ISaveAsEventInfo info = (ISaveAsEventInfo) request;
info.setCell(....);

Workflow Criteria Matching Type- Refines how the matching criteria determines which changes can follow the workflow. It defines what happens when a routable object meets one or more reusable criteria that contain information about affected items.

• Same — All affected items must match the same affected item–based reusable criteria, in this case, Libra Project.
• All — When multiple affected item–based reusable criteria are used as matching criteria, each affected item must match at least one affected item–based reusable criteria; however, each affected item does not have to match the same reusable criteria.
• Some — One or more (but not all) affected items must match the affected item–based reusable criteria, in this case, Libra Project.

We apply customization in my organization solves this requirement for all Agile users in a simple, easy and automatically.

If you would like more information about the solution, please contact me.

You can do it with Agile express:

• In stat-up window select to edit the file by click on “No” button

• Inside into part number/ document number  with attachment need to delete
• Select attachment
• Click on “Delete” selected file in right side

• In the end click “Save Package”  button

You can’t delete attachments from “PDX Package” tab.

Advanced option is to create privileges  “GET” attachments for files need to be in PDX. When user with these privileges  create PDX, it include automatically only files he has permission to download.

• “Privilege” type is Modify.
• “Privilege Criteria” need to be on process and step  they can do the change.
•  “Applied to” include Items.BOM. attributes ( as example Item.Bom.Item Number