RDD BAQ PARAMETER - Parse XML code

Epicor ERP 10
11

Just wanted to add that you can create your own dataset in the report and/or just add this to the where clause in your main dataset query since SQL supports XML. you just need to know how your xml is being formatted in the BAQRptParameter table.

SELECT
XmlData.value(‘(Customer_CustID/text())[1]’, ‘VARCHAR(MAX)’) AS CustIDs,
XmlData.value(‘(ProdGrup_ProdCode/text())[1]’, ‘VARCHAR(MAX)’) AS ProdGrups
FROM (
SELECT CAST(Filter2 AS XML) AS XmlData
FROM BAQReportParameter_0eb5a4db866a423a83f5022e436aa9d5
) AS ParsedXml

This snippit above gets both my filters and put the value in their own fields called CustIDs and ProdGrups, respectively. You could use this however you want, but it might be easier for some to do it in SQL than VB code.