Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX forum
Suggested answer

standard field filter is stuck

Posted on by 768

Hello guys,

I was told about a problem with the standard field filter. It appears when you enter "Ctrl + G" buttons on the form. I haven't checked it yet as this task hasn't been yet approved but according to the description when user presses "Ctrl + G" and enters some value to the field it works fine. If user then erases the value and enters another one the client is frozen and they kill SQL query on the SQL server. How does this standard field filter work? What method sequence works in AX or does AX go directly to SQL server with this filter?

Thanks.

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 288,420 Super User on at
    RE: standard field filter is stuck

    Hi Azat,

    Can you tell more about the SQL details? Do you have some information about the behavior from monitoring and telemetry which you can share?

  • Suggested answer
    julia146 Profile Picture
    julia146 on at
    RE: standard field filter is stuck

    1. Take ax trace and you could analyze further.

    2. Check if any slow query or blocking in the sql side.

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: standard field filter is stuck

    Hi Azat,

    Are you on an old aX2012 build?

    If you are, then have a look at the hotfixes released on LCS to ensure that you did not run into a bug.

    fix.lcs.dynamics.com/.../Results

    Best regards,

    Ludwig

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 288,420 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,672 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans