Filtering through multiple combo boxes

Thanks Krishna and Marin for your respective reply.

Krishna,

Your code did work as I needed but again I have one more question.

I have one more combo box which has values >(greater than), less than(<) and many more…

In its modified method:

public boolean modified()

{

boolean ret;

ret = super();

if(ret)

{

if(FIMMHours1ConditionComboBox.selection() == FIMMFilters::Element1)

{

qbr2.value(strFmt(’(FIMMWeeklyHours > qbr.value)’)); /// here I want to access other combo boxes’s qbr value

FIMMSummarizationTable_ds.executeQuery();

FIMMSummarizationTable_ds.research();

}

}

return ret;

}

public void init()

{super();

qbr = FIMMSummarizationTable_ds.query().dataSourceName(‘FIMMSummarizationTable’).addRange(fieldNum(FIMMSummarizationTable,FIMMWeeklyHours));//for filtering according to hours1

qbr1 = FIMMSummarizationTable_ds.query().dataSourceName(‘FIMMSummarizationTable’).addRange(fieldNum(FIMMSummarizationTable,FIMMWeeklyHours));//for filtering according to hours2

qbr2 = FIMMSummarizationTable_ds.query().dataSourceName(‘FIMMSummarizationTable’).addRange(fieldNum(FIMMSummarizationTable,FIMMWeeklyHours));//for filtering according to condition hours1

}

All 3 combo boxes are accessing to access the same columns i.e. FIMMWeeklyHours

Any idea how to proceed

Please advice.

Thanks,

Shankar Iyer