Issue with filter in Visual Builder

Summary

I got a rest API with 4 url param , cannot filter using a search button

Content

Hello Expert,

I got a rest API where it contain 4 URL parameter. The requirement is that the user need to click on a search button and then execute the search based on the filter text box.

Please find the SQL from the rest :

SELECT *
FROM (
        SELECT PPR.D_PK, PPD.FIRST_NAME||' '||PPD.LAST_NAME EMPLOYEE_NAME,PPD.PAYROLL_NAME PAYROLL_NAME,
               PPD.PERIOD_NAME PERIOD,PPD.PERSON_NUMBER PERSON_NUMBER,
               PJD.JOB_CODE, PJD.GRADE,PJD.LOCATION_NAME,PJD.DEPARTMENT DEPARTMENT, PED.ELEMENT_NAME,PED.ENTRY_VALUE,