JaySalt on AX Development

Admin Group Restriction

2012-03-21T17:48:00.002-07:00

here is an easier way to determine if the current user is an Admin user

public void init()

{

     #Admin
     boolean isAdmin;
     ;

     super();

     isAdmin = UserInfoHelp::userInUserGroup(curUserId(),#AdminUserGroup);

}

A field called Select

2012-03-21T16:07:00.001-07:00

When creating a table in Dynamics AX, DO NOT use "Select" as a field name. AX will allow you to create a field named "SELECT". it may even allow you to browse it, but sooner or later you will get a SQL error

Check if record has been changed

2011-08-11T22:11:00.001-07:00

there are times when you want to check if a table has been touched
before you do a process such as a refresh. here is code that can be
placed in a table to check whether any data in the record set has been
changed

boolean hasChanged()
{
SysDictTable sysDictTable;
int f;
fieldId fieldId;
;

sysDictTable = new SysDictTable(this.TableId);

for (f = 1; f <= sysDictTable.fieldCnt(); f++)
{
fieldId = sysDictTable.fieldCnt2Id(f);

if (this.orig().(fieldId) != this.(fieldId))
return true;
}
return false;
}

Basics of setting up AX2009 security keys

2011-07-25T01:33:00.001-07:00

Set up alerts
a. Go to Basic > Number Sequence > Reference > System ID
i. Ensure that the Basic_01 number sequence exists. If not, create.
b. Set up Basic > Setup > Email Templates
c. Basic > Setup > Alerts > Set up email ID
d. Administration > Batch Groups
i. Create "Alerts" Batch Group
e. Administration > Setup > Server Configuration
i. Tick Is Batch Server
ii. On Batch server groups tab, select "Alerts"
f. Basic > Setup > Alerts > Manage alert rules
g. Basic > Setup > Alerts > Periodic > Alerts > Change based alerts
i. Add to "Alerts" batch group and send to batch
h. Basic > Setup > Alerts > Periodic > Alerts > Due date alerts
i. Add to "Alerts" batch group and send to batch
i. Administration > Common forms > Users > User options
i. Set up email
ii. On Notifications tab, set up parameters
iii. On Status Bar tab ensure the "Show alert status" is ticked
j. Set up security keys
i. http://technet.microsoft.com/en-us/library/aa834418(AX.50).aspx

Manually upgrade Date and Time fields

2011-07-10T23:15:00.001-07:00

after an AX2009 upgrade, if you happen to forget to upgrade a Date and
Time field combination on a table to the new DateTime field, use this
simple job.

in the case below, SysDatabaseLog's CreatedTime did not seem to be
upgraded to be incorporated into the new CreatedDateTime field.

=======

static void AX2009Upgrade_ManuallyUpgradeDateTime(Args _args)
{
DEL_SysUpgradeTimeZone listOfColumnsToBeUpgraded;
ReleaseUpdateDB_TimezoneUpgrade timezoneUpgradeClass;
;

ReleaseUpdateDB41_Basic::upgradeToDateTime
(
tablenum(SysDatabaseLog),

fieldnum(SysDatabaseLog, CreatedDateTime),

fieldnum(SysDatabaseLog, DEL_CreatedTime)
);

while
select
listOfColumnsToBeUpgraded
order by
listOfColumnsToBeUpgraded.RefTableId
where
listOfColumnsToBeUpgraded.Status == SysUpgradeTimeZoneStatusEnum::Ready
{
timezoneUpgradeClass =
ReleaseUpdateDB_TimezoneUpgrade::construct(
listOfColumnsToBeUpgraded.data() );
timezoneUpgradeClass.run();
}
pause;
}

How to recover database from MDF in SQL Server without an LDF

2011-06-06T18:15:00.001-07:00

because there are times when you need to do something dodgy to save the day.

1. Detach database and move your mdf to save location.
2. Create new database of same name, same files, same file location
and same file size.
3. Stop SQL server.
4. Swap mdf file of just created DB to your save one.
5. Start SQL. DB will go suspect.
6. ALTER DATABASE yourdb SET EMERGENCY
7. ALTER DATABASE yourdb SET SINGLE_USER
8. DBCC CHECKDB (yourdb, REPAIR_ALLOW_DATA_LOSS)
9. ALTER DATABASE yourdb SET MULTI_USER
10. ALTER DATABASE yourdb SET ONLINE

source: http://stackoverflow.com/questions/773059/how-to-recover-database-from-mdf-in-sql-server-2005

good tutorial on refresh, reread, research, executeQuery

2011-03-21T15:54:00.000-07:00

thanks to VANYA KASHPERUK

http://kashperuk.blogspot.com/2010/03/tutorial-reread-refresh-research.html

Creating XML in the new AX

2011-03-17T18:43:00.000-07:00

good info

http://dynamics-ax-live.blogspot.com/2009/08/create-xml-file-in-ax.html

Wrong argument types for comparison

2011-02-13T23:02:00.001-08:00

this is not the first time this piece of code has helped me to get rid
of a weird error:

ERROR:
Error executing code: Wrong argument types for comparison.

Stack trace:
(C) \Classes\QueryRun\next
(C) \Classes\FormDataSource\executeQuery
(C) \Forms\MyForm\Data Sources\MyFormDatasource\Methods\executeQuery - line 4
(C) \Classes\FormDataSource\linkActive
(C) \Forms\MyForm\Data Sources\MyFormDatasource\Methods\linkActive - line 3

SOLUTION:
on the form init,

public void init()
{
super();
this.query().dataSourceNo(1).clearDynalinks();
}

Counting how long a job takes

2011-02-09T17:24:00.001-08:00

use this code to keep track of how long a piece of code takes to execute

timeofday starttime = timenow();
;
//your cool code here

info(strfmt("Total time taken: %1", time2StrHMS(timenow() - starttime)));

Enable/Disable table field on form by code

2010-12-06T22:02:00.001-08:00

FormDataSource_ds.object(fieldNum(TableName,Field)).allowEdit(false);

or for arrays

FormDataSource_ds.object((new
SysdictField(tableNum(TableName),fieldNum(TableName,FieldName),1).id())).allowEdit(false);

where 1 is the number of the field in the array.

Yes, you can go to the table and set AllowEdit Yes/No
Yes, you can also go to the form and set the field to Enabled Yes/No
Yes, you can also go to the particular field control and set Enabled to Yes/No

so why would you use this method?

1. If multiple controls are using this field and you want to disable
all instances of the field, but you dont want to disable it on the
table level
2. If the field is part of an array EDT, like Dimension, and you just
want to disable one field, not the others

Dynamics AX Intelligent Data Management Framework

2010-11-22T21:34:00.001-08:00

currently assessing whether the IDMF tool for Dynamics AX is worth
implementing at my current workplace.

if you don't know what it is, go here (you'll need your
partnersource/customersource login):
https://mbs.microsoft.com/partnersource/downloads/releases/ax_idmf.htm?printpage=false&stext=Data
Management Framework

