Filter (RecordSelection) Object - RAS

[PavanKumarU]

Hi,
Did anyone work with the filter objects in RAS? I am having an issue working with this object. I am able to retrive the filter defined in the report, but not able to append a new filter to the existing one.
Could someone throw some light please?
Thank,
Pavan

 

[rabbit65]

I have been successful filtering from RAS but I cannot replace the this filter after the first time it is modified.

Here is the code to filter (it assumes you already have a report loaded (clientDoc) and you are logged into the server.)

dim filter
Set filter = clientDoc.DataDefinition.RecordFilter.clone(true)
filter.FreeEditingText="trim({sp_Projects_w_Workelements_and_SpendPlans;1.PM})=""" & rs.fields("initials&quot.value & """"
clientDoc.DataDefController.RecordFilterController.modify filter