{% fetchxml tour_dates_query %} <fetch version="1.0" mapping="logical" no-lock="false"> <entity name="musdyn_tourdate"> <attribute name="musdyn_name"/> <order attribute="musdyn_startdateandtime" descending="false"/> <filter type="and"><condition attribute="statecode" operator="eq" value="0"/></filter> <attribute name="musdyn_venue"/> <attribute name="musdyn_tour"/> <attribute name="musdyn_ticketavailability"/> <attribute name="statuscode"/> <attribute name="musdyn_startdateandtime"/> <attribute name="musdyn_tourdateid"/> <attribute name="musdyn_endtimeanddate"/> <attribute name="musdyn_alldayevent"/> <attribute name="musdyn_bookinglink"/> <link-entity name="musdyn_tour" from="musdyn_tourid" to="musdyn_tour" link-type="outer" alias="tour" visible="false"> <attribute name="musdyn_description"/> <attribute name="musdyn_mainartist"/> <attribute name="musdyn_artwork_url"/> </link-entity> </entity> </fetch> {% endfetchxml %} {% if tour_dates_query.results.entities.size > 0 %} [ {% for result in tour_dates_query.results.entities %} { "id": "{{ result.musdyn_tourdateid }}", "title": "{{ result.musdyn_name }}", "start": "{{ result.musdyn_startdateandtime | date_to_iso8601 }}", "end": "{{ result.musdyn_endtimeanddate | date_to_iso8601 }}", "extendedProps": { "venue1": "{{ result.musdyn_name }}", "venue2": "{{ result.musdyn_venue }}", "artist": "{{ result['tour.musdyn_mainartist'].name }}", "tour": "{{ result.musdyn_tour.name }}", "ticket_availability": "{{ result.musdyn_ticketavailability.label }}", "purchase_url": "{{ result.musdyn_bookinglink }}", "description": "{{ result['tour.musdyn_description'] | escape }}", "artwork": "{{ result['tour.musdyn_artwork_url'] | url_encode }}", "tour_id": "{{ result.musdyn_tour.id }}", }, }{% unless forloop.last %},{% endunless %} {% endfor %} ] {% endif %}