12-17-2012 04:12 PM
I'm trying to search using a wildcard in a AOP data store.
This produces a result:
Back EMF Date: 2012-08-20 Time: 14:16:04
But this does not
Back*
How can I use wildcards in a data store search?
Solved! Go to Solution.
12-18-2012 03:22 AM - edited 12-18-2012 03:39 AM
I would assume all of the following should create correct results
dim query : set query = store.CreateQuery query.ReturnType = "Measurement" query.Conditions.Add "Measurement", "name", "=", "Back*" store.Search(query)
store.GetElementList("Measurement", "name=Back%", true)
store.GetElementList("Measurement", "name=Back*", false)
store.GetElementList("Measurement", "name=Back*")
Please take into account that AOP does not support case insensitive query.
I assume that you are using a AVL Puma. You might need to set a switch in the Advanced DIalog of the AOP connection. "Use Like instead of MATCH".
In the connection parameter this shows up as
<santorinlike>YES</santorinlike>
12-19-2012 05:30 PM - edited 12-19-2012 05:38 PM
I swear I tried %... Anyway, it works in a script, but not in the navigator. I even set use LIKE instead of MATCH. Ideas?
EDIT: Sometimes I am quite hasty.... Anyway, searches ARE case sensitive, but I'm sure you knew that. Now I do too. 🙂
12-20-2012 09:00 AM
Its case sensitive for AOP (ASAM ODS via RPC). Other stores offer both case sensitive and case insensitive (e.g. AOP5 = ASAM ODS via Corba).
If you work with AOP store % will always work (There is no escape character) but to make it generic only ElementList expects % id odsconform is set to true.