Business Central AL customization filter issue

(1) Share

Report

Posted on by KAYKAY

173

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:

Dynamics 365 Business Central

I have the same question (0)

All responses (2)

Answers (0)

Gerardo Rentería Ga... 23,855 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

Was this reply helpful? Yes No
YUN ZHU 93,874 Super User 2025 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

Was this reply helpful? Yes No

Join the conversation

Community site session details

Business Central AL customization filter issue

Helpful resources

Quick Links

Responsible AI policies

Pallavi Phade – Community Spotlight

Congratulations to the October Top 10 Community Leaders!

Leaderboard > Small and medium business | Business Central, NAV, RMS

Featured topics

Product updates

Community site session details

Business Central AL customization filter issue

Helpful resources

Quick Links

Responsible AI policies

Pallavi Phade – Community Spotlight

Congratulations to the October Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Small and medium business | Business Central, NAV, RMS

Featured topics

Product updates