How to search using wild cards on a sqlite type of database


  Applies To 
  Product(s): WaterGEMS, WaterCAD, HAMMER,SewerGEMS, CivilStorm, StormCAD, PondPack, SewerCAD
  Version(s): 08.11.04.xx +, 10.XX.XX.XX
  Area:  Modeling
  Original Author: Akshaya Niraula, Bentley Technical Support Group







Steps below will help or find or search element(s) using wild card.

Wild Cards, Wildcard Characters

There are two types of wildcard characters that are used commonly in search. The wildcards, however, are different for searching .mdb and .sqlite databases.

 In older version 08.11.03.xx we had Microsoft Access as our database which uses, asterisk sign (*) and question mark (?) as wildcard characters. From version 08.11.04.xx, we switched to SQLite type of database which uses percent sign (%) and underscore (_).

% (Percent sign) :  This wildcard character can be used to match zeros or more characters. For example '%P%' will result in, 1P1, 11P1, azppPPPP. Basically any wold that contains P. Second Example: 'P%' will show words that starts with P like PMP-1, Pipe-1. This character used to be asterisk (*) on MDB database files.

_ (Underscore) :  This wildcard character can be used to match a single character. For example 'PMP-_' will return PMP-1, PMP-0, PMP-9 (but will not return PMP-10, to get PMP-10, it needs to be 'PMP-__', two underscores). This character used to be (?) when the database was of MDB format.

How to Search

Press Ctrl+F or Edit > Find Element (this will open up a Property Grid window and will have focus on search box) and then type in the text that you want to search for.