java.lang.Object
- de.businesscode.bcdui.wrs.load.WrqFilter2Sql

```
public class WrqFilter2Sql
extends java.lang.Object
```
Parses a f:Filter expression and returns the SQL Where expression For older change history, see WrsSqlGenerator

Constructor Summary

Constructors
Constructor Description

WrqFilter2Sql(WrqInfo wrqInfo, org.w3c.dom.Element root, boolean useAggr)

Method Summary

All Methods Static Methods Instance Methods Concrete Methods
Modifier and Type	Method	Description
`protected static java.lang.String`	`generateSingleColumnExpression(WrqInfo wrqInfo, org.w3c.dom.Element item, java.util.Collection<org.w3c.dom.Element> boundVariables, org.w3c.dom.Document ownerDocument, boolean useAggr)`	Helper for WHERE clause generation ignoreCase is only allowed for dimensions and non-numeric types TODO If a non-dim bindingItem is used multiple times with different aggr in the select list, the aggr of the last one wins This limitation could be removed by allowing to overwrite the aggr at the having-filter expression, for example
`java.lang.String`	`getAsSql(java.util.Collection<org.w3c.dom.Element> elementList)`
`static java.lang.String`	`getOperatorMapping(java.lang.String op)`

Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

WrqFilter2Sql

public WrqFilter2Sql(WrqInfo wrqInfo,
                     org.w3c.dom.Element root,
                     boolean useAggr)
              throws javax.xml.xpath.XPathExpressionException

Throws:: javax.xml.xpath.XPathExpressionException

Method Detail

getAsSql

public java.lang.String getAsSql(java.util.Collection<org.w3c.dom.Element> elementList)
                          throws BindingNotFoundException

Throws:: BindingNotFoundException

generateSingleColumnExpression

protected static java.lang.String generateSingleColumnExpression(WrqInfo wrqInfo,
                                                                 org.w3c.dom.Element item,
                                                                 java.util.Collection<org.w3c.dom.Element> boundVariables,
                                                                 org.w3c.dom.Document ownerDocument,
                                                                 boolean useAggr)
                                                          throws BindingNotFoundException

Helper for WHERE clause generation ignoreCase is only allowed for dimensions and non-numeric types TODO If a non-dim bindingItem is used multiple times with different aggr in the select list, the aggr of the last one wins This limitation could be removed by allowing to overwrite the aggr at the having-filter expression, for example

Parameters:: wrqInfo -; item -; boundVariables -; ownerDocument -; useAggr -
Returns:
Throws:: BindingNotFoundException

getOperatorMapping

public static java.lang.String getOperatorMapping(java.lang.String op)

Class WrqFilter2Sql

Constructor Summary