Questions tagged [criteria]
Mechanism typical to ORM frameworks that allows the creation of queries against a database in a dynamic and object-oriented fashion. When writing a query using Criteria one uses an API instead of writing a query using a defined language (SQL).
criteria
2,836
questions
0
votes
0
answers
28
views
How to write join by Lateral "," in Java Criteria API JPA, Hibernate
I want to achieve the below result with ','
FROM table1 t1,
LATERAL jsonb_array_elements(secret_data->'rating'->'subRating') AS subRatings
WHERE
I want to achieve this with the Criteria API. ...
- 1
0
votes
0
answers
37
views
Workaround for using DetachedCriteria with JPA & Hibernate-6?
In my org, many applications heavily depend on the DetachedCriteria of Hibernate.
The application sends DetachedCriteria to the library which internally uses hibernate sessions and sends the result ...
-3
votes
0
answers
46
views
This coding works great for a single criteria, but how would you modify it for several criteria?
I'm new to VBA and have very little experience with any coding, so my question is very basic. I've attempted to modify the code to simultaneously check each cell in the column for multiple criteria ...
0
votes
1
answer
54
views
Count If Meets Multiple Criteria and Unique
I have read several other relatable questions with responses, including referenced suggestions, but they do not appear to be similar in my requirements or I'm having troubles understanding what they'...
- 65
1
vote
2
answers
135
views
Criteria API error: operator does not exist: integer = integer[]
I have an entity where I have a field of type integer array.
class User {
@ElementCollection
@Column(name = "`location_ids`", columnDefinition = "int[]")
@Type(...
- 481
0
votes
0
answers
31
views
MS-Access 2016 Query String Criteria not Matching
I've been programming in VB, VBA, and Access for years, but this is a new one on me...
I have two table with identical field names that are of the short text data type (255). All other properties are ...
0
votes
1
answer
55
views
ConditionalOperators return null in else case throws exception
I have below code to map the fields with projection.
private static ProjectionOperation getProjectionOperation() {
Cond conditional = ConditionalOperators.when(Criteria.where("...
- 125
0
votes
0
answers
25
views
How to solve "Could not solve attribute x of XClass due to the attribute being declared in multiple subtypes YClass and ZClass"?
I'm receiving the exception InvalidDataAccessResourceUsageException with the following message: "Could not solve attribute 'field' of 'Parent' class due to the attribute being declared in ...
- 33
0
votes
0
answers
14
views
JPA Criteria Query on independent column of JoinTable
I am having Spring Data setup with JPA. Below is the entity structure.
Entity A:
@Entity
@Table(name = "a")
public class A {
...
@Id
@Column(name = "a_id")
@...
- 509
0
votes
0
answers
22
views
How do this in JPA crteria
I have this :
@Entity
@Table(name = "cycle")
public class Cycle extends BaseBean {
// ...
@OneToMany
@JoinColumn(name = "id_cycle")
private List<SousCycle> ...
- 1
1
vote
2
answers
49
views
How can I build a query for searching in range of values?
I am having a trouble in creating a query with criteria builder. I have an Employee table with a column SALARY and salary is being kept in this format: value + currency (example: "1000 EUR")....
- 163
0
votes
0
answers
38
views
VBA Excel Autofilter Using Array For Multiple Values Fails [duplicate]
Filter will not include 49 along with AA, BB, and CC.
Dim myArray As Variant
myArray = Array("AA", "BB", "CC")
CrtTrackWS.Range("A1", "AQ" & ...
0
votes
1
answer
112
views
JPA Criteria - Aliases that does not work on aggregation selection
In a project that uses Hibernate 6.4, I am using the Criteria API provided through Jakarta persistence API (a dependency of Hibernate). However, I encountered a bug while using aliases on aggregation ...
0
votes
1
answer
18
views
Criteria Api: OrderBy Case: How do I sort objects that are in the same case?
I am using Criteria Api to sort and filter my data.
The sort functionallity looks like this:
Expression<Object> caseExpression = criteriaBuilder.selectCase()
.when(criteriaBuilder.equal(...
- 13
1
vote
2
answers
177
views
How can I find the previous date/value with LOOKUP function based on a criteria?
I've been scratching my head round this thing.
I need to perfom the difference between dates, the current date minus the preceding date, while matching an ID (in this case a plate).
I've found a ...
