Databases
StackOverflow2013
Postsdbo
POColdfusion Hibernate - Filter results by field value inside collection
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POColdfusion Hibernate - Filter results by field value inside collection
    primarykey
    data
    text
    <p>I have an entity that has multiple fields; one of the fields is "quantifications", which holds a collection of different entities.</p> <p>I'm querying for this entity in an API controller call that returns a list via JSON. I want to filter the result set I'm returning by the following criteria:</p> <ol> <li>If the "quantifications" field is empty, don't return that entity as part of the result.</li> <li>If the "quantifications" field is not empty, only return entities where all Quantification entities in the collection have a status of "approved".</li> </ol> <p>Coldfusion isn't a language I'm terribly familiar with. I have the following code that meets the first criterion:</p> <pre><code>var EventCriteria = EventService.newCriteria(); EventCriteria.isNotEmpty('quantifications'); </code></pre> <p>How can I check for the second criteria? Thank you.</p> <p><strong>Edit:</strong> Okay, I've been trying a few things, and I'm running into <em>"method not found"</em> errors. Posting the code below.</p> <pre><code>if (NOT showEventsWithoutQuantifications){ EventCriteria.isNotEmpty('quantifications'); var eventStatus = eventStatusService.findWhere(entityName="EventStatus", criteria={eventStatusOrder=javaCast( "int", 150 )}); //approved // According to the Coldbox documentation, this should have worked. It doesn't. // var QuantificationService = quantificationService.newCriteria() // .isEq("Quantification.status", eventStatus) // .withProjections(property="event.eventID"); // EventCriteria.in("eventID", QuantificationService); // .in() method not found. Why? // EventCriteria.add(EventCriteria.restrictions.in("eventID", QuantificationService)); // .in() method not found. Why? EventCriteria.add(wmtEventCriteria.createSubcriteria('Quantifications').isEq("status", eventStatus)); // .createSubcriteria method () method not found. Why? } </code></pre> <p>For what it's worth, the <code>EventService</code> inherits from <code>coldbox.system.orm.hibernate.VirtualEntityService</code>. I haven't found the code for that class yet (as I'm not using a native CF IDE for this) but I would imagine that this should expose the methods in question...?</p> <p>Could this be an issue with the Hibernate version I'm running against? Or perhaps the version of Coldbox?</p>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USGeorge Mauer
    1. USjedd.ahyoung
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POColdfusion Hibernate - Filter results by field value inside collection
      1. USjedd.ahyoung
      1. VTBountyStart
    2. VO
      singulars
      1. POColdfusion Hibernate - Filter results by field value inside collection
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. POColdfusion Hibernate - Filter results by field value inside collection
      1. This table or related slice is empty.
      1. VTUpMod
    1. COThe language is CFML; ColdFusion is the product. Coldbox is an MVC framework. The ORM used is Hibernate.
      singulars
      1. POColdfusion Hibernate - Filter results by field value inside collection
      1. USPeter Boughton
    2. COColdbox provides a [wrapper](http://wiki.coldbox.org/wiki/ORM:CriteriaBuilder.cfm) on the Hibernate [Criteria/Restrictions](https://docs.jboss.org/hibernate/orm/3.3/reference/en/html/querycriteria.html) functionality, so you mainly need to understand that rather than CFML, however I've [tried to] use Criterias a couple of times and found the whole thing a pain to work with - far simpler to just write an SQL (or HQL) query directly against the database.
      singulars
      1. POColdfusion Hibernate - Filter results by field value inside collection
      1. USPeter Boughton
    3. CO@PeterBoughton Yeah. Unfortunately, I'm dealing with inherited code. I'm wondering if there's, like, an `each()` or `all()` call that I can use within the criteria for a collection field, similar to LINQ. Ideally, I'd like to do something like `EventCriteria.Where(x => x.quantifications.All(y => y.Status == true))`, but in this Coldbox format. (That LINQ statement isn't exact.)
      singulars
      1. POColdfusion Hibernate - Filter results by field value inside collection
      1. USjedd.ahyoung
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload