Difference between revisions of "User: Bgrenon"
From Genesys Documentation
| Line 3: | Line 3: | ||
|join on=SMART_UseCase__RequiresAll._rowID=SMART_UseCase._ID,SMART_UseCase__RequiresAll._value=SMART_Meta.ID | |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 | |fields=Solution,CONCAT ('[[UseCases/Current/',Offering,'/',SMART_UseCase__RequiresAll._value,'|',SMART_Meta.Title,' (',SMART_Meta.ID,')]]')=List | ||
| + | |where=SMART_Meta.ID="BO02" | ||
| + | |default=None | ||
| + | |group by=SMART_Meta.ID | ||
| + | }} | ||
| + | |||
| + | ==exceptions== | ||
| + | {{#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._pageName="{{FULLPAGENAME}}" | ||
| + | |default=None | ||
|where=SMART_Meta.ID="BO02" | |where=SMART_Meta.ID="BO02" | ||
|default=None | |default=None | ||
|group by=SMART_Meta.ID | |group by=SMART_Meta.ID | ||
}} | }} | ||