GETFILTERS but return description as well

fini
fini Member Posts: 18
in NAV Tips & Tricks
I show the filters used on a report with a GETFILTERS variable. But next to the value of a filter I'd like to show it's description as well (eg. Item category code:0001 -> Item category code:0001 Standard products)
4vr2qp0kbwq8.png

Answers

  • edoderoo
    edoderoo Member Posts: 89
    Get filter will only give you values that are filtered, if you would enter 001|003|008, then you get these three values with a pipe in between as a result. You want to show other fields from the connected filter values, that will require additional coding. Then you need to read the record, and from there display the value.
    IF User.Loves('Edo') THEN ok() ELSE currReport.genSkip;
  • Phogue
    Phogue Member Posts: 76
    You can call getfilter on the field item category code, use that to get the item category, and get the description that way.

Categories