I would like to filter 3 grids on 3 separate panes from a "search" pane (dialog) search.gif
Each grid has an alias.
Specifically, how do I make a call to a grid on a different Pane?
I'm thinking that the problem is with syntax as in:
{grid.Object_EMBHIRE}.gridFilterSet(userfilter);
{grid.Object_EMBABLE}.gridFilterSet(userfilter2);
{grid.Object_EMBTWC}.gridFilterSet(userfilter3);
My search button code:
Each grid has an alias.
Specifically, how do I make a call to a grid on a different Pane?
I'm thinking that the problem is with syntax as in:
{grid.Object_EMBHIRE}.gridFilterSet(userfilter);
{grid.Object_EMBABLE}.gridFilterSet(userfilter2);
{grid.Object_EMBTWC}.gridFilterSet(userfilter3);
My search button code:
Code:
var keyword = {dialog.Object}.getValue('JOBTITLEID'); var payrate = {dialog.Object}.getValue('PAYRATE'); var exclude = {dialog.Object}.getValue('exclude'); keyword = "'" + keyword.replace(/,/g,"','") + "'"; var userfilter; var userfilter2; var userfilter3; if (exclude === ''){ userfilter = 'JOBTITLE IN (' +keyword+ ') or DUTIES IN (' +keyword+ ') and ENDSALARY >= ' +payrate; userfilter2 = 'JOB1_TITLE IN (' +keyword+ ') OR JOB1_DUTIES IN (' +keyword+ ') OR JOB2_TITLE IN (' +keyword+ ') OR JOB2_DUTIES IN (' +keyword+ ') OR JOB3_TITLE IN (' +keyword+ ') OR JOB3_DUTIES IN (' +keyword+ ') OR RESUME IN (' +keyword+ ') and JOB1_SALARY >= ' +payrate; userfilter3 = 'RESUME IN (' +keyword+ '); }else{ userfilter = 'JOBTITLE IN (' +keyword+ ') or DUTIES IN (' +keyword+ ') and ENDSALARY >= ' +payrate+ ' and COMPANYNAME NOT LIKE "%' +exclude+ '%" '; userfilter2 = 'JOB1_TITLE IN (' +keyword+ ') OR JOB1_DUTIES IN (' +keyword+ ') OR JOB2_TITLE IN (' +keyword+ ') OR JOB2_DUTIES IN (' +keyword+ ') OR JOB3_TITLE IN (' +keyword+ ') OR JOB3_DUTIES IN (' +keyword+ ') OR RESUME IN (' +keyword+ ') and JOB1_SALARY >= ' +payrate+ ' and COMPANYNAME NOT LIKE "%' +exclude+ '%" '; userfilter3 = 'RESUME IN (' +keyword+ ') and COMPANYNAME NOT LIKE "%' +exclude+ '%" '; } {grid.Object_EMBHIRE}.gridFilterSet(userfilter); {grid.Object_EMBABLE}.gridFilterSet(userfilter2); {grid.Object_EMBTWC}.gridFilterSet(userfilter3);
Comment