Have you ever come across an IQA query that doesn’t give the expected results when you use wildcard filters?
Here is why….

IQA filters that are wildcard search are ‘starts with’, ’ends with’, ’contains’, ’not contains’. When the data contains wildcard characters as literal characters ( example %, _, ^ ), IMIS is unable to apply the filters accurately resulting in ambiguous results.

Below are the guidelines on commonly used wildcard chars and how it can be used in the IQA filters.

 

Wildcard Character Description Example
% Data starting with the given characters First Name Starts with 'DE', gets all contacts whose first name starts with de or DE.
_ (underscore) Data starting with the given single character First Name Starts with '_ean', gets all contacts whose first name starts
with any char, but the following three chars are ean.
[ ] Data starting with any single character within the specified range
([a-f]) or set ([abcdef]).
First Name starts with [a-dpr], gets all contacts whose first name
starts with any chars from (a,b,c,d,p,r).
[^] Data not starting with any single char or range First Name starts with 'se[^a]', gets all contacts whose first name starts with se, but the third char is not a. (example SEAN will be excluded)
[%] % is a wildcard character, if data contains wildcard char as literal, this
gets the correct results (Data that contains %).
Product description starts with 'abstract[%]' , gets all products that
contains the word abstract% within the description.
[_] Data that contains _ Product code starts with 'AP[_]' , gets all products with product code starts with AP_ excluding products that starts with AP.

About Causeis: With over 50+ years combined experience, Causeis provides an award-winning iMIS consultancy service to Australia’s leading non-profits. We specialise in business strategy alignment, engagement modelling, critical system management, website development and data analytics.

Latest blogs

Security is more than just HTTPS

Posted on 29/04/2019
Following several high-profile online security breaches involving major corporations and government entities, the digital world is increasingly focused on security and PCI compliance.

Business Process Review – Process Automation Opportunities

Posted on 14/03/2019
What is iMIS process automation? Process automation is a (often underutilised!) feature of iMIS that enables you to improve member engagement and staff productivity by automating repetitive tasks and processes.

Collier Foundation Launches New iMIS Powered Grant Application System

Posted on 15/02/2019
The Collier Charitable Fund is a perpetual charitable trust that was established in 1954 by Alice, Annette and Edith Collier, three Melbourne sisters, as a way to continue, in perpetuity, their lifelong practice of generous support.