Value Filter does not use table name
Posted: Fri Dec 22, 2006 2:06 am
I wrote some code to add filters to my report using StiFilter. I discovered that when I add an Expression I pass the column name as table.field. However, when I add a Value I can only use the field name or it will not work.
In the Filters UI an expression looks like this:
Field Is: Expression
Value: Incident.Category = CategoryParameter
In the Filters UI a value looks like this:
Field Is: Value
Data Type: String
Column: Category (note table name is not present)
Operator: equal to
Value: Hardware
I was wondering what I would do if there were two different tables that had the same field name?
In the Filters UI an expression looks like this:
Field Is: Expression
Value: Incident.Category = CategoryParameter
In the Filters UI a value looks like this:
Field Is: Value
Data Type: String
Column: Category (note table name is not present)
Operator: equal to
Value: Hardware
I was wondering what I would do if there were two different tables that had the same field name?