Doplnenie:
pouzivam liferay 6.0.5
a pokusam sa o select z vlastnej web aplikacie (portletu)
kniznice pre pristup k liferay mam
<dependency>
<groupId>com.liferay.portal</groupId>
<artifactId>portal-service</artifactId>
<version>6.0.5</version>
<scope>provided</scope>
</dependency>
<dependency>
<groupId>com.liferay.portal</groupId>
<artifactId>util-java</artifactId>
<version>6.0.5</version>
<scope>provided</scope>
</dependency>
<dependency>
<groupId>com.liferay.portal</groupId>
<artifactId>util-bridges</artifactId>
<version>6.0.5</version>
<scope>provided</scope>
</dependency>
On Mon, Dec 6, 2010 at 12:30 PM, Tomas Baca <[email protected]> wrote:
> 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
>
