I have observed a strange behavior of BC filters in Text Data Types.
as you can see in the below image I have applied the Filter on Customer Name: E..K which means the name starting from E to K as far as I know the Dot Dot ".." are used as from value till To Value ?
in my case, the system is filtering the data from E to J only why is the system reduced by one value can anyone help me to understand that?
while data exist for K you can check in the below SS
this example is of the Demo database, why I am asking this question because I do have a customer requirement where I have created an Alpha Range Master and on the basis of that alpha range master we have to update a certain value in the customer master but that must depend on the alpha range only for example the field name is Registrar, so the master has defined like the customers whose name start from A to D would be assigned User A, E to K - User B, and so on.
I tried but I need to set the range from and to if I use like E*..K* this also works the same the to value is not the same as defined in my filter
why dont you consider your filter like this on that field?
E*
B*
K*
The double dot (..) is used for defining a range for dates. For texts it doesn't work in the similar manner
Microsoft has this link giving examples of text filters: learn.microsoft.com/.../ui-enter-criteria-filters
Another link: dynamicslifestyle.wordpress.com/.../
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,232 Super User 2024 Season 2
Martin Dráb 230,064 Most Valuable Professional
nmaenpaa 101,156