Ask A Question I

Thu, 11 Jul 2019 14:10:37 GMT

Ask a question in a forum.

Usage of the Where Condition in the Query Builder

MGroll — Thu, 11 Jul 2019 14:10:36 GMT

Dear Aras Community,

I have a problem with the following scenarion:

I have an ItemType A an ItemType B and a Relationship ItemType BA from B to A.

Now I have Item B1 related to A1 and A2 with the Relationships BA1 and BA2, like following:

A1 <---BA1--- B1 ---BA2---> A2

I created a Query with the Query Builder to create a Tree Grid View on the ItemType A. With this Query I want to see e.g. from A1's POV to which other A's B1 is related. The problem is that I always get shown the starting Item (in this example A1) as well.

The Query looks like following;

Item_A_1

[Item_A_1.id = [Item_BA related_id].related.id] Item_BA related_id

[Item_BA related_id].source_id = Item_B Item_B

[Item_B.id = [Item_BA].source_id] Item_BA

[Item_BA].related_id = Item_A_2.id Item_A_2

Of course this Query will return A1 and A2 because B1 is related to both of them.

This is why I tried to define a Where Condition on the last Query line: Item_A_2.id != Item_A1.id but this does not work. If I hardcode the ID of Item_A1 it works but of course this is not a solution.

How can I solve this Problem?

Thanks for your help in advance.

Max

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

Ask A Question I

Usage of the Where Condition in the Query Builder

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