How to use

renderOrderByStringTemplate

method

in

org.hibernate.sql.Template

/**
 * Performs order-by template rendering without {@link ColumnMapper column mapping}.  An <tt>ORDER BY</tt> template
 * has all column references "qualified" with a placeholder identified by {@link Template#TEMPLATE}
 *
 * @param orderByFragment The order-by fragment to render.
 * @param dialect The SQL dialect being used.
 * @param functionRegistry The SQL function registry
 *
 * @return The rendered <tt>ORDER BY</tt> template.
 *
 * @deprecated Use {@link #translateOrderBy} instead
 */
@Deprecated
public static String renderOrderByStringTemplate(
    String orderByFragment,
    Dialect dialect,
    SQLFunctionRegistry functionRegistry) {
  return renderOrderByStringTemplate(
      orderByFragment,
      NoOpColumnMapper.INSTANCE,
      null,
      dialect,
      functionRegistry
  );
}

  public String doStandardRendering(String fragment) {
    return Template.renderOrderByStringTemplate( fragment, MAPPER, SESSION_FACTORY, DIALECT, FUNCTION_REGISTRY );
  }
}

/**
 * Performs order-by template rendering without {@link ColumnMapper column mapping}.  An <tt>ORDER BY</tt> template
 * has all column references "qualified" with a placeholder identified by {@link Template#TEMPLATE}
 *
 * @param orderByFragment The order-by fragment to render.
 * @param dialect The SQL dialect being used.
 * @param functionRegistry The SQL function registry
 *
 * @return The rendered <tt>ORDER BY</tt> template.
 *
 * @deprecated Use {@link #renderOrderByStringTemplate(String,ColumnMapper,SessionFactoryImplementor,Dialect,SQLFunctionRegistry)} instead
 */
@Deprecated
public static String renderOrderByStringTemplate(
    String orderByFragment,
    Dialect dialect,
    SQLFunctionRegistry functionRegistry) {
  return renderOrderByStringTemplate(
      orderByFragment,
      NoOpColumnMapper.INSTANCE,
      null,
      dialect,
      functionRegistry
  );
}

/**
 * Performs order-by template rendering without {@link ColumnMapper column mapping}.  An <tt>ORDER BY</tt> template
 * has all column references "qualified" with a placeholder identified by {@link Template#TEMPLATE}
 *
 * @param orderByFragment The order-by fragment to render.
 * @param dialect The SQL dialect being used.
 * @param functionRegistry The SQL function registry
 *
 * @return The rendered <tt>ORDER BY</tt> template.
 *
 * @deprecated Use {@link #renderOrderByStringTemplate(String,ColumnMapper,SessionFactoryImplementor,Dialect,SQLFunctionRegistry)} instead
 */
@Deprecated
public static String renderOrderByStringTemplate(
    String orderByFragment,
    Dialect dialect,
    SQLFunctionRegistry functionRegistry) {
  return renderOrderByStringTemplate(
      orderByFragment,
      NoOpColumnMapper.INSTANCE,
      null,
      dialect,
      functionRegistry
  );
}

hasOrder = sqlOrderByString != null;
sqlOrderByStringTemplate = hasOrder ?
    Template.renderOrderByStringTemplate(sqlOrderByString, dialect, factory.getSqlFunctionRegistry()) :
    null;
sqlWhereString = StringHelper.isNotEmpty( collection.getWhere() ) ? "( " + collection.getWhere() + ") " : null;

hasOrder = sqlOrderByString != null;
sqlOrderByStringTemplate = hasOrder ?
    Template.renderOrderByStringTemplate(sqlOrderByString, dialect) :
    null;
sqlWhereString = collection.getWhere();

sqlOrderByStringTemplate = Template.renderOrderByStringTemplate(
    collection.getOrderBy(),
    mapper,
manyToManyOrderByTemplate = Template.renderOrderByStringTemplate(
    collection.getManyToManyOrdering(),
    mapper,

sqlOrderByStringTemplate = Template.renderOrderByStringTemplate(
    collection.getOrderBy(),
    mapper,
manyToManyOrderByTemplate = Template.renderOrderByStringTemplate(
    collection.getManyToManyOrdering(),
    mapper,