A forgotten corner of AL, saving Query Output

Find more information at my blog www.hougaard.com or follow me on / ehougaard
Source code can be found here: github.com/hou...

[@KletterKellerKind]

Nice video, Erik! If you use this detour in production, there will be problems with code fields that use only numbers or with the last name field of our favorite employee, John True, right? :D They would be converted to Decimal/Integer (if you add that) or boolean, respectively. Life would be easier if saveToJson was just one of the default options

[@lucianstinga1587]

Hi Erik ! It's possible to export the result of the query into a temporary table and , after that, export the temporary table to json ? It will be easier than using ExportToCsv function ?

[@Hougaard]

But that would require a table with the same fields, kinda "not easier" :)

[@ara3n]

XMLPort should be able to import/parse and export json file as well. MS doesn't want to add new feature to the XMLPorts, Same applies to Queries.

[@tetraquark2402]

Very nice. In the past I have often used STRPOS with commas in a loop replacing the found comma each time with another character not in the string to split it. I have never considered using character code 1 usually use ¬

[@ant1d0te]

Transaction No. converted into DateTime...

[@Hougaard]

Yeah, saw that afterwards, need different order of the ifs..