Filter data before XMLPort.Export()

(0) Share

Report

Posted on by Mohsin Abbas

525

Hi
I want to export XMLPort's data into a text variable after applying some filters. Currently I have this:

procedure GetJobTasksList(): Text

var
JobTask : Record "Job Task";
tempBlob: record TempBlob;
IStream: InStream;
Ostream: OutStream;
StreamText: text;
JTXmlport:  Xmlport 50000;
begin
  TempBlob.Blob.CreateOutStream(Ostream);
   //JobTask.Setfilter(/*filters*/)
  //JTXmlPort.SetTableView(JobTask)
  Xmlport.Export(50000, Ostream);
  tempblob.blob.CreateInStream(IStream);
  tempblob.CalcFields(blob);
  StreamText := Base64Convert.StreamToBase64String(IStream);
  exit(StreamText);
end;

If I use SetTableView on XMLPort variable (JTXmlPort) and then Use the Xmlport.Export() function it doesn't work and that makes sense. I need to be able to find a way so that I can export the data to a text variable but it should be filtered.

Categories:

Business Central

Other

All responses (1)

Answers (0)

Suggested answer

Mohsin Abbas 525 on at

Like (0)

Report

RE: Filter data before XMLPort.Export()

After a bit of searching I got to know that I was ignoring an optional parameter of the xmlport.Export() function. After applying filters on JobTask record, it can be sent as a parameter like this:

JobTask.Setfilter(/*filters*/)

JobTask.Findset;

Xmlport.Export(50000, Ostream,JobTask);