Query addField in Business Connector

[SteEng]

Hi,

I am pretty new to business connector and I am creating a query where I can't figure out how to call addField in C#.

X++ code is:
....
query.dataSourceNo(1).fields().dynamic(false);
query.dataSourceNo(1).fields().clearFieldList();
query.dataSourceNo(1).fields().addField(fieldNum(CompanyInfo, dataAreaId));
query.dataSourceNo(1).fields().addField(fieldNum(CompanyInfo, CurrencyCode));
...

Please give me some guidance how to use

...Call("dynamics", false) ..

and so on


SteEng

[_scorp_]

Hi. Simple C# example:

IAxapta2 axapta = new Axapta2Class();
axapta.Logon2(userId, pass, companyId, "", "", "", "", null, null, null);
IAxaptaObject axQuery = axapta.CreateObject("Query", "queryName", null, null, null, null, null);
IAxaptaObject axQBDS = axQuery.Call("dataSourceNo", 1, null, null, null, null, null);
IAxaptaObject axQBDSFields = axQBDS.Call("fields", null, null, null, null, null, null);
axQBDSFields.Call("dynamic", false, null, null, null, null, null);

You make use callEx, CreateObjectEx for more "clean" sintax, without null parameters.

[SteEng]

Цитата:

Сообщение от _scorp_

Hi. Simple C# example:

IAxapta2 axapta = new Axapta2Class();
axapta.Logon2(userId, pass, companyId, "", "", "", "", null, null, null);
IAxaptaObject axQuery = axapta.CreateObject("Query", "queryName", null, null, null, null, null);
IAxaptaObject axQBDS = axQuery.Call("dataSourceNo", 1, null, null, null, null, null);
IAxaptaObject axQBDSFields = axQBDS.Call("fields", null, null, null, null, null, null);
axQBDSFields.Call("dynamic", false, null, null, null, null, null);

You make use callEx, CreateObjectEx for more "clean" sintax, without null parameters.

Thanks Scorp,

What about X++ addLink(fieldNum(Currency, dataAreaId), fieldNum(CompanyInfo, dataAreaId)) ?


SteEng

[EVGL]

FieldNum(...) is an intrinsic function inside of AX. I think you may directly use the known field ID number:

("addLink", 61488, 61488)

[SteEng]

Sorry EVGL,

That didn't work. Exception: Invalid Field/ Related field combination.

STephan

[EVGL]

Цитата:

Сообщение от SteEng

Sorry EVGL,

That didn't work. Exception: Invalid Field/ Related field combination.

STephan

Sorry, the right ID would be 61448.

[SteEng]

Thanks,

I should have seen that myself.