Nicho247 – 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

Nicho247's Profile

Contact

Nicho247
Earth
Email is hidden.

Agile User
36
Points

Questions
5

Answers
6

Help with attachment_map table
Hello All – I am attempting to write a SQL query which provides the URL to download an attachment when …
Agile Administrator

API Developer

IT Manager

Nicho247 Agile User Asked on September 30, 2016 in Agile PLM (v9), Product Collaboration.
- 2106 views
- 1 answers
- 0 votes
Help retreiving BOM comments via SQL
Agile Administrator

System Analyst

Nicho247 Agile User Asked on July 28, 2016 in Agile PLM (v9), Product Collaboration.
- 3246 views
- 3 answers
- 0 votes
Help properly joining to the BOM table
Hi There – I have recently succeeded in linking an excel spreadsheet to our Agile database. I am quite happy …
Agile Administrator

System Analyst

Nicho247 Agile User Asked on July 27, 2016 in Agile PLM (v9), Product Collaboration.
- 2959 views
- 9 answers
- 0 votes
How to locate attachments in my Agile server
Hello – I have Agile PLM, and we are working on an IT project to map our homegrown web portal …
Agile Administrator

IT Manager

System Analyst

Nicho247 Agile User Asked on June 8, 2016 in Agile PLM (v9), Product Collaboration.
- 3501 views
- 3 answers
- 0 votes
SQL help with breaking down multiple values
Hi There – I have the Agile PLM PC module. Just recently I have gotten into the database and have started …
System Analyst

Nicho247 Agile User Asked on April 28, 2016 in Agile PLM (v9), Product Collaboration.
- 2854 views
- 4 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!