web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Answered

New CUE with Multi Filters to diferent tables

(0) ShareShare
ReportReport
Posted on by 95
Hello everyone,
I'm creating a CUE to get the sales shiptmen lines pending invoicing, but I would like it to show the information filtered by ID assigned to the sales order of the logged in user.
the filter i am using is  CalcFormula = count ("Sales Shipment Line" where("Type" = Filter(Item | Resource | "G/L Account"), "Qty. Shipped Not Invoiced" = Filter(<> 0)));
but i dont now how i add the filter to the Sales Header ID user. in Sales Shipment Line i have the Nº order to relation both tables, but i dont know how i can do it.
I am noob in AL programing.
Regards,
I have the same question (0)
  • Suggested answer
    Thomas Brownell Profile Picture
    Microsoft Employee on at

    Hello,

    It sounds like what you need to use is an Query object.  With a Query object, you will be able to join the two or more tables.  Then on the CUE table you will need to create a new normal field that gets populated through AL code.  In the AL code you will need to at least initialize the value in the page OnOpenPage trigger.  I have included some links to our documentation that should help:

    • Query Object: docs.microsoft.com/.../devenv-query-object

    • Creating CUEs: docs.microsoft.com/.../devenv-cues-action-tiles

    • Page Triggers: docs.microsoft.com/.../devenv-page-and-action-triggers

    Best Regards,

    Thomas Brownell

    Sr Support Engineer

    Dynamics NAV/Business Central

  • Verified answer
    Business Central Profile Picture
    95 on at

    Hello,

    I have been able to solve it with a query as indicated.

    Thank you

  • Verified answer
    Terrance Morgan Profile Picture
    515 on at

    Select Data > Edit Relationships.

    In the Edit Relationships dialog box, do the following:

    Select a data source for Primary data source, and select a data source for Secondary data source.

    Select Custom.

    To define a relationship between fields that have different names, click Add.

    To edit an existing relationship, select the fields on the right, and then click Edit.

    In the Add/Edit Field Mapping dialog box, do the following, and then click OK:

    Under Primary data source field, select a field.

    Under Secondary data source field, select a field with similar data to the field you selected for the primary data source.

    For more information about editing relationships, see Blend Your Data.

    --
    Terrance | Apps4Rent

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,055 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,063 Super User 2026 Season 1

#3
Dhiren Nagar Profile Picture

Dhiren Nagar 1,014 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans