web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested Answer

not responding when i query about this table

(0) ShareShare
ReportReport
Posted on by 2,050

Greeting everyone 

when i try to get query of this table DimensionAttributeValueCombination

static void Job24(Args _args)
{
    DimensionAttributeValueCombination   dimensionAttributeValueCombination;

    while select * from dimensionAttributeValueCombination 
    {
        info(strFmt("%1",dimensionAttributeValueCombination.DisplayValue));
    }
}

it's not responding

this table doesn't have customization 

also i did deleted and sync that table but still make ax2012 not responding for ever

also i try to add parameter even that make it  not responding for ever too

I have the same question (0)
  • Suggested answer
    Martin Dráb Profile Picture
    237,892 Most Valuable Professional on at

    This table usually has many records, therefore iterating all of them may take a while. Especially when you run code on client - consider doing it on server.

    Also, you fetch all fields from database and then ignore all of them except of DisplayValue. Selecting just DisplayValue will improve performance.

  • Suggested answer
    nmaenpaa Profile Picture
    101,160 Moderator on at

    What exactly are you trying to achieve? Clearly this is just a job to list all DisplayValues but what is your business requirement?

    I think the slowest thing in your code is that you try to print so many entries to the infolog.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 544 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 450 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 250 User Group Leader

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans