Extracting all distinct option strong values

damienz
damienz Member Posts: 2
in NAV/Navision Classic Client
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

Answers

  • Juha
    Juha Member Posts: 39
    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
    damienz Member Posts: 2
    Cheers. New to C/AL but I'll give it go now that I know it's not a dead end.

Categories