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?

All responses (5)

Answers (0)

Vlad_K 10 on at

Like (0)

Report

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

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
Connor Hyde 70 on at

Like (0)

Report

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

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.
Connor Hyde 70 on at

Like (0)

Report

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

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
Suggested answer

MahGah 15,443 on at

Like (1)

Report

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

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/
Suggested answer

Inge M. Bruvik 1,025 Moderator on at

Like (0)

Report

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

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

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