I have reviewed the help documents and searched the forum for a way to start a grid application with a search filter. I do not want to append anything to the where clause as this screws up the inline quick search filter. eg lets say I change the where clause by adding sc_select_where(add) = “where mi.mntMonth = ‘08’ and mi.mntYear=‘2016’”; to the OnScriptInit event . If I enter search criteria in the quick search field it will ignore the where clause. ie it doesn’t search WITHIN results.
I have seen some suggestions to use : sc_apl_conf(“grid_app”, “start”,“filter”); which I have changed to : sc_apl_conf(“grid_Agreements”, “start”,“Month Equal 8, and Year Equal 2016”); I added this line to my menu app oninit not to the grid app I want to start with a filter. It doesn’t work.
What is the correct way to use the macro to start the app with my filter?