I am using the Corasworks webparts in a few sites, not the whole Suite as Corasworks offers to install it, as it will install around 25 templates and 30+ webpart which will pollute my server but I only have installed the webpart I need : Graphs, Active Display (or called the new roll-ups –the name keep changing :-(
The webpart Active Display or what I keep calling (as previous version) Roll-up, is used to pull data from lists or document libraries from other sites and lists on different sites or even site-collection and display in a list style in a page, other webpart can even display the data in a graph style.
Yes it does mimic the feature of the “Content Query Web Part” but you don’t need to change any XML to add column or action such as Edit item. (and despite they did it before there was the content query included into MOSS.
This week I came across a problem when filtering on a Boolean column.
I create a column called “Filter-Historic” which is computed and the result is either True or False, in Sharepoint the value is displayed as 1 or 0.
To filter the roll-up I just open the Webpart in Admin mode, go to the Filtering tab and add my filter as to only display Filter-Historic is equal to 1 ].
When testing the WebPart, no data was returned. I then tried to use [ Filter-Historic is equal to “1” ], still it would not show any data.
In that case the Webpart does not allow to filter on Boolean column using the filter builder, instead we need to use the CAML filter integrated with the Webpart.
This webpart offers to enter a “Manual filter” which in turns is a query in CAML.
when we open the CAML dialog box we can see that the calculated column is understood by the filter as “Calculated”, just by changing the Value Type to “Boolean” it will fix the Filter to understand the value 1 or 0 from the calculated column.
Solution summary –> updating the [Value Type=”Calculated”] to read [Value Type=”Boolean”].