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,407 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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,786 Moderator on at

Like (0)

Report
Copy link

Link copied!

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,161 Moderator on at

Like (0)

Report
Copy link

Link copied!

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 97,970 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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