Skip to main content

Notifications

Announcements

Just out! June 2024 Dynamics 365 Community Newsletter
Community forum and blog attachments are now available!
News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics NAV forum / XMLPort Problem Filter...
Microsoft Dynamics NAV forum
Answered

XMLPort Problem Filtering table - .CSV output

(0) ShareShare
ReportReport
Posted on by troyh1968 45

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

Categories:
Development / Customization / SDK
  • troyh1968 Profile Picture
    troyh1968 45 on at
    RE: XMLPort Problem Filtering table - .CSV output

    Sorry for the delayed response.

    Setting it on the table data worked.

    Thank you

  • troyh1968 Profile Picture
    troyh1968 45 on at
    RE: XMLPort Problem Filtering table - .CSV output

    Sorry for the delayed response. This worked!

    Thank you

  • Verified answer
    Bodhi Profile Picture
    Bodhi 554 on at
    RE: XMLPort Problem Filtering table - .CSV output

    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);

  • Bodhi Profile Picture
    Bodhi 554 on at
    RE: XMLPort Problem Filtering table - .CSV output

    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);

  • troyh1968 Profile Picture
    troyh1968 45 on at
    RE: XMLPort Problem Filtering table - .CSV output

    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

  • Verified answer
    JAngle Profile Picture
    JAngle 33,135 on at
    RE: XMLPort Problem Filtering table - .CSV output

    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

Helpful resources

News and Announcements

Just out! June 2024 Dynamics 365 Community Newsletter
Community forum and blog attachments are now available!

Quick Links

Community Spotlight of the Month

Kudos to Mohamed Amine Mahmoudi!

Blog subscriptions now enabled!

Follow your favorite blogs

TechTalk: How Dataverse and Microsoft Fabric powers ...

Explore the latest advancements in data export and integration within ...

more Community News

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 284,876 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,425 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,146

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans