Browser auto-complete functionality can add a space after text inserted into search fields. Remove this prior to running any query, as it is almost always not the user intention.
To find matches that have a trailing space, a % or * can be added to the search string.
Environment
None
Activity
Show:
Tony De Keizer February 26, 2023 at 11:28 PM
needs to be resolved in database.
Tim Anderson February 26, 2023 at 11:23 PM
The UI shouldn’t allow the creation of entities with leading or trailing spaces. If they are saved in the db this way, they will need to be corrected. It is possible for plugins to create entities with spaces in this manner; that should be considered a bug in the plugin.
Tony De Keizer February 26, 2023 at 8:27 PM
If a product (and assume other entities) has a leading ro training whitespace and is selected in estimates/invoices on saving get: Failed to validate property Product: …….. does not exist or is not valid for this field
From https://www.openvpms.org/forum/trimming-trailing-whitespace-textfield
Browser auto-complete functionality can add a space after text inserted into search fields.
Remove this prior to running any query, as it is almost always not the user intention.
To find matches that have a trailing space, a % or * can be added to the search string.