Template:ReverseDependenciesQuery - Revision history

Bgrenon: Undo revision 64074 by Bgrenon (talk)

2020-08-17T16:10:47Z

Undo revision 64074 by Bgrenon (talk)

Bgrenon at 16:06, August 17, 2020

2020-08-17T16:06:12Z

Bgrenon: Created page with "
{{#cargo_query:tables=SMART_UseCase,SMART_Meta |join on=SMART_UseCase.I..."

2020-02-25T16:18:12Z

Created page with "<div style="color: black; background-color: #f9f9f9; border: 1px solid #ddd; padding: 1em;">{{#cargo_query:tables=SMART_UseCase,SMART_Meta |join on=SMART_UseCase.I..."

New page

<div style="color: black;
background-color: #f9f9f9;
border: 1px solid #ddd;
padding: 1em;">{{#cargo_query:tables=SMART_UseCase,SMART_Meta
|join on=SMART_UseCase.ID=SMART_Meta.ID
|fields=CONCAT('<b>Selected use case</b>: [[',SMART_UseCase._pageName,'|',SMART_Meta.Title,' (',SMART_Meta.ID,')]]<br/><b>Offering</b>: {{{Offering|}}}<br/><b>Maturity level</b>: ',MaturityLevel)
|where=SMART_UseCase.ID="{{{ID|}}}" AND Offering="{{{Offering|}}}" AND SMART_UseCase._pageNamespace!="620"
|delimiter=
}}
</div>
<h2>Use cases that augment the value on top of selected {{#cargo_query:tables=SMART_UseCase,SMART_Meta
|join on=SMART_UseCase.ID=SMART_Meta.ID
|fields=CONCAT(SMART_Meta.Title,' (',SMART_Meta.ID,')')
|where=SMART_UseCase.ID="{{{ID|}}}" AND Offering="{{{Offering|}}}" AND SMART_UseCase._pageNamespace!="620"
|delimiter=
}}</h2>
{{#cargo_query:
tables=SMART_UseCase,SMART_Meta
|join on=SMART_UseCase.ID=SMART_Meta.ID
|fields=CONCAT('[[',SMART_UseCase._pageName,'|',SMART_Meta.Title,' (',SMART_Meta.ID,')]]')=Value augmenting use cases,MaturityLevel=Maturity,Offering
|where=(SMART_UseCase.RequiresOr HOLDS '{{{ID}}}' OR SMART_UseCase.Optional HOLDS '{{{ID}}}' OR SMART_UseCase.RequiresAll HOLDS '{{{ID}}}') AND Offering="{{{Offering|}}}" AND SMART_UseCase._pageNamespace!="620"
|default=Not mandatory for any use case.
|group by=SMART_Meta.ID
}}


__TOC__

@@ Line 5: / Line 5: @@
 |join on=SMART_UseCase.ID=SMART_Meta.ID
 |fields=CONCAT('<b>Selected use case</b>: [[',SMART_UseCase._pageName,'|',SMART_Meta.Title,' (',SMART_Meta.ID,')]]<br/><b>Offering</b>: {{{Offering|}}}<br/><b>Maturity level</b>: ',MaturityLevel)
-|where=SMART_UseCase.ID="{{{ID|}}}" AND Offering="{{UseCasesPlatformsMap|{{{Offering|}}} }}" AND SMART_UseCase._pageNamespace!="620"
+|where=SMART_UseCase.ID="{{{ID|}}}" AND Offering="{{{Offering|}}}" AND SMART_UseCase._pageNamespace!="620"
 |delimiter=
 }}
@@ Line 12: / Line 12: @@
 |join on=SMART_UseCase.ID=SMART_Meta.ID
 |fields=CONCAT(SMART_Meta.Title,' (',SMART_Meta.ID,')')
-|where=SMART_UseCase.ID="{{{ID|}}}" AND Offering="{{UseCasesPlatformsMap|{{{Offering|}}} }}" AND SMART_UseCase._pageNamespace!="620"
+|where=SMART_UseCase.ID="{{{ID|}}}" AND Offering="{{{Offering|}}}" AND SMART_UseCase._pageNamespace!="620"
 |delimiter=
 }}</h2>