here is a document i created which may help out, if you happen to be
doing the same thing.

http://cid-53c50a8f9ecf30c8.office.live.com/view.aspx/Public/Dynamics%20AX/Assessment%20of%20Data%20Management%20Framework.doc

OnlyFetchActive on Form Datasource

2010-11-18T17:24:00.000-08:00

this property on the datasource can speed things up especially if you
have one field that has lots of data stored in it and you still want
to show it on the form

if you need to show it on the form (on another tab preferably), you
can use a display method instead.

on the display method

display Memo memoDisplay(TableDS _tableDS)
{
;
if (formTableDS.RecId != _tableDS.RecId)
{
select firstonly log from formTableDS where
formTableDS.RecId == _tableDS.RecId;
}
return formTableDS.memo;
}

formTableDS is declared in the Class declaration of the form

Override Form Caption

2010-10-17T16:11:00.000-07:00

if you want to override a form caption completely, use the following
code in the datasource's active() method, just after the super.

winapi::setWindowText(element.hWnd(), "My caption override text");

Re: Filtering on Date using QueryBuildRange

2010-09-04T04:25:00.001-07:00

syntax for advanced filtering on date:

queryBuildRange = queryBuildDataSource.addRange(FieldNum(MyTable, MyDate));
queryBuildRange.value(strFmt('(MyDate == %1)', Date2strXpp(_myDate)));

