I don’t think it’s possible to user groups because the attribute Delegated Owner on Activities’ Title Block is a list type attribute which accepts only User objects.

For implementing Step 2 of your requirement, here is a simple piece of code:

ITable table = change.getTable(ChangeConstants.TABLE_WORKFLOW).where(“[“+ChangeConstants.ATT_WORKFLOW_ACTION+”] In %0 AND [“+ChangeConstants.ATT_WORKFLOW_WORKFLOW_STATUS+”] In %1″, new String[]{“Awaiting Approval”,”Your workflow.Current Status”});

This will return a filtered workflow table for the current status where Action is only Awaiting Approval. If this table.size() == 1, that means only one reviewer is left to approve the change. Then you can go ahead for the validations in steps 2a, b & c.

It would have been possible, if you could set the Default Value of the Activities.Title Block.Schedule Start Date attribute’s value to $NOW. But unfortunately that’s not a feasible option for Title Block attibutes. So I don’t think there’s any way to achieve the requirement you want without writing a Post Event on Create Object or Save As Object.

By the way, when you create any new Task or Activity, then by default the current day & 8:00 AM is taken as the schedule start date. So unless you wanna use the exact current timestamp, I don’t think you don’t even need any custom program to set that & let Agile handle it or modify manually during or after creation.

Hi Jason,

If you wanna get the exit required fields from a workflow criteria with SDK, here is the piece of code you can use:

IWorkflow wf = (IWorkflow) session.getAdminInstance().getNode(NodeConstants.NODE_AGILE_WORKFLOWS).getChildNode(“My Sample Workflow”);
INode child;
for(IStatus status : wf.getStates()){
              System.out.println(“For status “+status.getName());
              for(Object obj : status.getChildNodes()){
                          child = (INode)obj;
                          for(Object o : child.getChildNodes()){
                                  System.out.println(“For workflow status criteria: “+((INode)o).getName()+”, the exit required field is: “+((INode)o).getProperty(new                                                                    Integer(202)).getValue().toString());
                          }
              }
}

Hi Jason,

If you’re okay with it, my recommendation will be to write a small & nice event on Approve/Reject action of the ECO to show the users that some of the exit required fields are not filled in.

I don’t see any option to restrict it from criteria level of the Approve/Reject privilege because Agile doesn’t allow using any Redline Item attribute’s value for Approve/Reject type of privilege.

Hi Vidya,

I am safely assuming that you are asking about the Title Block attributes (including Page 2 & 3) which are change controlled. One way is to customize the layout of Item Attribute History Report (to include the necessary Page Two & Three attributes) and run it for the item.

But since you want to use Agile SDK, I don’t see any option to generate a report to view the history of attribute value changes through all revisions.

However, you can get the old value which was redlined with a ECO/MCO for a particular revision, like this (giving example for PageThree.List01 attribute):

IItem item = session.getObject(IItem.OBJECT_TYPE, “P00001”);
item.setRevision(“C00001”);
IRow row;
for(Object obj : item.getTable(ItemConstants.TABLE_REDLINEPAGETHREE){
      row = (IRow)obj;
      System.out.println(“Cell old value is: ” +row.getCell(ItemConstants.ATT_PAGE_THREE_LIST01).getOldValue());
      System.out.println(“Cell current value is: ” +row.getCell(ItemConstants.ATT_PAGE_THREE_LIST01).getValue());
}
Hope this helps.

Matt, please do not add the http://agile:port/Filemgr/AttachmentServlet before the IFS_FILEPATH value you get from DB. What should be concatenated as a prefix with that value, is the base storage directory folder path which you will get either from vault table of DB or from java client configuration of file manager. So if the base storage directory of your system is defined as C:AgileFiles

then you should be using this to get the file from the vault:

InputStream is = new FileInputStream(new File(“C:/AgileFiles/000/770/474/agile77047111.pdf”));

Hi Matt,

Do not append the FileManager URL with C:/AgileFiles/ (base storage directory of vault) + IFS_FILEPATH. The vault’s base storage directory path concatenated with the IFS_FILEPATH is sufficient enough to get the physical files. Let me know if that works.

Hi Karthiga,

If you import a agile db dump in a fresh agile installation, it will copy all the data + configuration from the source environment. If you want to only import the configuration data, then please follow the instruction of this KB: 

What Are the Steps for Exporting a Subset of Cleansed Database Tables, Containing Admin Data, from an Agile PLM System? (Doc ID 2159773.1)

Remember, the reverse is not possible. Hope this helps you with your query.

Hi Nikhil,

Agree with what Carlos said. No need for any custom development as it can be done from Java client configurations itself. See below example pic. You have to do similar kind of update as per your requirement: