Small and medium business | Business Central, N...

Is there a way to get all field names from a table?

(0) Share

Report

Posted on by Connor Hyde

Hi All,

I'm working in AL and the only way I've seen to get field names is using the Record.Field() method, which requires field name as a parameter...

I tried to create a loop that went from 0 to field count and retrieved field(Index), however the field numbers often skip and can sometimes go upwards of 1000, which would take an extremely long time if I tried to iterate the index that high. Are there any other ways I could loop through a table and get each field?

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

Inge M. Bruvik 1,105 Moderator on at

Like (0)

Report

If you want to do it programmatically you must look into using field ref and record ref variables.

docs.microsoft.com/.../recordref-data-type

Was this reply helpful? Yes No
Suggested answer

MahGah 15,529 on at

Like (1)

Report

Hi

see this article

https://docs.microsoft.com/en-us/dynamics-nav/field-virtual-table

if you are in BC SaaS then try https://businesscentral.dynamics.com/?table=2000000041

or see https://yzhums.com/1055/

Was this reply helpful? Yes No
Connor Hyde 70 on at

Like (0)

Report

Hi NorthW,

Thanks for the response, would you be able to elaborate any more on how I could manipulate these variables to get what I need? I've been messing around with them and I'll post the closest thing I have to getting them all. It would work, however since the field numbers don't increment by one I think this would take way too long. The last field on table "Item" has a number of 99008500.

*Edit I forgot to include that FieldNum starts at 0

Was this reply helpful? Yes No
Connor Hyde 70 on at

Like (0)

Report

I think I've got something working. Similar to what I have above, but instead you can use RecRef.FieldIndex(Iterator), which returns the index of the fields, regardless of the actual assigned field number.

Was this reply helpful? Yes No
Vlad_K 10 on at

Like (0)

Report

Hi,

Best option is to use Field Virtual Table as suggested by MahGah. No RecRefs, no loops, just a table with complete list of fields with IDs and Names and many other.

BR,

-Vladimir

Was this reply helpful? Yes No