Difference between revisions of "Template: ReverseDependenciesQuery"
From Genesys Documentation
(Tag: Undo) |
|||
| Line 5: | Line 5: | ||
|join on=SMART_UseCase.ID=SMART_Meta.ID | |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) | |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=" | + | |where=SMART_UseCase.ID="{{{ID|}}}" AND Offering="{{{Offering|}}}" AND SMART_UseCase._pageNamespace!="620" |
|delimiter= | |delimiter= | ||
}} | }} | ||
| Line 12: | Line 12: | ||
|join on=SMART_UseCase.ID=SMART_Meta.ID | |join on=SMART_UseCase.ID=SMART_Meta.ID | ||
|fields=CONCAT(SMART_Meta.Title,' (',SMART_Meta.ID,')') | |fields=CONCAT(SMART_Meta.Title,' (',SMART_Meta.ID,')') | ||
| − | |where=SMART_UseCase.ID="{{{ID|}}}" AND Offering=" | + | |where=SMART_UseCase.ID="{{{ID|}}}" AND Offering="{{{Offering|}}}" AND SMART_UseCase._pageNamespace!="620" |
|delimiter= | |delimiter= | ||
}}</h2> | }}</h2> | ||
| Line 19: | Line 19: | ||
|join on=SMART_UseCase.ID=SMART_Meta.ID | |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 | |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=" | + | |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. | |default=Not mandatory for any use case. | ||
|group by=SMART_Meta.ID | |group by=SMART_Meta.ID | ||
| Line 27: | Line 27: | ||
|join on=SMART_UseCase.ID=SMART_Meta.ID | |join on=SMART_UseCase.ID=SMART_Meta.ID | ||
|fields=CONCAT(SMART_Meta.Title,' (',SMART_Meta.ID,')') | |fields=CONCAT(SMART_Meta.Title,' (',SMART_Meta.ID,')') | ||
| − | |where=SMART_UseCase.ID="{{{ID|}}}" AND Offering=" | + | |where=SMART_UseCase.ID="{{{ID|}}}" AND Offering="{{{Offering|}}}" AND SMART_UseCase._pageNamespace!="620" |
|delimiter= | |delimiter= | ||
}}</h2> | }}</h2> | ||
| Line 34: | Line 34: | ||
|join on=SMART_UseCase.ID=SMART_Meta.ID | |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 | |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=" | + | |where=(SMART_UseCase.RequiresOr HOLDS '{{{ID}}}' OR SMART_UseCase.Optional HOLDS '{{{ID}}}') AND Offering="{{{Offering|}}}" AND SMART_UseCase._pageNamespace!="620" |
|default=None. | |default=None. | ||
|group by=SMART_Meta.ID | |group by=SMART_Meta.ID | ||
| Line 45: | Line 45: | ||
|join on=SMART_UseCase.ID=SMART_Meta.ID | |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 | |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=" | + | |where=SMART_UseCase.Optional HOLDS '{{{ID}}}' AND Offering="{{{Offering|}}}" AND SMART_UseCase._pageNamespace!="620" |
|default=Not optional for any use case. | |default=Not optional for any use case. | ||
|group by=SMART_Meta.ID | |group by=SMART_Meta.ID | ||
Latest revision as of 16:10, August 17, 2020
No results
Use cases that augment the value on top of selected No results
Not mandatory for any use case.