I could probably give you a SQL query to do this, if that helps. I don’t know about Java code. It’s worth noting that users can belong to multiple groups, so providing a single user could produce multiple results.

I believe this is because you are connecting r.change = b.change_out when you’ve already specified that b.change_out = 0.

Change the last part of your query to b.change_in. If your organization also uses sites, you may have to specify a site ID, or at the very least add the following to your where clause:

and b.site = r.site

Hope that helps.

Based on a script I created years ago to correct sequence values after cloning from a production environment to a dev or test environment, numerous tables use the same sequence named AGILEOBJECTIDSEQUENCE. This includes ITEM_HISTORY.

We may not share the same version of Agile, because I cannot find “Complaints” as a class. If indeed Complaints is a class, then you will narrow it down to the subclass in order to get to the Page three attributes. In general however, multitext values are stored in the AGILE.AGILE_FLEX table. They must be referenced by the object’s ID and the attributes base ID. Here’s an example of a sub-query:

(Select Text From Agile.Agile_Flex Where Id = I.Id And Attid = 1568)

Where I.ID is the object’s ID and 1568 can be replaced with the base ID that you’re interested in.

Hope that helps a little. By the way, I doubt that Affected Items will be found in a multitext field unless that is just a term you’re using for this Complaints class. Typically Affected Items are found in the REV table on Change orders or Change Requests.  Attachments are also not in multitext attributes, but again… I’m not familiar with that class.

Svevis,

I’m not certain I can help or not, but to even start I have some questions. What is the input to this query? Are you starting with an item as the parent and providing a specific rev number? Then you want to see all its components at the time and what their rev values were?  Or are you wanting to just provide the parent number, and show ALL revs in one query result? Is this an exploded BOM you’re looking for or just top level under the parent item?

Steve

Clint, I see there’s still no answers on this. Did you find a way to do this? If not, I have questions. First, are you looking to just do a one-time operation of many parts, or are you looking to make a special version of Save-As to do this as needed, part by part? If you are looking to just recreate new versions of the parts, but with a prefix, you might just try exporting all the parts of interest, with all the applicable attributes, then update their part numbers in the excel file to include the prefix, then import them as new parts. Only you might lose is the info in the item’s history that indicates they were saved from another part.

Sabarish, If you’re using Microsoft Edge, this article info from Oracle Support may help.

CAUSE

Microsoft Edge is still not supported with Autovue for Agile PLM 21.0.1

SOLUTION

To implement the solution, please execute the following steps:

1. Upgrade to AutoVue for Agile PLM 21.0.2 or above.
   Refer to below Note to find the latest RUP available for AutoVue for Agile PLM 21.0.2:
   AutoVue 21.0.2 and AutoVue for Agile 21.0.2 RUP Releases (Doc ID 2507858.1)
   It is recommended to upgrade to the latest version of AutoVue for Agile
2. Apply the latest RUP to Agile 9.3.6.
   You may find the patch # of the latest 9.3.6 RUP from below Note:
   Note:2247729.1 ANNOUNCEMENT: Availability of Agile Release Update Packs (RUP)
3. Retest the case, and confirm you can view file using Microsoft Edge browser now

Yes and no… There are a couple of ways in the web client, but neither are all that much better than doing them individually, and the output format is pretty useless.  The best way would be to query the database directly. If you have access to do that let me know and I’ll see if I can provide a query for you.

Steve L.

I may not be the right person to answer this, but since no one else has tried…

Based on your error message (and the code in your loop), it looks like you are attempting to obsolete a value and then add a value at the very same parent index.  Actually, it looks like you’re obsoleting the parent and then trying to add a value to that parent.  If you’ve obsoleted it, the object is likely no longer valid.  You may have to do separate loops… one to obsolete,  then get the objects fresh and loop through to add what you need to.  This is not my area of expertise, but clearly you’ve altered an object and then attempting to do something with that object afterward. Is there some “refresh” command that you can instantiate somewhere within there?

Steve L.

Dear mfr5043,

To me this depends on what you’re defining as a work order.  If you’re looking to have Agile be an entry point, but have that integrated to some other system, such as Oracle EBS, then it seems to me that managing it directly in Oracle EBS may be better. If on the other hand, what you’re defining as a work order is solely entered into and managed within Agile, then that indeed does seem “easy enough”.  You could certain create custom Document objects to represent your Work orders. They could have all of the Page 3 attributes needed.  You could manage them on ECOs, create workflows for others to review or sign off, etc.  I’m not saying that integrating with other systems is impossible, but would certainly be more complex.  These are just my opinions 🙂

Regards,

Steve L.