Saw expression filter not working
I construct the SAW Expression as below:
strBuf.append("<sawx:expr xsi:type=\"sawx:comparison\" op=\"equal\" ");
strBuf.append( " xmlns:saw=\"com.siebel.analytics.web/report/v1\" ");
strBuf.append( " xmlns:sawx=\"com.siebel.analytics.web/expression/v1\" ");
strBuf.append( " xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" ");
strBuf.append( " xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\">");
strBuf.append(" <sawx:expr xsi:type=\"sawx:sqlExpression\">\"- Material Cost Walk\".\"Request ID\"/sawx:expr>");
strBuf.append(" <sawx:expr xsi:type=\"xsd:decimal\">"+ map.get("requestId") +"</sawx:expr> ");
strBuf.append("</sawx:expr>");
map.get("requestId") would return 15 digit number like 200907201936598..
The posted SAW Expression looks like:
<sawx:expr xsi:type="sawx:comparison" op="equal" xmlns:saw="com.siebel.analytics.web/report/v1" xmlns:sawx="com.siebel.analytics.web/expression/v1" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"> <sawx:expr xsi:type="sawx:sqlExpression">"- Material Cost Walk"."Request ID"/sawx:expr> <sawx:expr xsi:type="xsd:decimal">200907201936598</sawx:expr></sawx:expr>
I have tried passing different xsi:type like decimal, number, string, double. Still the filter doesn't work.
Kindly let me know if there is any solution.
Thanks in advance,
Priya