Home > Ax Technical > Access the query of a formDatasource in Dynamics Ax

Access the query of a formDatasource in Dynamics Ax

June 4, 2010 Leave a comment Go to comments

We all know well that to access the datasource in a form we use table name suffixed by DS. But there is one another similar suffix that can help us access the datasource query. See example below to understand.

Eg:

//note the suffix "_q"used to access the query.
InventTable_q.datasourcetable(tablenum(InventTable)).addRange(fieldnum...

This is not widely used but can be of help at times.

  1. casperkamal
    June 9, 2010 at 7:09 am
    Reply

    just to add you can also use “_qr” to use the queryrun instance of the formdatasource

  2. Patrick
    June 7, 2010 at 3:45 pm
    Reply

    This was new too me. Thanks for recover.

  3. casperkamal
    June 5, 2010 at 4:11 am
    Reply

    Thanks for the comment Daniel. Yeah that can be true. But my feeling says it is matter of getting used too.

  4. Daniel
    June 4, 2010 at 9:44 pm
    Reply

    Hi!

    It’s true, can be helpful, but could create some confusion in some developers who start wondering where is Inventable_q variable declaration.

    I think it isn’t a good practice, what do you think about it?

    Have a nice weekend!

  1. No trackbacks yet.

Leave a reply to Patrick Cancel reply