Skillset: Difference between revisions

Revision as of 17:59, 2021 October 27

This page lists skillsets we have used in Projects. Click any skillset for a list of projects that use it.

Error 1054: Unknown column 'ul' in 'where clause'

Function: CargoSQLQuery::run Query: SELECT `mw_cargo__Project__skillSet`.`_value` AS `skillSet` FROM `mw_cargo__Project` LEFT OUTER JOIN `mw_cargo__Project__skillSet` ON ((`mw_cargo__Project`.`_ID`=`mw_cargo__Project__skillSet`.`_rowID`)) WHERE ul GROUP BY `mw_cargo__Project__skillSet`.`_value` ORDER BY `mw_cargo__Project__skillSet`.`_value` LIMIT 1000

|join on=Project.skillSet HOLDS _pageData._pageName

skillSet HOLDS NOT LIKE t, Project._pageName

@@ Line 2: / Line 2: @@
 {{#cargo_query:
-tables=Project, _pageData
+tables=Project
-|join on=Project.skillSet HOLDS _pageData._pageName
 |fields=Project.skillSet
-|where= skillSet HOLDS NOT NULL
+|where=ul
-|group by=skillSet
+|group by=skillSet|format=
-|format=ul
 |limit=1000
 |default=no skillsets found
 }}
+|join on=Project.skillSet HOLDS _pageData._pageName
+skillSet HOLDS NOT LIKE ''
 [[Category:Skillset | * ]]
+t, Project._pageName