Feature: Find Similar To
Developer: Carlos Ruiz
By default the matching queries in Find window ( ~ ) are resolved using the LIKE function.
There is a more powerful version of LIKE in PostgreSQL with the name SIMILAR TO.
Users can now set up this matching way using the user preference "Use Similar To":
After the user enable that, then syntax similar to regular expression can be used, for example:
Result in these records:
Technical Info: IDEMPIERE-1906
- Please note that the conversion of SQL statements are cached in memory, if a LIKE query was executed previously will be converted to LIKE again until the user executes the "Cache Reset" process.
- PostgreSQL documentation about SIMILAR TO can be found on this link