Period in query breaks query
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...
Forum Discussion
Hi PerBonomi 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 evaluated to null when you try to get ${result.id} . So can you please try with the count API to make sure it is fetching something.
<#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 />
${count}
<#assign count= rest("2.0","/search?q=" + "SELECT count(*) FROM messages WHERE board.id = 'starkb' AND subject MATCHES 'Twitter Starbase'"?url).data.count />
${count}Gives me 1.
<#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 />
${count}Gives me 0.
But, the "0" result query in API Browser gives me:
