I dont have access to the Postgres database so I have to use AST Query language and am struggling with how to get trusted facts pp_project (puppet_product) and pp_department (product) given certain values of trusteds fact pp_role (avrt) and pp_apptier (qa).
"pp_role" : "avrt",
"pp_apptier" : "qa",
"pp_project" : "puppet_product",
"pp_department" : "product"
["from", "facts",
["extract", ["value.extensions.pp_project"],
["subquery", "fact_contents",
["and",
["=", "path", ["trusted", "extensions", "pp_role"]],
["=", "value", "product"]
]
]
["subquery", "fact_contents",
["and",
["=", "path", ["trusted", "extensions", "pp_apptier"]],
["=", "value", "qa"]
]
]
]