Data Filter for all Data Sets within a Report

san9jay

<p>I am attempting to integrate the BIRT engine within my web application and basic integration has been successful so far.</p><p> </p><p>I would now like to implement a security wrapper around all data sets within any birt report so that I can optionally check for the existence of a specific column value in all data sets.</p><p> </p><p>I know that filtering within a report is possible, however  I would like to do this at a framework level so that this security check can be applied for any BIRT report without having to change the report itself.</p><p> </p><p>For example if a BIRT report has 3 data sets that are used to display the report data.</p><p> </p><p>When executing the report within my web application I would like to check that every data set in that report returns a value X for a column SECURITY_CONTEXT.</p><p> </p><p>If either the column is missing or does not have the expected value I would throw an error.</p><p> </p><p>I would appreciate any hints on how I could achieve this.</p><p> </p><p>Thanks</p><p> </p><p>Regards</p><p>Sanjay</p><p> </p><p> </p>

san9jay

<p>I got this to sort of work using the following code</p><p> </p><p>...</p><p>   FilterCondition filter = StructureFactory.createFilterCond();
  filter.setExpr("row["SECURITY_CONTEXT"]");
  filter.setOperator(DesignChoiceConstants.FILTER_OPERATOR_EQ);
  //</p><p>  String myMatchValue="X";
  filter.setValue1("""+myMatchValue+""");</p><p>   // now add the filter to all datasets on the report
  ReportDesignHandle rptHandle = (ReportDesignHandle) design.getDesignHandle();
  List dataSetList = rptHandle.getAllDataSets();
  for (int i = 0; i < dataSetList.size(); i++) {
DataSetHandle dataset = (DataSetHandle) dataSetList.get(i);
dataset.addFilter(filter);
}</p>