I want to add filter on tablerelation where the "User Name" <> rec."User Name"

(0) Share

Report

Posted on by Muaaz Deyab

I want to filter on table relation so i get all the user except the user in the record, I tried to write it like this but it gives error
tablerelation = user."User Name" where ("User Name" <> field("User Name")
do you know any way I can do it like that?

All responses (4)

Answers (0)

Suggested answer

YUN ZHU 79,370 Super User 2025 Season 1 on at

Like (0)

Report

RE: I want to add filter on tablerelation where the "User Name" <> rec."User Name"

Hi, If it is a fixed value, it is possible, but for the field, it is recommended to use the method mentioned by Daniele and Nitin.

Hope this helps as well.

Thanks.

ZHU
Suggested answer

Inge M. Bruvik 999 Moderator on at

Like (0)

Report

RE: I want to add filter on tablerelation where the "User Name" <> rec."User Name"

I have not tested it myself. But there is a chance it could work if you use a filter value in your table relation instead of comparing two field values directly.

TableRelation = User."User Name" where ("User Name" = filter (<>= %1),User."User Name");

learn.microsoft.com/.../devenv-tablerelation-property
Suggested answer

Nitin Verma 21,465 Moderator on at

Like (0)

Report

RE: I want to add filter on tablerelation where the "User Name" <> rec."User Name"

Hi,

the operator <> you used is not possible to put here with this property, You can use either Onlookup of that field trigger.

trigger OnLookup()

begin

...

end;
Suggested answer

DAnny3211 9,274 Moderator on at

Like (0)

Report

RE: I want to add filter on tablerelation where the "User Name" <> rec."User Name"

hi

it is not feasible to do what you wrote

you'd better do a lookuo in AL in the onlookup trigger of the field

https://yzhums.com/5985/

DAniele