8 Replies Latest reply: Mar 27, 2018 9:21 AM by Raymund Cruz RSS

    How do you put a filter in a table

    Raymund Cruz

      I have created a table that I want to pubulish. I only want to display  returnable item.  How do I go about doing it in which I can eliminate the 'Returnable column' from the grid and have the table  just display  values where Returnable = 'Y'.


      Is there a way to preset the tables to have it automatically filter a set value such as returnable = 'Y'. ?


      Thanks for your help

       



       

      Customer NumberORDERNUMBERDebit Memo NumberReturnableCredit AmountOrder FeeCheck credit Memo  AmountCheck/Credit Memo Number
      102102-2016-100EXPNCN041635867N$0.00$0.00$0.00
      102102-2016-113EXPAH1216116073Y$7.21$2.10$5.113032411
      102102-2016-100EXPAH041638613Y$0.00$0.00$0.00
      102102-2016-112EXPAHN1216104320N$0.00$0.00$0.00
      102102-2016-100EXPAHN0416035701N$0.00$0.00$0.00
      102102-2016-112EXPAHN1216104316N$0.00$0.00$0.00
      102102-2016-113EXPAHN1216104316N$0.00$0.00$0.00-
      102102-2016-100EXPAHN0416035699N$0.00$0.00$0.00
      102102-2016-100EXPAHN0416034443N$0.00$0.00$0.00
      102102-2016-113EXPAHN1216100857N$0.00$0.00$0.00
      102102-2016-112EXPAH1216108054Y$0.06$0.00$0.063061720
      102102-2016-112EXPAHN1216099683N$0.00$0.00$0.00
      102102-2016-113EXPAHN1216099683N$0.00$0.00$0.00-
      102102-2016-102EXPAH071670286Y$0.00$0.00$0.00
      102102-2016-100EXPAH041636827Y$22.18$16.82$5.363028686
      102102-2016-112EXPAH1216108472Y$9.02$3.88$5.143032411