Dynamics 365 CommunityForums Microsoft Dynamics AX (Archived) fieldstr vs fieldnum w...

fieldstr vs fieldnum whats the difference?

(1) Share

Report

Posted on by NoobDaxCoder

Is there any difference between fieldstr and fieldnum?

QueryBuildDataSource qbds;
qbds = this.query().dataSourceTable(tableNum(Test));
qbds.name('Test');
qbds.addRange(fieldNum(Test, CustGroupId)).value(strFmt('((%1.%2 == "20") || (%1.%3 == "30"))', qbds.name(),
fieldStr(Test, CustGroupId),
fieldStr(Test, CustGroupId)));

Code doesnt work if i replace fieldnum with fieldstr.

*This post is locked for comments

All responses (4)

Answers (2)

NoobDaxCoder on at

Like (0)

Report

RE: fieldstr vs fieldnum whats the difference?

Thank you Nikolaos.
Verified answer

nmaenpaa 101,156 on at

Like (0)

Report

RE: fieldstr vs fieldnum whats the difference?

You are using an expression in your query range. There you need to use the field name. Normal simple range values don't contain field ids or names but if you want to use expressions, you need to use table and field names.
NoobDaxCoder on at

Like (0)

Report

RE: fieldstr vs fieldnum whats the difference?

And fieldstr is required to pass value to range?
Verified answer

nmaenpaa 101,156 on at

Like (1)

Report

RE: fieldstr vs fieldnum whats the difference?

FieldNum returns the field id.

FieldStr returns the field name.

QueryBuildDataSource.addRange method wants field id as a parameter.