Period in query breaks query

Question

Hi everyone, wondering if anyone else has come across this.

I run this query and it works fine in API Browser, but in a community component it says the query is null:

"SELECT id FROM messages WHERE board.id = 'starkb' AND subject MATCHES 'Twitter Starbase 1.0'"

If I cut off the ".0" it works. Seems to be the period.

In this case I could query without the last two characters, but long term that could get me the wrong message, depending on where the period shows up.

Any way to work around or fix that period problem?

perbonomi · Answer

&lt;#assign count= rest("2.0","/search?q=" + "SELECT count(*) FROM messages WHERE board.id = 'starkb' AND subject MATCHES 'Twitter Starbase'"?url).data.count /&gt;
${count}Gives&nbsp;me 1.&nbsp;&lt;#assign count= rest("2.0","/search?q=" + "SELECT count(*) FROM messages WHERE board.id = 'starkb' AND subject MATCHES 'Twitter Starbase 1.0'"?url).data.count /&gt;
${count}Gives me 0.&nbsp;But, the "0" result query in API Browser gives me:&nbsp;

gagandeeps · Answer

Hi ,&nbsp;Can you please try this query :-&nbsp;SELECT id FROM messages WHERE board.id = 'starkb' AND subject MATCHES 'Twitter Starbase 1&amp;#1830'&nbsp;&nbsp;Thanks&nbsp;

vikasb · Answer

Hi&nbsp;PerBonomi&nbsp; It works fine even with the string having a period(see screenshot).It seems to get no message when you put the search string "Twitter Starbase 1.0" and it shows the following has&nbsp;evaluated&nbsp;to null when you try to get ${result.id} .&nbsp; So can you please try with the count API to make sure it is fetching something.&lt;#assign count= rest("2.0","/search?q=" + "SELECT count(*) FROM messages WHERE board.id = 'starkb' AND subject MATCHES 'Twitter Starbase 1.0'"?url).data.count /&gt;
${count}&nbsp;&nbsp;

tariqhussain · Answer

PerBonomi&nbsp;- I have created a topic with the same subject and was able to fetch it using API browser and with free marker call well. &nbsp;Could you please try following.&nbsp;&nbsp;1. &nbsp;Create a topic with the same subject in any other public board and try again the freemarker call.&nbsp;2. &nbsp;Use API v1 just to verify, if this is working in API V1.&nbsp;

vikasb · Answer

GagandeepsIt never will give the expected output because the search string "Twitter Starbase 1&amp;#183;0"&nbsp; will&nbsp;never be converted in&nbsp;"Twitter Starbase 1.0". Whole text would be treated as a string including decimal character Unicode.&nbsp;&nbsp;PerBonomi&nbsp; Bit late but it might be helpful for others also.&nbsp; It seems an error&nbsp;with lithium match case API.&nbsp; You should reach out to support. But in this case, you could query without the last two characters,&nbsp;it would not get&nbsp;you the wrong messages even where the period shows up as it would fetch those messages also.&nbsp;I performed some test here. It works fine our instance with the text string&nbsp;"Twitter Starbase 1.0" but not with "Twitter Database 1.0", "Twitter History 1.0" etc. (see screenshot)&nbsp;1. Search Text(Twitter Database) without numberResult:&nbsp; It returns&nbsp;the posts having text Twitter or Database&nbsp;or Twitter&nbsp;Database&nbsp;in the subject.2.&nbsp;&nbsp;Search Text(Twitter Database 1.0) with numberResult: It matches the whole text before the number.&nbsp; i.e. It returns the posts having Twitter Database&nbsp;or Twitter Database 1.0&nbsp;in the subject but never Twitter or Database&nbsp;individually.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;