How to get the value of relationship item type using the return value of fetchRelationships
hi,All 'my code 'This is the code I tried to write in VB Me.fetchRelationships("File") Dim file as Item = Me.getRelationships("File") Dim t_file_id as string If file.getItemCount()>0 Dim fileCnt as Integer=file.getItemCount() For x=0 To fileCnt-1 t_file_id = file.getItemByIndex(x).getProperty("related_id") file1= file.getItemsByXPath("Relationships/Item[@id='"+t_file_id+" ']") file1.getProperty("doc_name") ' return Not a single item Next End If 'file 'The value obtained is shown below How do I get the doc_name value? If somebody knows and can help I would really appreciate that. Thank you.How to use the result of getAssignedActivities() to get the value of the ID field
hi All, I used the getAssignedActivities() method from outside aras to find 14 pieces of data. But when I try to get the ID field using getItemByIndex(i).getProperty("ID"), he returns null //my code Item activities = inn.getAssignedActivities("Active", "B7E018BB45C40BB6BC48E3CA2612A971"); int actCnt = activities.getItemCount(); if (actCnt > 0) { for (int i = 0; i <= actCnt; i++) { string actId = activities.getItemByIndex(i).getProperty("ID"); } } Thanks.How to get items with all of its revisions with maximum generation
Hi, I am trying to get part all revision with maximum generation using IOM: below are the entries: Item Number Generation Revision Testnumber1 1 00 Testnumber1 2 00 Testnumber1 3 00 Testnumber1 4 00 Testnumber1 5 00 Testnumber1 6 00 Testnumber1 7 00 Testnumber1 8 01 Testnumber1 9 01 Testnumber1 10 02 so from above entries I want: Item Number Generation Revision Testnumber1 7 00 Testnumber1 9 01 Testnumber1 10 02 I got this result with below SQL: select item_number, MAX(generation) as generation, major_rev from innovator.PART group by item_number, major_rev order by generation but how to do this with IOM? Regards, Maddy.
