Finance | Project Operations, Human Resources, ...

How to retrieve the custom attribute using Query

(0) Share

Report

Posted on by CJ

512

Hi,

I have an issue regarding the custom attributes that I added in SalesLine. When I am using Query, it was not included the custom attribute when I run the queryRun.

Here is the Sample Code.

-Entity [SalesLine]

- SalesOrderType // Custom Attributes.

----------------------------------------------------------------------------------------------------------------

Sample Code:

Query query;

Query queryRun;

QueryBuildDataSource qbds;

query = new Query();

query.alloCrossCompany(true);

qbds = query.addDataSource(tablenum("SalesLine"));

qbr = qbds.addRange(fieldNum(SalesLine,SalesId));

qbr.value("= SO00001");

queryRun = new Query(query);

while(queryRun.next())

{

SalesLine line = queryRun.get(tablenum(SalesLine));

if(line)

{

var salesorderType = line.SalesOrderType;

}

Thank you for your reply.

Regards,

I have the same question (0)

All responses (6)

Answers (0)

Sort by

Mea_ 60,286 on at

Like (0)

Report
Copy link

Link copied!

Are you sure that it hits " var salesorderType = line.SalesOrderType;" line at all ?

It should be qbr.value("SO00001") instead of qbr.value("= SO00001");

Was this reply helpful? Yes No
CJ 512 on at

Like (0)

Report
Copy link

Link copied!

Hi ievgen,

Yes, the filter it's working but my issue that my new attributes salesOrdertype is not there in my SalesLine when I am going to debug. I extend salesLine entity to add my new attributes.

Was this reply helpful? Yes No
Suggested answer

Mea_ 60,286 on at

Like (0)

Report
Copy link

Link copied!

Its under "extension fields" or something like that. So in debugger you should see group that you can expand and all fields added via extensions will be there.

Was this reply helpful? Yes No
Suggested answer

CJ 512 on at

Like (0)

Report
Copy link

Link copied!

Hi,

There is an extension fields group like this below.

((Microsoft.Dynamics.Ax.Xpp.TableExtensionFields)new Dynamics.AX.Application.SalesTable.SalesTableDebuggerProxy(header).Extension_Fields).Items[1]

Was this reply helpful? Yes No
Mea_ 60,286 on at

Like (0)

Report
Copy link

Link copied!

Where are you looking at ? In the end of the day you can just write

info(strFmt('%1', salesorderType ));

and see if it has a value.

Was this reply helpful? Yes No
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Good Morning Christian,

Just wanted to follow up on this issue and ask if your issue has been resolved in the meantime.

If it is resolved then please be so kind and provide some feedback my marking the answers as verified to let also other community members know what helped.

Many thanks for your support.

Best regards,

Ludwig

Was this reply helpful? Yes No