I have several Global Properties that have an embedded ": " (colon+space) within their names. When I create a Session Relevance statement and run it within the Session Relevance debugger they execute fine. The problem I am having is when trying to use the BFExtractToCSV.exe which uses the queriesConfig.yaml file to store Relevance. In YAML the ": " character sequence is treated as a special character. I am not seeing any way to escape this. YAML documentation states to surround it with single or double quotes, and it already is. Below is the relevance statement that works in the debugger.
Example:
(value of results (bes property whose (name of it = “IP Address Registration Address”) , it) | “”) of bes computers whose (exists values whose (it as lowercase = “mca”) of results (bes property “WMU: OU Site” , it))
That did not work. Below is the contents of the queries.Config.yaml file and the output from BFExtractToCSV.exe.
Begin Contents of queries.Config.yaml file ----
Config File uses YAML syntax
Queries in this file can be used called by extractData.exe
MayoAlert_MCA:
relevance: (concatenation “%22: %22” of substrings separated by ": " of it) of (value of results (bes property whose (name of it = “IP Address Registration Address”) , it) | “”) of bes computers whose (exists values whose (it as lowercase = “mca”) of results (bes property “WMU: OU Site” , it))