Visual Builder

Get Involved. Join the Conversation.

Topic

    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
    Title:
    How to do multiple filed filter for the table data from ADP type?
    Content:

    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" 
      columns='[{"headerText":"EES_REQUEST_NO","field":"eESREQUESTNO"},
      {"headerText":"PERSON_NAME","field":"pERSONNAME"},
      {"headerText":"PERSON_NO","field":"pERSONNO"},
      {"headerText":"SPONSORSHIP_STATUS","field":"sPONSORSHIPSTATUS"},
      {"headerText":"COMMENTS","field":"cOMMENTS"},
      {"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.

    Regards,

    Shakila

     

    Version:
    19.1.3

    Comment

     

    • 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.