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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Workaround for subquer...
Finance | Project Operations, Human Resources, ...
Answered

Workaround for subqueries for a Form ListPage AX2012

(0) ShareShare
ReportReport
Posted on by CBNestor 46

Hi all,

I need a hand with this please,

I am trying to show 10 productions' Route Operations per each started production in a form listpage. So my plan is to convert this Form List Page that I have created in AOT. (which is showing all prodRoute vertically)

pastedimage1623062187453v1.pngpastedimage1623064040376v3.png

into this: one row per started production, with 10 first operations in columns (Horizontally)

pastedimage1623062339382v2.png

In my head thinking in SQL I would make this using a sub query per each Group of fields but I cannot translate that into AX in AOT.

The cool part of using the ax listpage is that I can use the prebuilt Display Method from each table.

What would be a efficient way to build this??

I have the same question (0)
  • Verified answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 304,551 Super User 2026 Season 1 on at

    Hi Nestor,

    If you are thinking in SQL, then you can create a view with a data source for the ProjTable and computed columns for the routes. See also the documentation and a blog from Martin:

    Walkthrough: Add a Computed Column to a View | Microsoft Docs

    AX2012: Subqueries in views – Goshoom.NET Dev Blog

  • CBNestor Profile Picture
    CBNestor 46 on at

    Hi André,

    thanks for fast reply, I was actually taking a look on Marcin's answers yesterday on other forums. Never tried the computed column so I am afraid I had to begin with it I had the hope to find more straightforward solution. I will give it I try then, for sure It will bring more questions x)

  • CBNestor Profile Picture
    CBNestor 46 on at

    Hi André,

    It is almost done know. It really helped the explanation of subqueries from Martin It was exactly what I needed!

    pastedimage1623247575915v2.png

    Just a liitle bit tedious to built all by hand I have to find a way to generate the objects by x++ 

  • ergun sahin Profile Picture
    ergun sahin 8,826 Moderator on at

    I understood what you were trying to do when I saw the result. (In fact, if you look carefully, you can understand it in the first picture. I probably didn't have the time when I first saw it)

    How is the speed of the final version of the form?(It seemed a little slow but not sure)

    I think there are easier ways but I'd be lying if I said I don't curious about the structure or your codes.

  • Suggested answer
    CBNestor Profile Picture
    CBNestor 46 on at

    Hi Ergün,

    The Speed is the same as a regular ListPage form (prodTableListPage for example). So Is good

    Every Column (except for the ProdTable) are ComputedColumn once I did it for the first group I just need to duplicated the methods and the Fields and changing the name and I got it.

    here the structure if you are interested. 

    If you know a better solution please let me know

    pastedimage1623249708105v1.png

  • ergun sahin Profile Picture
    ergun sahin 8,826 Moderator on at

    A finished form is always best. (There are easier ways, but it is difficult to say that they are better.)

    I would avoid using ComputedColumn if possible but it's a bit of a reflexive move. It has no fundamental basis. (I feel like it's going to slow down.)

    I have never used it this way, but if there is no slowness due to data, I think it is ok

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 304,551 Super User 2026 Season 1 on at

    The advantage of using T-SQL in computed columns is that the execution is done on the SQL server.

  • CBNestor Profile Picture
    CBNestor 46 on at

    Hi Ergün,

    even though I am still interested in a different solution. To be honest I don't know other

    by the way you know how to hide the pane that is behind the FactBoxes ( is not exactly the Parts Pane)

    pastedimage1623323810798v1.png

    edit: got it. Grid properties -> width: Column width

  • ergun sahin Profile Picture
    ergun sahin 8,826 Moderator on at

    I don't know about the demand, but I would probably do it with tempTable. It seems that something can be done with queries and views as well. Finally, Display fields, dynamic fields etc.

    If they don't accept those, I would say let's make a different tab :)

    If they did not accept this suggestion too, I think I would direct them to the reports.

    I think the corruption is caused by the Column width

  • ergun sahin Profile Picture
    ergun sahin 8,826 Moderator on at

    But as I said before, I never build nearly the entire form(view) with computedColumns, although I used it occasionally. I will use more if there is no performance issue. (They are pretty easy and useful)

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

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

#1
Giorgio Bonacorsi Profile Picture

Giorgio Bonacorsi 689

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 606 Super User 2026 Season 1

#3
CP04-islander Profile Picture

CP04-islander 356

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP
License usage reporting (in-app and PPAC) with Entra dynamic groups

Product updates

Dynamics 365 release plans