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

Query Filter Issue with Open in Excel

(0) ShareShare
ReportReport
Posted on by 3,297

Hi Guys

I have created a query on item table and published to the Item list page using query category.  All works when viewing the report in browser, however when opened in excel , column that has the filter gets removed and all other columns misalign. Filter is something like below on the item tabel:

            filter(Location; Location)

             {

                 ColumnFilter = location = const('East');

            }

I'm wondering if there is another way to filter item table (this is the first table in the query so not sure how to use DataItemTableFilter

Thanks

I have the same question (0)
  • Verified answer
    AliHamza Profile Picture
    175 on at

    Hi Samantha,

    This will work for you:

    dataitem(ItemTable; Item)

               {

                   DataItemTableFilter = Locations = CONST('East');

                   column(column1; column1)

               }

    OR 
    you can add the following code to the OnBeforeOpen trigger of the query object to change the filters 
    currQuery.SETFILTER(Location, 'East);


    Please Verify the answer if your question has been answered. This helps other forum users.

    regards,

    Ali Hamza

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 1,986 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,071 Super User 2026 Season 1

#3
Dhiren Nagar Profile Picture

Dhiren Nagar 975 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans