W&T-Schlagworte: Unterschied zwischen den Versionen
| Zeile 9: | Zeile 9: | ||
|fields=CONCAT( '[[', "ARCHIUM_PROPERTY_signature" ,']]' )=Signatur, | |fields=CONCAT( '[[', "ARCHIUM_PROPERTY_signature" ,']]' )=Signatur, | ||
ARCHIUM_PROPERTY_INDEX_subject=Name, | ARCHIUM_PROPERTY_INDEX_subject=Name, | ||
| − | CONCAT("ARCHIUM_PROPERTY_maingroup_assignment")=Hauptgruppe | + | CONCAT("ARCHIUM_PROPERTY_maingroup_assignment")=Hauptgruppe |
| − | |||
|parent field=Hauptgruppe | |parent field=Hauptgruppe | ||
<!--|where=s."_pageName" LIKE 'W&T-%' {{#ifexpr:{{#expr:{{#UserAccessCheck:{{PAGENAME}}|{{#var:ARCHIUM_VAR_user_whitelist_{{#username:AnonymousNoname}}}}|{{#var:ARCHIUM_VAR_user_blacklist_{{#username:AnonymousNoname}}}}}}+{{#ifsysop:1|0}}+{{#ifeq: {{#cargo_query:tables=ARCHIUM_TABLE_access_restriction|fields=ARCHIUM_PROPERTY_access_restriction|no html|default=|where="_pageName"='W&T'}}|frei|1|0}}}}<1|AND r."ARCHIUM_PROPERTY_access_restriction" = 'frei'|}}--> | <!--|where=s."_pageName" LIKE 'W&T-%' {{#ifexpr:{{#expr:{{#UserAccessCheck:{{PAGENAME}}|{{#var:ARCHIUM_VAR_user_whitelist_{{#username:AnonymousNoname}}}}|{{#var:ARCHIUM_VAR_user_blacklist_{{#username:AnonymousNoname}}}}}}+{{#ifsysop:1|0}}+{{#ifeq: {{#cargo_query:tables=ARCHIUM_TABLE_access_restriction|fields=ARCHIUM_PROPERTY_access_restriction|no html|default=|where="_pageName"='W&T'}}|frei|1|0}}}}<1|AND r."ARCHIUM_PROPERTY_access_restriction" = 'frei'|}}--> | ||
Version vom 28. Februar 2020, 16:05 Uhr
Query: SELECT CONCAT( '', "ARCHIUM_PROPERTY_signature" ,'' ) AS "Signatur","ARCHIUM_PROPERTY_INDEX_subject" AS "Name",CONCAT("ARCHIUM_PROPERTY_maingroup_assignment") AS "Hauptgruppe" FROM "cargo__ARCHIUM_TABLE_signature" "s" LEFT OUTER JOIN "cargo__ARCHIUM_TABLE_INDEX_locationList" "il" ON (("s"."_pageName"="il"."_pageName")) LEFT OUTER JOIN "cargo__ARCHIUM_TABLE_INDEX_nameList" "in" ON (("s"."_pageName"="in"."_pageName")) LEFT OUTER JOIN "cargo__ARCHIUM_TABLE_INDEX_subjectList" "is" ON (("s"."_pageName"="is"."_pageName")) LEFT OUTER JOIN "cargo__ARCHIUM_TABLE_access_restriction" "r" ON (("s"."_pageName"="r"."_pageName")) ORDER BY mgp."ARCHIUM_PROPERTY_maingroup_priority",s."ARCHIUM_PROPERTY_ID" LIMIT 500 Function: CargoSQLQuery::run Error: 42703 ERROR: column "ARCHIUM_PROPERTY_maingroup_assignment" does not exist LINE 1: ..."ARCHIUM_PROPERTY_INDEX_subject" AS "Name",CONCAT("ARCHIUM_P...
^