Home » Search

About member

171-180 of 191Refresh
Forum
1

Get multiple entities by Id

I'm trying to fetch a list of entities, by their Id. I Use this query: SELECT c FROM User c WHERE c.id IN :ids This querey works as long as I don't set the property "id" as @Id. If i set @Id to any other member, this query works, if I set id as @Id, it stops working and gives zero results
Forum
1

IN operator syntax

works fine: SELECT FROM Info i WHERE i.status IN (1) The same behavior is when using MEMBER
Issue
1

InternalException - error reading field from "queue" database

.A(UMR.java:941) at com.objectdb.o.UMR.z(UMR.java:569) ... 22 more The _payload member referenced in
Issue
1

JPQL support for mapped by (inverse) collections

As discussed and demonstrated in this forum thread, collection operators and methods (IS EMPTY, SIZE, MEMBER OF, IN) are currently not supported for mapped by (inverse) collections. These operations are supported for direct (not mapped by) collections. Navigation and JOIN is supported
Forum
1

Navigation and Parameters

Greetings ObjectDB team, Suppose I pass a List of persistent objects to some query as a parameter, can I navigate to those objects' fields ? E.g.: SELECT x FROM ClassX x WHERE x.a IS MEMBER OF :y.b Thank You ! You cannot navigate from a collection of objects to a field in these objects directly
Forum
1

Navigation through Path to evaluate collection

"+        "WHERE item.sku =: key "+        "OR id MEMBER OF :item.apiId.identifier "+        "ORDER BY item
Forum
1

Nested Collection Query

Hi Sir,    I have a persisted field of the type:   List> groupMembers   How do I check if a particular member exist in one of the group? Nesting a collection directly in another collection, although supported by ObjectDB, is not valid in JPA. Accordingly the JPA query language does not
Forum
1

Performance in SELECT statement

of embeddable class. Define a path index on TestEntity instead: @Entity @Index(members={"state
Forum
1

Problem with Composite indices

Hi, I want to realize the following: I have 2 classes, one Client class which looks like: public class Client { @Index (unique = "true") private String name; } and a User class which looks like: @Index (members = {"client", "emails"}) public class User { private Client client
Forum
1

Query to find object from element of a contained collection

I have an OrderData class, containing an OrderItemData collection, i would like to find OrderData elements by OrderData.items.itemId. I cant get a proper query with MEMBER OF or IN. Does anyone have an idea on how i could formulate that as Typed or CriteriaBuilder query? Thanks.   @Entity public