You’re offline. This is a read only version of the page.
811
On each listpage in ax 2012 there is the "quick filter" field on the right top of the listpage, just above the grid section.
The problem here is, when a user enters a search word, ax applies wildcards in backgroud - you have no control over it.
Eg, you search for a user by name and you enter "Bob Hope". Ax will search using "*Bob Hope*" and in sql it becomes "And name like '%Bob Hope%'.
Anyone who knows a little bit about sql knows that putting a wildcard in front of a search is a killer for performance. It even has as a result that even if you would have an index on that field, the index is not used because of the wildcard in front.
In our case, one of our clients has more than 2.000.000 customers in its system and when searching for a customer using the quick filter, it takes forever to find results. But when using the same search term using the right click "filter by field" the results are found instant.
It is pretty hard to explain to our client why he should not be using this quickfilter, "why is there when we can't use it"?
So my question is: can anyone tell me why this is was designed like this AND, even better, if we can tweak this behaviour. (I took a trace, but can't find a tweak-point, it seems like a part of this behaviour is handled in kernel code).
Thanks for your reply!
Kr,
Sven
*This post is locked for comments
Hi Sven,
I only can confirm the behaviour and that we haven't found a way to convince our customers (or ourselves) that it's a good thing ;-)
Only replying so that you have more backup from the community if you make a request to MS.
Kind regards,
Annette
Hi Sven,
This is a great question. It is by design. This is indeed done within the kernel. We can't control it. I would suggest to create a support issue for Microsoft.
Teaching the workaround is recommended here. At some customers it was hard to explain why this field automatically adds the wild cards and the filter by field or advanced query form not. They stated they would like to have consistency.
I've noticed something similar in an environment which has 2 million items. I can't answer your specific questions, but I would suggest to enable Filter by Grid (Ctrl + G). It then becomes as easy to filter for Customer in the data grid as it is by using the quick filter bar.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,113
Super User 2024 Season 2
#2
Martin Dráb
229,918
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (