Tim – MyAgilePLM

LATEST ANSWERS

RE: I would like to know how ITEM_HISTORY.ID column value is populated? Which sequence is used By Kevin Cummings - on November 7, 2023
As noted by stevend17, AGILEOBJECTIDSEQUENCE was used to generate the ID for all tables in the database. For everything up...
RE: How to query past revisions of the parent in BOM to get revision shown for a child item? By Kevin Cummings - on November 7, 2023
Hoo boy, you aren't asking for much, are you?? I would venture that it cannot be done as "one query result"....
RE: I would like to know how ITEM_HISTORY.ID column value is populated? Which sequence is used By stevend17 - on November 1, 2023
Based on a script I created years ago to correct sequence values after cloning from a production environment to a...
RE: which query is used to get Multitext fields data in Agile PLM database? I need table names, column names... By stevend17 - on November 1, 2023
We may not share the same version of Agile, because I cannot find "Complaints" as a class. If indeed Complaints...
RE: How to query past revisions of the parent in BOM to get revision shown for a child item? By stevend17 - on November 1, 2023
Svevis, I'm not certain I can help or not, but to even start I have some questions. What is the...

©2024
Terms & Privacy

MyAgilePLM.com acts as a passive conduit for the online distribution of third party Advertisements and does not screen the content of such Advertisements. Pursuant to the foregoing, Client agrees that MyAgilePLM: (a) is not responsible for, and does not endorse, any Advertisements; (b) makes no guarantees about the accuracy, suitability, legality, reliability or quality of the information contained in Advertisements; and (c) assumes no responsibility for objectionable, inaccurate, misleading, or unlawful content within Advertisements.

ZipRecruiter special notice: Job offers are only for residents of the job’s location. No relocation. Please do not apply if otherwise!

- Questions
- Angel Expertise
- Badges
- Categories
- Users
LATEST ANSWERS
- RE: I would like to know how ITEM_HISTORY.ID column value is populated? Which sequence is used By Kevin Cummings - on November 7, 2023
  As noted by stevend17, AGILEOBJECTIDSEQUENCE was used to generate the ID for all tables in the database. For everything up...
- RE: How to query past revisions of the parent in BOM to get revision shown for a child item? By Kevin Cummings - on November 7, 2023
  Hoo boy, you aren't asking for much, are you?? I would venture that it cannot be done as "one query result"....
- RE: I would like to know how ITEM_HISTORY.ID column value is populated? Which sequence is used By stevend17 - on November 1, 2023
  Based on a script I created years ago to correct sequence values after cloning from a production environment to a...
- RE: which query is used to get Multitext fields data in Agile PLM database? I need table names, column names... By stevend17 - on November 1, 2023
  We may not share the same version of Agile, because I cannot find "Complaints" as a class. If indeed Complaints...
- RE: How to query past revisions of the parent in BOM to get revision shown for a child item? By stevend17 - on November 1, 2023
  Svevis, I'm not certain I can help or not, but to even start I have some questions. What is the...

©2024
Term & Privacy

Tim's Profile

Contact

Tim
Earth
Email is hidden.

Agile Angel
1030
Points

Questions
0

Answers
2

RE: I need a way to strip out attachments after a PDX package is created.
Agile Angel Asked on July 8, 2015 in ERP integration.
- Change Control Analyst
You would need to limit the user permissions that is exporting the pdx to only view types of files. A filter will only allow or disallow the file attachment tab.

There are also other pdx viewers.
- 2755 views
- 3 answers
- 0 votes
RE: what is difference between ECO and MCO ? Please explain with use case.
Agile Angel Asked on July 7, 2015 in Agile PLM (v9).
- Agile Administrator
- Change Control Analyst
I agree with Yuval. We use the MCO as more than just changing the AVL. We also use it to change the lifecycle status and other attributes including a saleable status for Marketing and Regulatory.

On the AVL we also have a status that drives incoming Inspection. That status is updated on an MCO.

We have an integration to ERP with several attributes in Agile. Those attributes are updated with an MCO.

We’ve expanded the MCO subclasses to cover these topics.
- 20046 views
- 5 answers
- 0 votes

- Questions
  1892
- Members
  1439
MyAgilePLM.com acts as a passive conduit for the online distribution of third party Advertisements and does not screen the content of such Advertisements. Pursuant to the foregoing, Client agrees that MyAgilePLM: (a) is not responsible for, and does not endorse, any Advertisements; (b) makes no guarantees about the accuracy, suitability, legality, reliability or quality of the information contained in Advertisements; and (c) assumes no responsibility for objectionable, inaccurate, misleading, or unlawful content within Advertisements.

ZipRecruiter special notice: Job offers are only for residents of the job’s location. No relocation. Please do not apply if otherwise!