requestTransformOptions

Content

I have ADP based table. On VBEnter event data rows displaying fine in table.

I have filtering requirement.     I have a SelectOneChoice dropdown on selecting  value here fires  a Event.   On this selected value I want to filter rows in the ADP based table below.

Question :-   Is  requestTransformOptions Only way to filter rows on ADP based table ?   Or is there any better option ?   I was able to use requestTransformOptions for single attribute  and I am hoping it will let me filter on more than one attributes (  AND ,   OR  condition  etc   ).   Anybody used requestTransformOptions asking bcaz i have not seen ang blog, sample on this.