TU_YINING さんのグループアクティビティ

How to get parent Item type recursively

Maddy — Tue, 02 May 2017 09:24:34 GMT

I have structure where, I have to find all the parent Item in my BOM tree, so How to find it by aml query, or any server side method for finding all parent Item in BOM.

Create Hyperlink directly to an Item's Graph Navigation View

TU_YINING — Thu, 05 Nov 2020 07:30:43 GMT

We know that we can assign an Item to hyperlink to open it directly like this:
http://{server}/?StartItem={ItemType}:{ID}
Is there anyway to do it with starting from the Item's Graph Navigation view?

Ask A Question I

Wed, 16 Sep 2020 09:10:25 GMT

Ask a question in a forum.

Build query by using value that not directly related

TU_YINING — Wed, 16 Sep 2020 09:10:25 GMT

My original goal was to start a graph navigation with multiple items ( in condition)
So I try to do this way. (Assume all part are created by same user)

Start graph navigation from Part A

Use Case: to connect to all Part that having same property value with Part A (and further)

The query is like:
1.Part
↓ (created_by_id)
2.User
↓ (filter like 1.Part.para1 = 3.Part.para1)
3.Part

How can I get the [Part A].para1 value to fill in the filter?

The image of query in SQL is like this:

SELECT something
FROM Part p1
LEFT JOIN USER u1
ON p1.CREATED_BY_ID = u1.ID
RIGHT JOIN Part p2
ON u1.ID = p2.CREATED_BY_ID
WHERE p1.id = '{Part A ID}' AND p2.para1 = p1.para1

TU_YINING さんの グループ アクティビティ

How to get parent Item type recursively

Create Hyperlink directly to an Item's Graph Navigation View

Ask A Question I

Build query by using value that not directly related

TU_YINING さんのグループアクティビティ