Business Central AL customization filter issue

(1) Share

Report

Posted on by KAYKAY

Hi all,

Why is it not giving me only filtered Jobs based on Approved status?

tableextension 70001 "Purchase Line Ext" extends "Purchase Line"
{
fields
{
modify("Job No.")
{
TableRelation = Job."No." WHERE("Approval Status" = CONST(Approved));

}
}

Categories:

Business Central

All responses (2)

Answers (0)

YUN ZHU 73,565 Super User 2024 Season 2 on at

Like (1)

Report

Business Central AL customization filter issue

Hi, I also mentioned it in my blog, hope the following helps.

The TableRelation property can be modified through a table extension. Modifications to the TableRelation are additive and evaluated after the existing value.

https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/properties/devenv-tablerelation-property?wt.mc_id=DX-MVP-5004336

Thanks.

ZHU
gdrenteria 12,167 Most Valuable Professional on at

Like (0)

Report

Business Central AL customization filter issue

Hi

I hope this can help you and give you some hints

Dynamics 365 Business Central: Can we extend TableRelation Property through a table extension??? (Yes, But…) | Dynamics 365 Lab (yzhums.com)

BR

GR