email field validation

2010-08-10T18:56:00.001-07:00

public boolean validateField(fieldId _fieldIdToCheck)
{
boolean ret;
str email;
;

ret = super(_fieldIdToCheck);

if (_fieldIdToCheck == fieldnum(WRPartyApplDetails, NewEmail))
{
email = this.Email;

if ( strfind(email, "@", 1, strlen(email)) == 0
|| strfind(email, ".", 1, strlen(email)) == 0)
{
error("Must contain a '@' character and at least one '.'");
ret = false;
}

if ( strscan(email, ".@", 1,strlen(email)) > 0
|| strscan(email, "@.", 1,strlen(email)) > 0)
{
error("Cannot have the '@' and the '.' one after the other");
ret = false;
}
}

return ret;
}

Technical Best Practices for Dynamics AX - Shared and AOT Object Standards

2010-07-05T20:44:00.001-07:00

some good reading

Technical Best Practices for Dynamics AX - Shared and AOT Object Standards
- http://www.packtpub.com/article/technical-best-practices-for-dynamics-ax-shared-and-aot-object-standards

Technical Best Practices for Dynamics AX - Application Design Standards
- http://www.packtpub.com/article/technical-best-practices-for-dynamics-ax-application-design-standards

--
Kind Regards
Jonathan Sulte

====================
if (first && succeed == false)
while (!succeed)
try();
====================

Refreshing form data but staying on the current record

2010-06-09T17:13:00.001-07:00

if you want to refresh a form, but want to stay on the current record you are on, use this code:

