Query a custom field (table extension)

(0) Share

Report

Posted on by kjjson

I added a custom field to the table "Production Order". Now I am trying to create a query that includes that custom field, but in AL I am not seeing that field as a column in my dataitem(), and if I just enter in the column, it states "The source of a column or filter must be a field defined on the table referenced by its parent DataItem. I am hoping I am just missing something simple. I reran the Download Symbols, but still have the issue.

Thanks,

Kevin

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

Stefano Demiliani 37,166 Most Valuable Professional on at

Like (0)

Report

Is the query object created in the same extension where you have defined the tableextension object with your new field?

If so, you can see the field for sure.

If the query is defined on another extension, you need to have a dependency from the extension where you have defined the new field (the extension that declares the tableextension object).

Was this reply helpful? Yes No
kjjson on at

Like (0)

Report

Thanks Stefano,

the query is from a different extension and you pointed me in the right direction with the dependency and I was able to get it.

Kevin

Was this reply helpful? Yes No
Julianexp 10 on at

Like (0)

Report

Hola, tengo el mismo problema, como agrego la dependencia ?? simplemente no logro acceder a los campos personalizados desde otra extension

Was this reply helpful? Yes No
Julianexp 10 on at

Like (0)

Report

Ya lo resolvi, paso un link de apoyo https://yzhums.com/2434

Me dieron un norte, gracias!!

Was this reply helpful? Yes No