Assembly containing type %1 is not referenced.

When AIF / web services / dll references cannot be called (with error: Assembly containing type %1 is not referenced.) Then you need to give AOS user an access to "Program Files\Microsoft Dynamics AX\60\[YOUR AOS NAME]\bin\VSAssemblies" folder.

After that, restart the AOS. If the error still persist then do the full compile.

How to create multiple values in query range

You can create multiple values in query range from x++, where the code is:

QueryBuildDataSource qbds = q.dataSourceTable(TableId);
QueryBuildRange qbr;
while (...)
{
    qbr = qbds.addRange(fieldNum(TableId, FieldId));    qbr.value(queryValue(TableId.fieldId));
}

QueryBuildRange qbr = q.dataSourceTable(TableId).addRange(fieldNum(TableId, FieldId));
container c;
while (...)
{
    c+= queryValue(TableId.FieldId);
}
qbr.value(con2str(c));

How to override form datasource with another query

You can override form datasource with another (filtered) query.

You can put the code in datasource.executeQuery()

public void executeQuery()
{
    FormDataSource fds;
    ;
    //info(strFmt('1--%1', this.query().toString()));
    queryClass.executeQuery();
 
    fds = this.formRun().dataSource();
    fds.query(queryClass.parmQuery());
 
    //info(strFmt('1.1--%1', fds.query().toString()));
    //info(strFmt('2--%1', queryClass.parmQuery().toString()));
    super();
}

Where the "queryClass" is a class that create a filtered query.

How to comparing 2 field in AOT Query

The rules for creating query range value expressions are:

• Enclose the whole expression in parentheses.
  
• Enclose all subexpressions in parentheses.
  
• Use the relational and logical operators available in X++.
  
• Only use field names from the range's data source.
  
• Use the dataSource.field notation for fields from other data sources in the query.
  
  

How to open FilePath EDT on form

If the filepath dialog is not opening on Form, U have to add below method on form (AOT > MyForm > Method > filePathLookupTitle)

public str filePathLookupTitle()
{
    return 'Import folder';
}

How to create AOT object lookup

static void lookupAOTTables(FormStringControl _ctrl)
{
   SysTableLookup sysTableLookup =   SysTableLookup::newParameters(tablenum(UtilidElements), _ctrl);
   Query query = new Query();
   QueryBuildDataSource queryBuildDataSource;
   QueryBuildRange qbrType;
   ;
   sysTableLookup.addLookupfield(fieldnum(UtilidElements, Id));
   sysTableLookup.addLookupfield(fieldnum(UtilidElements, Name));

   queryBuildDataSource = query.addDataSource(tablenum(UtilidElements));

   qbrType= queryBuildDataSource.addRange(fieldnum(UtilidElements, RecordType));
   qbrType.value(SysQuery::value(UtilElementType::Table));

   sysTableLookup.parmQuery(query);
   sysTableLookup.performFormLookup();
}

Cara Membuat Lookup Dimension di report contract

Didalam artikel ini kita akan membahas bagaimana cara membuat lookup untuk memilih Dimension attribute pada report parameter.

Pertama-tama kita harus membuat UIBuilder class  yang akan dipakai oleh SSRS Report kita. Lalu di dalam class tersebut kita buat sebuah method lookup dimension.