36
Points
Questions
5
Answers
6
-
- 2963 views
- 9 answers
- 0 votes
-
I think LIST01 has values since there is something there, but don’t know what it is yet. After determined, I’ll set an alias. Need to do for LIST02, and the Change_out/in dates. In this query, the entryvalues display as null.
SELECT AGILE.ITEM.ITEM_NUMBER AS “PARENT ID”,
AGILE.ITEM.DESCRIPTION AS “PARENT NAME”,
AGILE.BOM.ITEM_NUMBER AS “CHILD ID”,
AGILE.BOM.QUANTITY AS QTY,
AGILE.BOM.TEXT04 AS TORQUE,
AGILE.BOM.LIST01,
AGILE.BOM.LIST02,
AGILE.BOM.CHANGE_OUT,
AGILE.BOM.CHANGE_IN,
AGILE.BOM.PRIOR_BOM,
AGILE.BOM.COMPONENT,
AGILE.LISTENTRY.ENTRYVALUE
FROM AGILE.BOM
INNER JOIN AGILE.ITEM
ON AGILE.ITEM.ID = AGILE.BOM.ITEM
LEFT JOIN AGILE.LISTENTRY
ON AGILE.BOM.LIST01 = AGILE.LISTENTRY.ENTRYID
WHERE AGILE.ITEM.ITEM_NUMBER = ’01-08197′- 2963 views
- 9 answers
- 0 votes
-
- 2963 views
- 9 answers
- 0 votes
-
- 3507 views
- 3 answers
- 0 votes
-
- 4570 views
- 4 answers
- 0 votes
-
Hello Kevin – I am a noobie, similar to pranitchaudhari, though I have succeeded in writing a query to get most general item data. I unfortunately am struggling to find where lifecycle status’s are kept. I suspect it may be OBJVERSIONon the ITEM table, but cannot find where that refernece is stored. I tried ITEM, PAGE_TWO, PAGE_THREE, REV, BOM, CHANGE, NODETABLE and LISTENTRY and AGILE_FLEX.
Any help would be greatly appreciated.
Nick
- 4570 views
- 4 answers
- 0 votes