Extracting all distinct option strong values

damienz

Hi there
Has anyone ever tried to extract all option string from NAV, i.e. iterating over every option field of every table and returning the text value of these option fields in a given language?
Thanks

Juha

I have never done it, but it should be easy.
Loop Field table filtered on Type = option
for each option field make a FieldRef and use OptionCaption on FieldRef to get the text values

damienz

Cheers. New to C/AL but I'll give it go now that I know it's not a dead end.