Package com.saperion.ngc.model.resultset

Class QueryModifier

java.lang.Object
com.saperion.ngc.model.resultset.QueryModifier
public final class QueryModifier extends Object
Utility class for query modification.

  • Method Details

    • defineAs

      public static QueryModifier defineAs()
      Defines QueryModifier instance.
      Returns:
      QueryModifier object.

    • extractFromForCount

      public QueryModifier extractFromForCount(String hql)
      Extracts the from-part of a query.
      Parameters:
      hql - query string
      Returns:
      string with from-part

    • createCountQuery

      public String createCountQuery()
      Creates count(*) query from provided query string.
      Returns:
      query string.

    • extractFromPartForCount

      public static String extractFromPartForCount(String hql)
      Extracts the from-part of a query.
      Parameters:
      hql - query string
      Returns:
      string with from-part

    • extendWithOrderBy

      public static String extendWithOrderBy(com.saperion.rmi.SaQueryInfo originalQuery, Map<String,String> cols)
      Extends the provided hql query with order by clause.
      Parameters:
      originalQuery - original query
      cols - column names used as sorting criteria.
      Returns:
      modifyed query for sorting.

    • extractDefinitionName

      public static String extractDefinitionName(String query)
      Extracts the definition name from a query string.
      Parameters:
      query - query string
      Returns:
      definition name or empty string if no definition name was found

    • extractAliasForDefinition

      public static String extractAliasForDefinition(String definition, String query)
      Extracts the alias for the specified definition.
      Parameters:
      definition - the definition
      query - the query-string
      Returns:
      the alias or an empty string if not found

    • removeOrderByClause

      public static String removeOrderByClause(String originalQuery)
      Removes the order-by clause from a query string.
      Parameters:
      originalQuery - original query string
      Returns:
      query string without order-by clause