Package de.businesscode.bcdui.wrs.load

Class WrqFilter2Sql

java.lang.Object

de.businesscode.bcdui.wrs.load.WrqFilter2Sql

public class WrqFilter2Sql
extends 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, Element root, boolean useAggr)

Method Summary

Modifier and Type	Method	Description
protected String	generateSingleColumnExpression(WrqInfo wrqInfo, Element item, List<Element> boundVariables, 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
String	getAsSql(List<Element> elementList)
static String	getOperatorMapping(String op)

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Details

WrqFilter2Sql

public WrqFilter2Sql(WrqInfo wrqInfo,
 Element root,
 boolean useAggr)
              throws XPathExpressionException

Throws:

XPathExpressionException

Method Details

getAsSql

public String getAsSql(List<Element> elementList)
                throws Exception

Throws:

Exception

generateSingleColumnExpression

protected String generateSingleColumnExpression(WrqInfo wrqInfo,
 Element item,
 List<Element> boundVariables,
 Document ownerDocument,
 boolean useAggr)
                                         throws Exception

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:

Exception

getOperatorMapping

public static String getOperatorMapping(String op)