Visual Builder

Get Involved. Join the Conversation.


    Shakila Murugan
    How to do multiple filed filter for the table data from ADP...
    Topic posted August 20, 2019 by Shakila MuruganBronze Medal: 1,250+ Points, tagged Action Flows, Business Objects, Custom Code, JET, Services, UI 
    27 Views, 3 Comments
    How to do multiple filed filter for the table data from ADP type?

    Hi Team,

    I consuming report data and return list of values in array format. then i show that data into table format using ADP Type.

     <oj-table summary="Sample Table" scroll-policy="loadMoreOnScroll" id="oj-table--1443662657-1" class="oj-flex-item oj-sm-12 oj-md-12" 
      {"headerText":"ID","field":"id"}]' data="{{ $variables.employeeDetBasedApprover }}" selection-mode.row="single" ></oj-table>

    employeeDetBasedApprover -->ADP Variable

    How to do multiple filed filter for the table data? Is it  possible?

    Please kindly guide me.







    • Shay Shmeltzer

      You need to decide where you want to execute the filtering.

      If it is on the server side (the source of the data), then you'll need to have a REST service that support accepting parameters and returning a filtered list.

      If you want to filter it on the client, then you can write a JS module function that accepts that data array from the ADP and a set of filter parameters, then you loop over the array and pick only the records you want to return from the function as a new array, and assign it to the data array of the ADP.