Sub Search in VI 10.8

[agesser]

hi ,
We have an account_number field with Index for search = YES

let's say field contains value 10000000123456
Client wants to search according 123456

The only way we found in : 1*123456
but they don't want to do this "1*" and asking how they can search 123456
and find: 10000000123456

Thanks!

[susantrueman]

Hello,

The example query shared in the original post would return the expected results. Another way to perform this search would be to use a ‘leading wildcard’ search (i.e. *123456) however this search option is off by default because it has the potential to affect system performance. ElasticSearch guidelines also recommend not allowing this option because wildcard queries (especially leading wildcard searches) can use a lot of memory due to the number of terms they need to query.  

This setting can be enabled for Visual Investigator via SAS Environment Manager (textQueryLeadingWildcardAllowed) but should be used with caution as mentioned above – see the VI product documentation for details.

For further information and guidance please contact SAS Technical Support.

Thanks,

Susan

[agesser]

Thanks a lot @susantrueman !