Hello! I'm trying to create datasource from SQL query like:
select x.* from xml_tbl t_xml , XMLTable('/PROPERTY' passing xmltype(t_xml.xml_blob, nls_charset_id('CL8MSWIN1251')) columns Property_Count for ordinality, Street varchar2(100) path 'ADDRESS/PARSED_ADDRESS/Street', HouseNo varchar2(10) path 'ADDRESS/PARSED_ADDRESS/HouseNo', ConstructionNo varchar2(10) path 'ADDRESS/PARSED_ADDRESS/ConstructionNo', ValuationDate date path 'VALUATION_ITEMS/VALUATION/AppraisalDate', AppraisedValue number(18,2) path 'VALUATION_ITEMS/VALUATION/AppraisedValue', SFTB_Property varchar2(16) path 'PropertyID') x where t_xml._id=....
So, I'm using xmltable to map xml content into relation data table. Datasourse columns were succesfully populated after applying changes to new datasource. But I 'm getting no rows while outputing datasource into the grid...
asked 28 Jan '13, 01:07
Formspider supports the use of xmltable in datasource definition query, therefore you should be able to use your datasource without problem. Please check the following:
If the solutions above don't help, please send your panel XML and an example data to email@example.com
answered 28 Jan '13, 05:43
Ibrahim Sand... ♦♦