How do you remove or check for foundset filter params? Each time we run a method that adds a filter param, the parameter is added to the end of the last SQL statement. When this additional parameter is added it slows the application down each time. From what we can see, the only way to remove these parameters is to close the session. We attempted to use the founset.clear() method with no success. Although in the Servoy Reference Guide under addFoundSetFilterParam it says "NOTE: As of Servoy 4.0, the addFoundSetFilterParam can be added and/or removed at any time."
SQL 1st filter parameter:
=>databaseManager.getSQL(forms.__hr_tech_dtbl.foundset)
"select WK_PK from F_PERSONNEL where WK_PK in (select wkrc_wk_fk from f_personnel_rcs where wkrc_rc_fk IN (4,3) or wkrc_rc_fk is null group by wkrc_wk_fk) order by WK_ID_CODE asc"
SQL 2nd filter parameter:
=>databaseManager.getSQL(forms.__hr_tech_dtbl.foundset)
"select WK_PK from F_PERSONNEL where WK_PK in (select wkrc_wk_fk from f_personnel_rcs where wkrc_rc_fk IN (4,3) or wkrc_rc_fk is null group by wkrc_wk_fk) and WK_PK in (select wkrc_wk_fk from f_personnel_rcs where wkrc_rc_fk IN (4,3) or wkrc_rc_fk is null group by wkrc_wk_fk) order by WK_ID_CODE asc"