4 Replies Latest reply: Apr 29, 2015 2:20 PM by Joanna Seldon RSS

    show specific field ranges as drop down menues / filters

    Joanna Seldon

      hiya

       

      I wish to show different field range drop down menus

       

      e.g

       

      1. date

       

      date is derived from order date. I want to in the data load editor run a but of script that will create a new year selector (year specific)  drop down that e.g only shows years from 2010 onwards

       

      at the moment mine shows all years 2015 to 1989, but I want to show just from 2010 onwards, as all data is irrelevant or old.

       

      or is the a way to get the filter pane to sort by expression only show year 2010 and other years onwards?

       

      2. department

       

      each department has a code Department code xxx111, xxx222, xxx999 ect

       

      same again I want to in the data load editor run a but of script that will create a new department selector  (department specific) drop down that e.g only shows departments with codes that end xxx999 only

       

      or is the a way to get the filter pane to sort by expression only show using department code xxx999  departments only?

       

      please help

       

      kind regards