Skip to main content

Posts

Getting field values of more than one data source when calling a menu item

When a form has called another form (the user has opened a form by clicking a button in another form), you sometimes need to get information from the calling form. The traditional way is to use element.args().record(); but this construction only allows for transferring ONE datasource at a time. Sometimes it would be nice to be able to transfer more than one datasource. This is an example of how that can be done. The code must be implemented in the init -method of the CALLED form: SysSetupFormRun s; APMObjectTable apmObjectTable; int dataSourceNo; // Determine value of fields APMProductId and APMModelId of APMObjectTable record // which might have been active at the time of pressing CTRL+F4 in the previous form // (CTRL+F4 on model field in form APMCustOverview) s = element.args().caller(); if (s) {     for (datasourceNo = 1; dataSourceNo <= s.dataSourceCount(); dataSourceNo++)     {         if (s.dataSource(dataSourceNo).cursor().TableId == tableNum(APMObjectTable))         {       

Tokenizing a string

How to tokenize a string. In Java you can use an object of the stringTokenizer class to break up a string in to tokens. Dynamics AX has a handy class called TextBuffer with which you can achieve a similar effect. This example shows how (the code is written as a job): static void Job7(Args _args) {     TextBuffer t;     t = new TextBuffer();     t.ignoreCase(true);     t.regularExpressions(false);     // Set the text to break in to tokens     t.setText("When I find myself in times of trouble, mother Mary comes to me, speaking words of wisdom, let it be. And in my hour of darkness she is standing right in front of me, speaking words of wisdom, let it be.");     // The delimiter to search for when finding tokens is space     while (t.nextToken(false," "))     {         info(t.token());     } }

Dynamics AX - Getting the value of a given field regardless of tablebuffer

How to get the value of a given field regardless of which tablebuffer is active. Foreign keys in Dynamics AX are scattered throughout the tables of the system, connecting the modules to each other. For example ItemId fields store the item identification in a lot of tables, for storing information related to the item in question. This example shows how you can write a generic method that gets the value of the field ItemId regardless of which table is active at runtime. The example was originally implemented as a method on a form. The method was able to return the value of the field ItemId regardless of which tablebuffer was active, when the form was called ( element.args().record() ). public ItemId getFormItemId() {     common table; // Generic table buffer     DictTable dt; // Dictionary object for handling table information     // Get the table in question     table = element.args().record();     // Make DictTable object     dt = new DictTable(table.TableId);     return table.(dt.fiel

Debugging and inspecting values of the fields in a form datasource

For debugging purposes code that can inspect the values of the fields in a datasource in a form or a report can be quite handy. This is how it can be done in e.g. the active method of the datasource : QueryBuildDataSource qbds; QueryBuildRange qbr; int dsc,dsi,rc,ri; // Get the number of datasource on the query dsc = queryRun.query().dataSourceCount(); // Loop over datasources for (dsi=1;dsi<=dsc;dsi++) {     qbds = queryRun.query().dataSourceNo(dsi);     info("Table: "+tableid2name(qbds.table()));     rc = qbds.rangeCount();     // Loop over fields     for (ri=1;ri<=rc;ri++)     {         qbr = qbds.range(ri);         info(fieldid2name(qbds.table(),qbr.field())+" value: "+qbr.value());     } }

Overriding SysLastValue Dynamics AX 3.0

This is an old blog entry from my old blog. Today I solved a problem, that has long puzzled me. From Axapta 3.0 (or was it 2.5 can't quite remember) it became best pratice to wrap reports in runbase-report classes. For a long time it has irritated me, that if you called your report class from something else than the menu, you were having trouble overriding syslastvalue, without clearing all saved last value completely. Example: You have a report called from a runbasereport class.For the class you naturally have a output menuitem, that is attached to the menu. So when you call this report, and make selections in the ranges of the query of the report, they are shown in the report dialog, and saved, so that the next time you call your report, the last used selections is being restored for you in the dialog for reuse. However sometime you experience, that the report can be called from BOTH the menu and somewhere else like a form. When you call the report from a form, it is customary to

Subtle but important difference between _ds.executeQuery() and ds.Research()

This is actually an old entry. Been tumbling with a problem for the last few days. A form in our Dynamics AX module for Preventive Maintenance Control was not behaving. The form has "explicit" filter fields that the user can see without having to activate the form filter (CTRL+F3), for setting up filters most commonly used in an easy way. And this is working ok. However at this customer site, the form has been adjusted so that the user can have the form refreshed automatically periodically, and when the users at the customer site were making use of the "explicit" filter combined with the AX's normal filtering (CTRL+F3), the form simply threw away the normal form filtering. I discovered a subtle but very important difference between writing _ds.executeQuery(); (which was the way our code was doing it) and _ds.Research(); The difference is that _ds.Research() will retain the filter ranges in the forms query as they are right now. _ds.executeQuery() will NOT. It

Dynamics AX 4.0 - showing AOS instance

I Dynamics AX version 4.0 the information about on what AOS you are currently running your code, has been removed. In version 3.0 (3-tier) the client showed the AOS instance info. With a development, a test and a production environment at a site, the missing info can be of great annoyance when you are working with clients started in multiple environments. Today I found that other developers and consultants have the same problem, and one developer even solved the problem, with the very usefull hack: http://coolhake.wordpress.com/2008/07/22/configuration-in-title-bar/ Oh yay, saved my day.