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

I have the same question (0)

All responses (4)

Answers (2)

NoobDaxCoder 6 on at

Like (0)

Report

RE: fieldstr vs fieldnum whats the difference?

Thank you Nikolaos.

Was this reply helpful? Yes No
Verified answer

nmaenpaa 101,160 Moderator 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.

Was this reply helpful? Yes No
NoobDaxCoder 6 on at

Like (0)

Report

RE: fieldstr vs fieldnum whats the difference?

And fieldstr is required to pass value to range?

Was this reply helpful? Yes No
Verified answer

nmaenpaa 101,160 Moderator 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.

Was this reply helpful? Yes No