How to use the API to get a list of publications with conditions set on them.

Question

We are troubleshooting some issues in our 15.1.2 environment and are in need to find a list of publications which have conditions set on them vs. contain content with conditions. Couldn't figure out which field or class to use from the API to achieve this. TIA

Dave De Meyer · Answer

The question is a bit abstract. 
 If a Topic version holds an @ishcondition looking like "COOLING=WATER AND ENGINETYPE=ELECTRIC" 
 
 So COOLING is a condition name, WATER is a condition value. Same for ENGINETYPE and in ELECTRIC. 
 Per Topic, Map, Library Topic the system collects ithe individual conditions. So field FISHCONDITIONS contains two entries: COOLING:WATER and ENGINETYPE:ELECTRIC 
 
 In turn a Publication Version holds a Context. These are condition values that could make ishconditions valid/include or invalid/hide. 
 
 So if FISHCONTEXT holds COOLING=AIR and ENGINETYPE=ELECTRIC, then the above condition will not become valid (as it cannot make the COOLING=WATER part true). 
 
 So trying to map your question to product terminology. 
 
 When referring to " a list of publications which have conditions set on them ".... You are looking for Publication Versions that hold a context that makes ishconditions become true when published. Then Pubblication Version FISHCONTEXT is your target. 
 When referring to " contain content with conditions ".... Does this means Topic, Maps, Library Topics that are used within a Publication Version (or not?) that use a particular boolean logic condition? You can try over FISHCONDITIONS field or try the Search API with the advanced attribute syntax. 
 
 Best wishes, Dave

Tridion Docs Developers > 03 - Developer Forum

How to use the API to get a list of publications with conditions set on them.