Submitted by carloscadu on 2020/10/02 15:07
Hi,
 
As shown in this screencast (https://bit.ly/3l66rQ2), the Live-Search isn't interpreting the underscore symbol '_' as a string:
Is it possible to make the underscore symbol '_' to be interpreted as a string?
For instance, if I type in the search box TT_, I'd like IQ listing just the items that have TT_ in the item name, but for instance, the current output lists 'Otter' and many otter double TT despite of the underscore symbol.
 
Thank you,
Carlos

Comments

carloscadu

2020/10/05 11:51

Permalink

Thanks for the reply @Left
The 'word only' search didn't work because I'm searching for a prefix (e.g. TT_A, TT_B, TT_C), so it lists 'zero' results.

carloscadu

2020/10/05 12:01

Permalink

[quote=Pierre_Admin]
 
I'll improve support for ADO wildcard characters, but for now enclose _ with [   ]
i.e. [_]
 
[/quote]
 
Thanks for the reply @Pierre.
'enclose _ with [   ]' did the job.
 
As mentioned by you, an improvement would be very welcomed, in the sense of not being necessary to 'enclose _ with [   ]'.
I'm used - not in IQ - to apply _ to search very fast by creating unique strings starting with _. Just the string _ works as a prefix for me, as shown in the searches performed in this screencast: https://bit.ly/30CukqJ
In the screencast I also showed the use of 'enclose _ with [   ]' and the search for 'word only'.
Regarding search for 'word only', the documentation below informs that "you can enclose text in quotation marks" to match whole word only. However, it didn't work. Only checking it under the search options worked.

Pierre_Admin

2020/10/05 13:05

Permalink

[quote=carloscadu]
Regarding search for 'word only', the documentation below informs that "you can enclose text in quotation marks" to match whole word only. However, it didn't work. Only checking it under the search options worked.
[/quote]
I didn't see that information in the documentation... there is mention of using quotes to find the string "the calendar" but that is different from whole word search
 
Pierre_Admin
IQ Designer
 

carloscadu

2020/10/05 16:03

Permalink

[quote=Pierre_Admin]
[quote=carloscadu]
Regarding search for 'word only', the documentation below informs that "you can enclose text in quotation marks" to match whole word only. However, it didn't work. Only checking it under the search options worked.
[/quote]
I didn't see that information in the documentation... there is mention of using quotes to find the string "the calendar" but that is different from whole word search
 
Pierre_Admin
IQ Designer
 
[/quote]
 
It was my misinterpretation of "the calendar" just appearing after "So you can enclose text in quotation marks, use parenthesis and use AND and OR keywords".
Please, ignore my point regarding "match whole word" in the documentation. 
 
Best,
Carlos
 
 
 

Pierre_Admin

2020/10/05 16:50

Permalink

In v116d:
  • New: Live-Search: Support search for %, [ and _ characters
  • New: Live-Search: Verbatim mode where user can enter ANSI-92 wildcards
 
Pierre_Admin
IQ Designer
 

carloscadu

2020/10/06 11:26

Permalink

[quote=Pierre_Admin]
In v116d:
  • New: Live-Search: Support search for %, [ and _ characters
  • New: Live-Search: Verbatim mode where user can enter ANSI-92 wildcards
 
Pierre_Admin
IQ Designer
 
[/quote]
 
You are my hero!!!
 
 

Hey. I've been trying to search for strings of the type "space + any single alphabetic character + space", e.g. all occurrences of " a " as a single word inside a sentence but was unable to do so using v. 116d. I tried both " _ " and "[ ]_[ ]". Pierre, you spoke of 'verbatim mode' - does that mean ticking 'Enable Wildcard Characters' in the live search dropdown box? Is such a search possible ATM? Many thanks!

Pierre_Admin

2020/10/12 19:49

Permalink

Hi Left !
 
Yes, Verbatim was too technical. Wildcard was more accessible
 
Did you try : " [a-z] "
 
(quote space [a-z] space quote)
 
Pierre_Admin
IQ Designer
 

LeftEccoForIQ

2020/10/13 03:17

Permalink

That worked. Thank you very much!