Discussions
Categories
Groups
Community Home
Categories
INTERNAL ENABLEMENT
POPULAR
THRUST SERVICES & TOOLS
CLOUD EDITIONS
Quick Links
MY LINKS
HELPFUL TIPS
Back to website
Home
Intelligence (Analytics)
Using \ in a query.
alecsia
<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
shamo
<p>why don't you sum them separate and then concatenate them after using a computed column?</p>
alecsia
<p>Indeed, very obvious solution!)</p>
<p>Thank you, I will use this!</p>