When I return data from an index via a roxie service, if all the data in a column in the filtered dataset being returned is empty, that column is dropped from the json/xml returned from roxie.
If even one record has a value in this column, all columns are returned.
My service consumer is expecting all index fields to exist, with empty fields being empty, in the json being returned.
Example service soap call:
<?xml version="1.0" encoding="utf-8"?>
<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" xmlns:SOAP-ENC="http://schemas.xmlsoap.org/soap/encoding/">
In the result, VIew_FnameDetails should have a home_clean_fname field, but because all the records returned with the above query have the row empty, it's not in the xml. (It does show up in the esp form for this Roxie query.
<Dataset xmlns="urn:hpccsystems:ecl:drealeed_testcleanpersonnameprefix.ins002_service:result:view_fnamedetails" name="View_FnameDetails">