@@ Line 19: / Line 19: @@
 |join on=SMART_UseCase.ID=SMART_Meta.ID
 |fields=CONCAT('[[',SMART_UseCase._pageName,'|',SMART_Meta.Title,' (',SMART_Meta.ID,')]]')=Value augmenting use cases,MaturityLevel=Maturity,Offering
-|where=(SMART_UseCase.RequiresOr HOLDS '{{{ID}}}' OR SMART_UseCase.Optional HOLDS '{{{ID}}}' OR SMART_UseCase.RequiresAll HOLDS '{{{ID}}}') AND Offering="{{UseCasesPlatformsMap|{{{Offering|}}} }}" AND SMART_UseCase._pageNamespace!="620"
+|where=(SMART_UseCase.RequiresOr HOLDS '{{{ID}}}' OR SMART_UseCase.Optional HOLDS '{{{ID}}}' OR SMART_UseCase.RequiresAll HOLDS '{{{ID}}}') AND Offering="{{{Offering|}}}" AND SMART_UseCase._pageNamespace!="620"
 |default=Not mandatory for any use case.
 |group by=SMART_Meta.ID
@@ Line 27: / Line 27: @@
 |join on=SMART_UseCase.ID=SMART_Meta.ID
 |fields=CONCAT(SMART_Meta.Title,' (',SMART_Meta.ID,')')
-|where=SMART_UseCase.ID="{{{ID|}}}" AND Offering="{{UseCasesPlatformsMap|{{{Offering|}}} }}" AND SMART_UseCase._pageNamespace!="620"
+|where=SMART_UseCase.ID="{{{ID|}}}" AND Offering="{{{Offering|}}}" AND SMART_UseCase._pageNamespace!="620"
 |delimiter=
 }}</h2>
@@ Line 34: / Line 34: @@
 |join on=SMART_UseCase.ID=SMART_Meta.ID
 |fields=CONCAT('[[',SMART_UseCase._pageName,'|',SMART_Meta.Title,' (',SMART_Meta.ID,')]]')=Optimizing use cases,MaturityLevel=Maturity,Offering
-|where=(SMART_UseCase.RequiresOr HOLDS '{{{ID}}}' OR SMART_UseCase.Optional HOLDS '{{{ID}}}') AND Offering="{{UseCasesPlatformsMap|{{{Offering|}}} }}" AND SMART_UseCase._pageNamespace!="620"
+|where=(SMART_UseCase.RequiresOr HOLDS '{{{ID}}}' OR SMART_UseCase.Optional HOLDS '{{{ID}}}') AND Offering="{{{Offering|}}}" AND SMART_UseCase._pageNamespace!="620"
 |default=None.
 |group by=SMART_Meta.ID
@@ Line 45: / Line 45: @@
 |join on=SMART_UseCase.ID=SMART_Meta.ID
 |fields=CONCAT('{{{ID}}}')=Selected,CONCAT('IS OPTIONALLY used by')=Relation,CONCAT('[[',SMART_UseCase._pageName,'|',SMART_Meta.Title,' (',SMART_Meta.ID,')]]')=To,MaturityLevel=Maturity,Offering
-|where=SMART_UseCase.Optional HOLDS '{{{ID}}}' AND Offering="{{UseCasesPlatformsMap|{{{Offering|}}} }}" AND SMART_UseCase._pageNamespace!="620"
+|where=SMART_UseCase.Optional HOLDS '{{{ID}}}' AND Offering="{{{Offering|}}}" AND SMART_UseCase._pageNamespace!="620"
 |default=Not optional for any use case.
 |group by=SMART_Meta.ID

Template:ReverseDependenciesQuery - Revision history

Bgrenon: Undo revision 64074 by Bgrenon (talk)

Bgrenon at 16:06, August 17, 2020

Bgrenon: Created page with "{{#cargo_query:tables=SMART_UseCase,SMART_Meta |join on=SMART_UseCase.I..."

Bgrenon: Created page with "
{{#cargo_query:tables=SMART_UseCase,SMART_Meta |join on=SMART_UseCase.I..."