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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / XMLPort Problem Filter...
Small and medium business | Business Central, N...
Answered

XMLPort Problem Filtering table - .CSV output

(0) ShareShare
ReportReport
Posted on by troyh1968 47

I have an XMLPort that I have created and I cannot get the table to filter correctly. I have used the SETFILTER variable to only list out ‘Released’ Production Orders. This is on the line as all the info I need is on the line. I am filtering for 'Released' only in SETFILTER. When I do this on the table in the DEV environment It filters correctly. When I run the XMLPort I get what I want except for the first line. I cannot figure out why it is doing this.

Thank you in advance for any help

TroySETFILTER-Image.png

Result-of-XMLPort.png

I have the same question (0)
  • Verified answer
    JAngle Profile Picture
    JAngle 133 on at

    Try using setrange instead of setfilter. The field in question is an option field so the syntax is specific “Prod. Order Line”. Setrange(status, “Prod. Order Line”.Status::Released).

    Failing that you can set these types of filters on the table data item of the XML port instead of in code. Highlight the line and choose the properties to open table filter edit window

  • troyh1968 Profile Picture
    troyh1968 47 on at

    Josh Thank you for the help. I tried both options you gave and neither worked. I am still getting the same result 1 record that the filters should remove.

    A little more background on this XMLPort. It is going to be automated with a code unit to run through the Job Queue on a schedule. Not sure if this will change anything I have to do.

    Thanks,

    Troy

  • Bodhi Profile Picture
    Bodhi 558 on at

    1, we should put the filter under Export::OnPreXMLItem()

    2, Syntax:

    "Prod. Order Line".SETFILTER("Prod. Order Line".Status,'%1',"Prod. Order Line".Status::Released);

    or

    "Prod. Order Line".SETRANGE(Status,"Prod. Order Line".Status::Released);

  • Verified answer
    Bodhi Profile Picture
    Bodhi 558 on at

    Prod. Order Line - Export::OnPreXMLItem()

    "Prod. Order Line".SETFILTER("Prod. Order Line".Status,'%1',"Prod. Order Line".Status::Released);

    or

    "Prod. Order Line".SETRANGE(Status,"Prod. Order Line".Status::Released);

  • troyh1968 Profile Picture
    troyh1968 47 on at

    Sorry for the delayed response. This worked!

    Thank you

  • troyh1968 Profile Picture
    troyh1968 47 on at

    Sorry for the delayed response.

    Setting it on the table data worked.

    Thank you

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,577

#2
YUN ZHU Profile Picture

YUN ZHU 888 Super User 2025 Season 2

#3
Jainam M. Kothari Profile Picture

Jainam M. Kothari 778 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans