public static Query createQuery(long seqId) {
Select select =
new Select(
new String[] {
"*",
"left/*",
"left/category/*",
"right/*",
"right/category/*",
"categoryLink/left/*",
"categoryLink/right/*",
"categoryLink/left/parent/*",
"categoryLink/right/parent/*",
"categoryLink/left/parent/parent/*",
"categoryLink/right/parent/parent/*",
"categoryLink/left/parent/parent/parent/*",
"categoryLink/right/parent/parent/parent/*",
"categoryLink/left/parent/parent/parent/parent/*",
"categoryLink/right/parent/parent/parent/parent/*",
"categoryLink/left/parent/parent/parent/parent/parent/*",
"categoryLink/right/parent/parent/parent/parent/parent/*",
"categoryLink/left/parent/parent/parent/parent/parent/parent/*",
"categoryLink/right/parent/parent/parent/parent/parent/parent/*",
});
From from = new From(TaxonomyMap.TYPE_NAME_TAXONOMY_MAP, TaxonomyMap.NAMESPACE_URI);
Where where = new Where();
where.addExpression(Property.forName(TaxonomyMap.PROPERTY.seqId.name()).eq(seqId));
return new Query(select, from, where);
}
public static Query createQuery() {
Select select =
new Select(
new String[] {
"*",
});
From from = new From(TaxonomyMap.TYPE_NAME_TAXONOMY_MAP, TaxonomyMap.NAMESPACE_URI);
OrderBy orderBy = new OrderBy();
orderBy.addProperty(Property.forName(TaxonomyMap.PROPERTY.name.name()));
Query query = new Query(select, from, orderBy);
return query;
}