void refreshForm()
{
    FormTable current;
    ;

    if (FormTableDataSource.RecId)
    {
        FormTableDataSource_ds.write();
        current.data(FormTableDataSource);
        FormTableDataSource_ds.research();
        FormTableDataSource_ds.setRecord(current);
    }

GROUPING query

2010-06-08T17:01:00.001-07:00

if you want to group a query on a field, here is an example (used in a lookup table):

public void lookup()
{
    SysTableLookup        sysTableLookup = SysTableLookup::newParameters(tableNum(YourTable), this);
    Query                 query = new query();
    QueryBuildDataSource queryBuildDataSource = query.addDataSource(tableNum(YourTable));
    ;

    queryBuildDataSource.orderMode(OrderMode::GROUPBY);
    queryBuildDataSource.addSortField(FieldNum(YourTable, YourField));

    sysTableLookup.addLookupfield(fieldNum(YourTable, YourField));
    sysTableLookup.parmQuery(query);

    sysTableLookup.performFormLookup();
}

Creating Lookups

2010-06-08T01:15:00.001-07:00

here is a sample code to create lookups on a form field

public void lookup()
{
    SysTableLookup        sysTableLookup = SysTableLookup::newParameters(tableNum(YourAXTable, this);
    Query                 query = new query();
    QueryBuildDataSource queryBuildDataSource = query.addDataSource(tableNum(YourAXTable));
    QueryBuildRange       range1 = queryBuildDataSource.addRange(fieldNum(YourAXTable, FieldYouWantFiltered1));
    QueryBuildRange       range2 = queryBuildDataSource.addRange(fieldNum(YourAXTable, FieldYouWantFiltered2));
    ;

    range1.value(queryValue(YourFormField.valuestr()));
    range2.value(queryValue(YourFormField2.valuestr()));

    sysTableLookup.addLookupfield(fieldNum(YourAXTable, FieldYouWantReturned));
    sysTableLookup.addLookupfield(fieldNum(YourAXTable, AdditionalLookupColumn));

    sysTableLookup.parmQuery(query);

    sysTableLookup.performFormLookup();

}

QueryBuildRange date range between two dates

2010-06-06T19:04:00.001-07:00

when you want to filter between two dates. use SysQuery::Range:

eg
queryBuildRange = queryBuildDataSource.addRange(FieldNum(WRWaterShareTable, TenureExpiryDate));
queryBuildRange.value(sysQuery::range(_expiryDateFilter,_expiryDateToFilter));

this function gives the flexibility of passing one or two dates. if you pass value in the first date only, it will search date equal to and after the date. if you pass value in the second date only, it will search dates equal to and before the date.

SysOperationProgress sample

2010-06-01T22:35:00.001-07:00

this is the basic code of when you want to show progress. it will show the progress animation while the system is waiting to go through your code.

public void sysOperationProgressSample()
{
    SysOperationProgress        progress = new SysOperationProgress();
    counter                     counter = 0;
    counter                     progressCounter = 0;
    LineNum                     lineNum = 0;
    int                         lineTotal;

    ;

#AviFiles

    progress.setCaption("Processing Records...");
    progress.setAnimation(#AviUpdate);

    lineTotal = 9999; //set total of lines here
    progress.setTotal(lineTotal);

    while select ...
    {
        //put these lines on top (or at the bottom of what you are doing)
        counter++;
        progressCounter++;
        progress.setText(strFmt("Processing %1 of %2 records. Please wait",int2str(counter),int2str(lineTotal)));
        progress.incCount();

        /*
        your stuff here
        */
    }

}

Disallow system to remember Last Query Used values on filters

2010-05-31T23:34:00.001-07:00

on the init of the report

public void init()
{
    SysQueryRun sysQueryRun;
    ;

    super();

    this.queryPerfTable(); //do your query stuff here

    //these code lines stop the system from remembering last used values
    sysQueryRun = new SysQueryRun(element.query());
    sysQueryRun.promptLoadLastUsedQuery(false);
    element.queryRun(sysqueryRun);

}

PostSynchronize Scare when Upgrading AX2009

2010-04-01T18:05:00.001-07:00

Just want to share my experience with this Dynamics AX upgrade step. I got to the part of the upgrade where it is time to do the Postsynchronize step. This is the all important part. I had to do a Presynchronize first, then a Synchronize database step. After this step, the Postsynchronize step (which was greyed out) *should* turn to green after synchronizing successfully.

However in my case, it did not. I spent a good hour trying to figure out why it didn’t. I resynchronized, i checked that everything was ok. It was. I reran Presynchronize then Synchronize. Nothing worked. The Postsynchronize options still stayed greyed out. It was not enabled and i could not proceed.

A few minutes before giving up and restoring the backup (which would mean i would have lost a few hours’ worth of upgrade time), i tried clicking back to the second step which was Provide licence Information, re ran that, reran the next step, Global Address books, re ran Setup Current Time Zone, re ran Customer Feedback Options. Skipped detect code upgrade conflicts, re ran Presynchronize (it won’t actually rerun the jobs, it will just tell you have already ran it, and it when you close out of it, it will enable the next step), re ran Synchronize... and voila!!! It worked, it opened up the Postsynchronize step!

What *i think* happened is when you run the upgrade, it puts some settings in a temporary table. Throughout the upgrade, which can span days, you are going in and out of AX. If this table is cleared for some reason, it loses track of what steps you have finished, and what the next step is.

Going back to the second step (the first step is Compile Application, and i didn’t want to do that as it takes around 30 minutes) seem to restore that temporary table and going through the steps one after the other, without shutting down, it will allow you to get to Postsynchronize.

I hope this helps some poor soul out there desperate to know why they cannot Postsynchronize

Restriction for Admin Groups

2010-03-11T19:43:00.000-08:00

When you want to restrict something to the Admin Group only, use this code:

#Admin

boolean canForwardDate()

{

boolean ret;

UserGroupList groupList;

;

select firstfast groupList where

groupList.groupId == #AdminUserGroup

&& groupList.UserId == curuserid();

if (groupList)

ret = true;

else

ret = false;

return ret;

}