Difference between revisions of "TestPage"
From MGH Learn Pathology
| Line 7: | Line 7: | ||
| − | {{#cargo_query:tables=ServiceRequest|fields=_pageName,occurrenceDateTime|where=code='apdidactic' AND orderDetail HOLDS 'order' AND occurenceDateTime > | + | {{#cargo_query:tables=ServiceRequest|fields=_pageName,occurrenceDateTime|where=code='apdidactic' AND orderDetail HOLDS 'order' AND occurenceDateTime > {{#timel:Y-m-d|now}}|format=ul}} |
Revision as of 21:44, July 23, 2022
=
{{#timel
- Y|',ServiceRequest.occurrenceDateTime,'}} 2022-07-22 12:00:00
2022
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?
Query: SELECT `_pageName` AS `_pageName`,`occurrenceDateTime` AS `occurrenceDateTime`,`occurrenceDateTime__precision` AS `occurrenceDateTime__precision` FROM `cargo__ServiceRequest` WHERE code='apdidactic' AND `cargo__ServiceRequest`.`_ID` IN (SELECT `_rowID` FROM `cargo__ServiceRequest__orderDetail` WHERE `_value`= 'order') AND occurenceDateTime > 2026-02-02 ORDER BY `_pageName`,`occurrenceDateTime` LIMIT 100000 Function: CargoSQLQuery::run Error: 1054 Unknown column 'occurenceDateTime' in 'where clause' (172.27.81.126:30004)
