Small and medium business | Business Central, N...

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?

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

DAnny3211 11,397 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

Nitin Verma 21,698 Moderator on at

Like (0)

Report

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;

Was this reply helpful? Yes No
Suggested answer

Inge M. Bruvik 1,105 Moderator on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,329 Super User 2025 Season 2 on at

Like (0)

Report

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

Was this reply helpful? Yes No