Wildcard Searches in LiveReports

Hi OT Experts,

I'm developing a webreport that has a search function and one of the requirement is that the search function has a multi-field search. I'm able to achieve that requirement. However, it seems that the wildcard search in LiveReports is limited to the texts in the beginning of the field.

Example: If want to search anything that has "CIRCUIT" in any of the fields it will not return any results because circuit is in either the middle of last part of the text but if I search "SINGLE" it will return results

Below is the partial query that I'm using and the setup in the live report.

I noticed in the parameters it only shows %1, maybe that is the limitation?

Also, please let me know how you do the full text field search in livereports.

Find more posts tagged with

Comments

the wildcard at the start of the WHERE line should cover what you need. You may also be better using the Search Engine instead of a LiveReport.

@Greg Griffiths Thanks. However, what do you mean by the start of WHERE?

use DataTable.js

@Mark Lumantao you are mixing up the % character, the wildcard in SQL, and the %n which is the replacement for a LiveReport parameter i.e.

SELECT * FROM dtree WHERE name LIKE '%1%'

with a first parameter of Greg, the SQL would be :

SELECT * FROM dtree WHERE name LIKE 'Greg%'

you probably need an extra % sign, check the CONNECT logs to see the actual SQL.

you may also want to consider using the Search Engine instead.