DFA-Bestandsordnung: Unterschied zwischen den Versionen
| Zeile 6: | Zeile 6: | ||
ARCHIUM_TABLE_maingroup=mg, | ARCHIUM_TABLE_maingroup=mg, | ||
ARCHIUM_TABLE_maingroup_priority=mgp, | ARCHIUM_TABLE_maingroup_priority=mgp, | ||
| − | ARCHIUM_TABLE_date_of_creation1=d | + | ARCHIUM_TABLE_date_of_creation1=d, |
ARCHIUM_TABLE_access_restriction=r | ARCHIUM_TABLE_access_restriction=r | ||
|join on=s._ID = mg._ID, s._ID = mgp._ID, s._ID = t._ID,s._ID = d._ID,s._ID=r._ID | |join on=s._ID = mg._ID, s._ID = mgp._ID, s._ID = t._ID,s._ID = d._ID,s._ID=r._ID | ||
Version vom 15. Dezember 2019, 15:34 Uhr
Ordnung in Reihenfolge der Klassifikation
Query: SELECT CONCAT( '', "ARCHIUM_PROPERTY_signature" ,'' ) AS "Signatur","ARCHIUM_PROPERTY_title" AS "Titel","ARCHIUM_PROPERTY_maingroup_assignment" AS "Hauptgruppe","ARCHIUM_PROPERTY_dateString" AS "Laufzeiten" FROM "cargo__ARCHIUM_TABLE_signature" "s" LEFT OUTER JOIN "cargo__ARCHIUM_TABLE_title" "t" ON (("s"."_ID"="t"."_ID")) LEFT OUTER JOIN "cargo__ARCHIUM_TABLE_maingroup" "mg" ON (("s"."_ID"="mg"."_ID")) LEFT OUTER JOIN "cargo__ARCHIUM_TABLE_maingroup_priority" "mgp" ON (("s"."_ID"="mgp"."_ID")) LEFT OUTER JOIN "cargo__ARCHIUM_TABLE_date_of_creation1" "d" ON (("s"."_ID"="d"."_ID")) LEFT OUTER JOIN "cargo__ARCHIUM_TABLE_access_restriction" "r" ON (("s"."_ID"="r"."_ID")) WHERE s."_pageName" LIKE 'DFA-%' 0+1 ORDER BY CONCAT( '', "ARCHIUM_PROPERTY_signature" ,'' ),"ARCHIUM_PROPERTY_title","ARCHIUM_PROPERTY_maingroup_assignment","ARCHIUM_PROPERTY_dateString" LIMIT 100 Function: CargoSQLQuery::run Error: 42601 FEHLER: Syntaxfehler bei »0« LINE 1: ...D"="r"."_ID")) WHERE s."_pageName" LIKE 'DFA-%' 0+1 ORDER...
^
<1|AND r."ARCHIUM_PROPERTY_access_restriction" = 'frei'|}}
|format=tree |searchable columns=title |rows per page=500 |limit=500 |order by=mgp."ARCHIUM_PROPERTY_maingroup_priority" ASC,s."ARCHIUM_PROPERTY_ID" ASC }}