Search these areas:
Help
Support Forums
Product Info



-Introduction
-DataWeb: What's New
-Creating an Application
-The DataWeb Designer
-Application Management
-Data Tables
-Data Tables
-Views
-Templates
-Components
-Data Analysis
-Members
-Security
-Importing
-Exporting
-FTP
-JavaScript
-Object Model
-Full-Text Search
-Domain and Email Hosting
-HotBlock Modules
-Account Management
-Glossary
-New Responsive UI Module





DataWeb Help
Support Forums
Tutorial
Script Library
Knowledge Base

Home > Support

Support Forum



Filtering on an aggregated column
xcastro asked:
Hi,
I was wondering if it's possible to put a filter condition on the column results of a Group By data region.

For Example:
I have 4 columns in a view, grouping on the first 3 and performing a Sum on the last, which happens to be "Hours".  I tried the filter condition as follows:  "=Hours > 14" but this didn't get the results I was looking for because I want the filter based on the after grouping result.  So I tried using "=sum_Hours > 14", but I get an error when I attempt this.

Is it possible to perform a filter based on the rollup values or will I have to perform those calculations in script and then filter based on those results?

Thanks!
 
  nicks responded:
  You can filter on an aggregated column, but you have to use the "URL filter syntax" instead of the "SQL Expression" syntax.

That is, your filter should look like:
?sum_Hours~gt=14

The following will not work:
=sum_Hours > 14

SQL Expression filters are not allowed to refer to the names of calculated fields.  They only refer to fields in the tables that you are querying.

Also, the following will not work either:
=sum([Hours]) > 14
I believe that there is the limitation in our current implementation that you cannot use the aggregate functions (sum, min, max, avg, count) in a SQL filter expression.
 
  xcastro responded:
  DataWeb considers this issue closed.
If you have additional questions or comments about this issue, please open it again.
If you have questions about a different topic please open a new support question.

Thanks,
DataWeb Support
 
  Please Log On
or create your own DataWeb Account.
Affiliate | Partner | Terms of Use | Privacy Policy | Contact Us | Pricing | Bring DataWeb In-House    
DataWeb, 720 North 10th Street, A #145, Renton, Washington 98057 *425-583-5970* Fax 484-770-4706* Email Us