Dobry den
Potreboval by som poradit ako vyselectovat AssetEntry z liferay
databazy ktore maju urcity tag + chcel by som pridat dalsie Criteria.
Momentalne skusam DynamicQuery zatial bez vysledku:
Viem spravit select pre AssetTag
String tagName = "xyz";
DynamicQuery qat = DynamicQueryFactoryUtil.forClass(AssetTag.class,
"assetTag", PortalClassLoaderUtil.getClassLoader())
.setProjection(ProjectionFactoryUtil.property("tagId"))
.add(RestrictionsFactoryUtil.like("assetTag.name", tagName));
Skusal som JOIN s AssetEntry co je, ale chybne pretoze v tomto pripade
ide o vstah many-to-many cez tabulku assetentries_assettags.
DynamicQuery qae = DynamicQueryFactoryUtil.forClass(AssetEntry.class,
"assetEntry", PortalClassLoaderUtil.getClassLoader())
.add(PropertyFactoryUtil.forName("assetEntry.entryId").in(qat))
.add(PropertyFactoryUtil.forName("assetEntry.companyId")
.eq(themeDisplay.getCompanyId()))
.addOrder(OrderFactoryUtil.desc("viewCount"));
Vedel by mi niekto poradit ako na to ?
Dakujem
