How to use

getAncestorsIdsSql

method

in

org.nuxeo.ecm.core.storage.sql.jdbc.dialect.Dialect

/**
 * Select all ancestors ids for several fragments.
 * <p>
 * Fast alternative to the slowest iterative {@link #getSelectParentIds}.
 *
 * @return null if it's not possible in one call in this dialect
 */
public SQLInfoSelect getSelectAncestorsIds() {
  String sql = dialect.getAncestorsIdsSql();
  if (sql == null) {
    return null;
  }
  Table table = database.getTable(Model.HIER_TABLE_NAME);
  Column mainColumn = table.getColumn(Model.MAIN_KEY);
  // no soft-delete check needed, as ancestors of a non-deleted doc
  // aren't deleted either
  return new SQLInfoSelect(sql, Collections.singletonList(mainColumn), null, null);
}