I have this query:
SELECT {p.productId} FROM {PriceRow as p} GROUP BY {p:productId}, {p:store}, {p:price} HAVING count(*) > 1
But I don't need the productId, I need the PK. How can I get that? I tried to changed {p.productId} for {p.pk} but it do...
I need to get all pricerows who has more than one price in the same basestore with flexible search query. It's that possible? I think the correct way to get this is doing a select inside the select.
For example:
price baseStore
15 - baseStore-...
I'm trying to test this method and i have to check the count works fine.
@Override<br>public List<OrderEntryItemModel> findOrderEntriesByStore(final BaseStoreModel store, final Date modifiedTime,<br> ...
Im trying to extract all OrderEntryItemModel filtering by BaseStoreModel. OrderEntryItemModel is a child of AbstractOrderEntryModel and i am trying to use this flexible search
select {oe.pk} from {OrderEntryItem as oe join AbstractOrderEntry as ...