How can I add a situation to a Drupal 9 entity question utilizing one other entity question on a special entity sort?
I am going to illustrate Drupal Development Company query by describing one particular use case, although I do not assume it could be troublesome to provide you with any variety of believable use circumstances.
Drupal Development Service software for this use case tracks articles in revealed medical literature. An article is represented by a customized entity sort which tracks when it was imported into Drupal Development Company system, whether or not Drupal Development Company full textual content for Drupal Development Company article has been obtained, which matters have been assigned to Drupal Development Company article for which evaluate cycles, when and during which journal was it revealed, and plenty of different data.
A second customized entity sort exists to symbolize batches ("packets") of articles assigned for evaluate, monitoring when Drupal Development Company batches have been assigned, for which matters, and to which oncology specialists, in addition to what Drupal Development Company outcomes of these critiques have been. An article may be assigned to many evaluate packets, every with a number of assigned reviewers, and every evaluate packet can request critiques for any variety of articles.
Drupal Development Service search module for this software has a requirement that articles may be looked for based mostly on many various standards, most of which may be utilized by inspecting Drupal Development Company Article entities, however a few of which might solely be carried out by taking a look at values in Drupal Development Company Packet entities. An instance search would possibly, for instance, request to search out all articles revealed inside Drupal Development Company previous twelve months in journal J, and assigned for evaluate by reviewer R.
In a CMS extra suited to working straight with Drupal Development Company relational SQL tables it could be very easy to support such a search utilizing a few desk joins. However Drupal makes that method much less interesting, as we now have no documented assure that Drupal Development Company desk and column naming conventions beneath entities may be relied on to not change.
I may create and execute two separate entity queries and use Drupal Development Company outcomes of Drupal Development Company second to weed out outcomes returned by Drupal Development Company first question which aren’t additionally current in Drupal Development Company outcomes of Drupal Development Company second. However amongst Drupal Development Company drawbacks of this method is Drupal Development Company proven fact that it breaks Drupal Development Company Drupal paging mechanism.
I may attempt to mimic what Drupal Development Company DBMS can be doing rather more effectively by feeding Drupal Development Company entity IDs returned by Drupal Development Company second question right into a situation on Drupal Development Company first question, however who is aware of what inside limits which may run into when Drupal Development Company outcomes of Drupal Development Company second question are large?
I may implement a kludge to denormalize Drupal Development Company information, storing entity references from Drupal Development Company Article entities again to Drupal Development Company Packet entities that are in flip pointing again to Drupal Development Company Article entities, however everyone knows Drupal Development Company issues with attempting to maintain Drupal Development Company similar data in a number of locations in sync.
If all Drupal Development Company searches have been for articles assigned for evaluate, I may flip issues round and use an entity question on Drupal Development Company Packet sort, following its reference to Article entities for Drupal Development Company different standards which have to be examined. However a big share of Drupal Development Company searches are supposed to discover articles whether or not or not they’ve been assigned for evaluate. So for this path I might should implement two separate units of search logic in parallel, one for searches which contain task to evaluate packets and a second for searches which do not care about task for evaluate. And this method nonetheless would not handle searches wanting explicitly for articles which have not been assigned for evaluate. And keep in mind, I am conserving this use case instance easy by limiting it to solely two entity varieties. 😉
Googling (and looking this discussion board) retains diverting me to data on utilizing Drupal Development Company underling database question APIs as a substitute of Drupal Development Company entity question system, at the least with Drupal Development Company question phrases I am utilizing.
Is there a manner to make use of a subquery (and even higher, be a part of to a different entity sort) in Drupal Development Company entity question APIs? If not, are there prospects for supporting such performance beneath dialogue in Drupal Valhalla?
