Difference between revisions of "User: Bgrenon"

From Genesys Documentation
Jump to: navigation, search
Line 1: Line 1:
 +
==All==
 
{{#cargo_query:
 
{{#cargo_query:
 
tables=SMART_UseCase__RequiresAll,SMART_UseCase,SMART_Meta
 
tables=SMART_UseCase__RequiresAll,SMART_UseCase,SMART_Meta
Line 4: Line 5:
 
|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"
 
|where=SMART_Meta.ID="BO02"
 +
|default=None
 +
|group by=SMART_Meta.ID
 +
|format=json
 +
}}
 +
 +
==At least one==
 +
{{#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._pageName="{{FULLPAGENAME}}"
 +
|default=None
 +
|default=None
 +
|group by=SMART_Meta.ID
 +
|format=json
 +
}}
 +
 +
==Optional==
 +
{{#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._pageName="{{FULLPAGENAME}}"
 +
|default=None
 
|default=None
 
|default=None
 
|group by=SMART_Meta.ID
 
|group by=SMART_Meta.ID

Revision as of 18:55, February 4, 2020

All[ | edit source]

View JSON

At least one[ | edit source]

View JSON

Optional[ | edit source]

View JSON

exceptions[ | edit source]

None

Retrieved from "https://all.docs.genesys.com/User:Bgrenon (2025-06-19 10:00:50)"