Difference between revisions of "User: Bgrenon"
From Genesys Documentation
| Line 9: | Line 9: | ||
|format=json | |format=json | ||
}} | }} | ||
| + | |||
| + | ===query=== | ||
| + | <pre> | ||
| + | {{#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=SMART_UseCase.ID="BO03" | ||
| + | |default=None | ||
| + | |group by=SMART_Meta.ID | ||
| + | |format=json | ||
| + | }} | ||
| + | </pre> | ||
==At least one== | ==At least one== | ||
| Line 20: | Line 33: | ||
|format=json | |format=json | ||
}} | }} | ||
| + | |||
| + | ===query=== | ||
| + | <pre> | ||
| + | {{#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=SMART_UseCase.ID="BO06" | ||
| + | |default=None | ||
| + | |group by=SMART_Meta.ID | ||
| + | |format=json | ||
| + | }} | ||
| + | </pre> | ||
==Optional== | ==Optional== | ||
| Line 32: | Line 58: | ||
|format=json | |format=json | ||
}} | }} | ||
| + | |||
| + | ===query=== | ||
| + | <pre> | ||
| + | {{#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=SMART_UseCase.ID="BO06" | ||
| + | |default=None | ||
| + | |default=None | ||
| + | |group by=SMART_Meta.ID | ||
| + | |format=json | ||
| + | }} | ||
| + | </pre> | ||
==exceptions== | ==exceptions== | ||
| Line 43: | Line 83: | ||
|group by=SMART_Meta.ID | |group by=SMART_Meta.ID | ||
}} | }} | ||
| + | |||
| + | ===query=== | ||
| + | <pre> | ||
| + | {{#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=SMART_UseCase.ID="BO06" | ||
| + | |default=None | ||
| + | |format=json | ||
| + | |group by=SMART_Meta.ID | ||
| + | }} | ||
| + | </pre> | ||
Revision as of 15:41, February 5, 2020
All[ | edit source]
query[ | edit source]
{{#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=SMART_UseCase.ID="BO03"
|default=None
|group by=SMART_Meta.ID
|format=json
}}
At least one[ | edit source]
query[ | edit source]
{{#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=SMART_UseCase.ID="BO06"
|default=None
|group by=SMART_Meta.ID
|format=json
}}
Optional[ | edit source]
query[ | edit source]
{{#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=SMART_UseCase.ID="BO06"
|default=None
|default=None
|group by=SMART_Meta.ID
|format=json
}}
exceptions[ | edit source]
query[ | edit source]
{{#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=SMART_UseCase.ID="BO06"
|default=None
|format=json
|group by=SMART_Meta.ID
}}