@Override
    public List<ExplorerTreeNode> findByNames(final List<String> names,
                                              final boolean allowWildCards) {
        final Condition nameConditions = JooqUtil.createWildCardedStringsCondition(
                n.UUID, names, allowWildCards, BooleanOperator.OR);

        return JooqUtil.contextResult(explorerDbConnProvider, context ->
                        context
                                .selectFrom(n)
                                .where(nameConditions)
                                .fetch())
                .map(this::mapRecord);
    }
Get the root node containing a particular node, or the node itself if it is a root node.
stroom-explorer/stroom-explorer-impl-db/src/main/java/stroom/explorer/impl/db/ExplorerTreeDaoImpl.java