Home
Designing Analytics Reports
Using \ in a query.
Migrateduser
<p>Good evening!</p>
<p> </p>
<p>I would like to know is there a way to use a backslash \ symbol in a query of a report?</p>
<p> </p>
<p>I need to combine results of a query in one cell, for this I am using the next statement:</p>
<pre class="_prettyXprint">
sum(decode(DAS.C_APPEAL_SUBJECT,3,1,0))||''\''||sum( case
when DAS.C_APPEAL_SUBJECT = 3 and DAS.VALIDITY = 1 then 1
else 0
end),</pre>
<p>I want to get something like "1\1" in the cell itself.</p>
<p> </p>
<p>When I am using \ the report doesn’t work, it says about invalid character. Using / doesn’t work either, the report simply doesn’t display it.</p>
<p> </p>
<p>Is there a way to use a backslash or at least get / to be displayed? </p>
Find more posts tagged with
Comments
There are no comments yet