Small and medium business | Business Central, N...

Text Data Type Filter issue in Business Central

(0) Share

Report

Posted on by Tech-Lucky

796

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?

E..K

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.

All responses (3)

Answers (0)

Tech-Lucky 796 on at

Like (0)

Report

RE: Text Data Type Filter issue in Business Central

Nitin Verma

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
Suggested answer

Nitin Verma 21,091 Super User 2024 Season 1 on at

Like (0)

Report

RE: Text Data Type Filter issue in Business Central

why dont you consider your filter like this on that field?

E*

B*

K*
Suggested answer

NAV_with_Narang 2,236 Super User 2024 Season 1 on at

Like (0)

Report

RE: Text Data Type Filter issue in Business Central

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/.../