Template:SMART InterdependenciesQuery - Revision history

Bgrenon at 18:58, November 5, 2018

2018-11-05T18:58:26Z

Bgrenon: 1 revision imported

2018-10-24T20:23:31Z

1 revision imported

Bgrenon at 20:17, October 24, 2018

2018-10-24T20:17:54Z

New page

===Interdependencies===
All required, alternate, and optional use cases are listed here, as well as any exceptions.
{|
!All of the following required:
!At least one of the following required:
!Optional
!Exceptions
|-
|{{#cargo_query:
tables=SMART_UseCase__RequiresAll,SMART_UseCase,SMART_Meta
|join on=SMART_UseCase__RequiresAll._rowID=SMART_UseCase._ID,SMART_UseCase__RequiresAll._value=SMART_Meta.ID
|fields=Solution,CONCAT ('[[UseCases/Current/',Offering,'/',SMART_UseCase__RequiresAll._value,'|',SMART_Meta.Title,' (',SMART_Meta.ID,')]]')=List
|where=Offering="{{{Platform}}}" AND SMART_UseCase.ID="{{{UseCase}}}"
|default=None
|format=outline
|outline fields=Solution
|group by=SMART_Meta.ID
}}
|{{#cargo_query:
tables=SMART_UseCase__RequiresOr,SMART_UseCase,SMART_Meta
|join on=SMART_UseCase__RequiresOr._rowID=SMART_UseCase._ID,SMART_UseCase__RequiresOr._value=SMART_Meta.ID
|fields=Solution,CONCAT ('[[UseCases/Current/',Offering,'/',SMART_UseCase__RequiresOr._value,'|',SMART_Meta.Title,' (',SMART_Meta.ID,')]]')=List
|where=Offering="{{{Platform}}}" AND SMART_UseCase.ID="{{{UseCase}}}"
|default=None
|format=outline
|outline fields=Solution
|group by=SMART_Meta.ID
}}
|{{#cargo_query:
tables=SMART_UseCase__Optional,SMART_UseCase,SMART_Meta
|join on=SMART_UseCase__Optional._rowID=SMART_UseCase._ID,SMART_UseCase__Optional._value=SMART_Meta.ID
|fields=Solution,CONCAT ('[[UseCases/Current/',Offering,'/',SMART_UseCase__Optional._value,'|',SMART_Meta.Title,' (',SMART_Meta.ID,')]]')=List
|where=Offering="{{{Platform}}}" AND SMART_UseCase.ID="{{{UseCase}}}"
|default=None
|format=outline
|outline fields=Solution
|group by=SMART_Meta.ID}}
|{{#cargo_query:
tables=SMART_UseCase__Exceptions,SMART_UseCase,SMART_Meta
|join on=SMART_UseCase__Exceptions._rowID=SMART_UseCase._ID,SMART_UseCase__Exceptions._value=SMART_Meta.ID
|fields=Solution,CONCAT ('[[UseCases/Current/',Offering,'/',SMART_UseCase__Exceptions._value,'|',SMART_Meta.Title,' (',SMART_Meta.ID,')]]')=List
|where=Offering="{{{Platform}}}" AND SMART_UseCase.ID="{{{UseCase}}}"
|default=None
|format=outline
|outline fields=Solution
|group by=SMART_Meta.ID
}}
|}

@@ Line 1: / Line 1: @@
-===Interdependencies===
+<h3>Interdependencies for {{{Offering}}} - {{{ID}}}</h3>
-All required, alternate, and optional use cases are listed here, as well as any exceptions.
+Find all required, alternate, and optional use cases for {{#cargo_query:
 {|
 !All of the following required:
@@ Line 11: / Line 15: @@
 |join on=SMART_UseCase__RequiresAll._rowID=SMART_UseCase._ID,SMART_UseCase__RequiresAll._value=SMART_Meta.ID
 |fields=Solution,CONCAT ('[[UseCases/Current/',Offering,'/',SMART_UseCase__RequiresAll._value,'|',SMART_Meta.Title,' (',SMART_Meta.ID,')]]')=List
-|where=Offering="{{{Platform}}}" AND SMART_UseCase.ID="{{{UseCase}}}"
+|where=Offering="{{{Offering}}}" AND SMART_UseCase.ID="{{{ID}}}"AND MintyDocsVersion="Current"
 |default=None
 |format=outline
@@ Line 21: / Line 25: @@
 |join on=SMART_UseCase__RequiresOr._rowID=SMART_UseCase._ID,SMART_UseCase__RequiresOr._value=SMART_Meta.ID
 |fields=Solution,CONCAT ('[[UseCases/Current/',Offering,'/',SMART_UseCase__RequiresOr._value,'|',SMART_Meta.Title,' (',SMART_Meta.ID,')]]')=List
-|where=Offering="{{{Platform}}}" AND SMART_UseCase.ID="{{{UseCase}}}"
+|where=Offering="{{{Offering}}}" AND SMART_UseCase.ID="{{{ID}}}"AND MintyDocsVersion="Current"
 |default=None
 |format=outline
@@ Line 31: / Line 35: @@
 |join on=SMART_UseCase__Optional._rowID=SMART_UseCase._ID,SMART_UseCase__Optional._value=SMART_Meta.ID
 |fields=Solution,CONCAT ('[[UseCases/Current/',Offering,'/',SMART_UseCase__Optional._value,'|',SMART_Meta.Title,' (',SMART_Meta.ID,')]]')=List
-|where=Offering="{{{Platform}}}" AND SMART_UseCase.ID="{{{UseCase}}}"
+|where=Offering="{{{Offering}}}" AND SMART_UseCase.ID="{{{ID}}}"AND MintyDocsVersion="Current"
 |default=None
 |format=outline
@@ Line 40: / Line 44: @@
 |join on=SMART_UseCase__Exceptions._rowID=SMART_UseCase._ID,SMART_UseCase__Exceptions._value=SMART_Meta.ID
 |fields=Solution,CONCAT ('[[UseCases/Current/',Offering,'/',SMART_UseCase__Exceptions._value,'|',SMART_Meta.Title,' (',SMART_Meta.ID,')]]')=List
-|where=Offering="{{{Platform}}}" AND SMART_UseCase.ID="{{{UseCase}}}"
+|where=Offering="{{{Offering}}}" AND SMART_UseCase.ID="{{{ID}}}"AND MintyDocsVersion="Current"
 |default=None
 |format=outline

← Older revision	Revision as of 20:23, October 24, 2018
(No difference)