Several fields in Coins ERP+ allow you to specify a list of values. Often in these fields you can use wildcards to represent "any character" or "any string of characters". Lists like these are known as "can-do lists".
For example, you can enter can-do lists in both the regular filter and the Matches field of the advanced filter.
You can enter the following in can-do lists:
To specify several values, enter the items as a list, separated by commas. For example: A1000,A1500,B1224.
. (full stop) character represents 'any single character'; for example, C1.0 tells Coins ERP+ to match any item beginning with C1 and ending with 0, with any single character being in the third position.
* (asterisk) character represents 'any string of characters'; for example, C* tells Coins ERP+ to match any item beginning with C, that has any number of characters after it. Another example: *0 tells Coins ERP+ to match any item ending with 0, but with any number of characters before it.
! (exclamation mark) character represents items you want to exclude from a list; for example, !C...,* tells Coins ERP+ to exclude any item beginning with C that has any three characters after it, but include everything else. Another example: !1*,!9999,.... tells Coins ERP+ to match all four-character codes except the code 9999 and those beginning with 1.
Note: To "match all", a can-do list field must have a * in it; if the can-do list field is blank, no items are matched. Also, after an item with a ! wildcard, you need to have an item that contains a * (or .) wildcard, otherwise you are excluding something, but not including anything.
To match a blank field, enter a single comma. (This is interpreted as a list containing two blank entries.)
With can-do lists, if you want to search for a full stop , put a double tilde (~~) before it. So a can-do list of ..~~.*~~.1234 would match items beginning with any two characters followed by a full stop, and ending with a full stop followed by "1234". This can be used, for example, when matching GL accounts by pattern.
If you want to match multiple words in any order, you need to repeat the options in each possible order. For example, *20 foot*pole*,*pole*20 foot* would find both "Scaffold pole, 20 foot" and "20 foot Galvanised scaffold pole".