Why auto triming the text is not implemented in eWorksheets Query Conditions

Post date: Mar 1, 2017 11:03:09 AM

Current implementation of eWorksheets does not trim the text entered by users in query conditions because of some concerns.

Below are few of the concerns.

1. When we are fetching the data based on some query criteria as below

In above case, it is recommended not to auto trim the text.

If we trim the data entered by user, we might get conflicts in data being fetched, as the database might have the entries with spaces.

2. If we wish to auto trim the spaces in the text entered by user, we need to make sure that we use trim function in the query configured in all ETK models as well.

And if we wish to skip that as well, we need to clean the whole existing data to remove the leading and trailing spaces.

Please post your comments if any.