Tag: nested-queries

Defining Custom Parameters on Eager-Loaded Elements

craftcms eager-loading nested-queries php

I am trying to complete an eager-loading query that will pull in all the related fields on an Entry, even if they are disabled. I am using this as a reference in the docs: https://craftcms.com/docs/3.x/dev/eager-loading-elements.html#defining-custom-parameters-on-eager-loaded-elements I wrote this: But I keep…

How to find a time between nested Json

json mariadb mysql nested-queries php

I have created a table called ticket_manager with the following structure: Each time when the user based QR Code gets scanned it will add a new row (either when it’s a check-in it will add a new line to “checkIn with “check_in_$count” or a new line to checkOut with “check_out_$co…