Sugar Professional 7.6.0
So there are a number of resources that talk about how to check if a field equals, contains, etc. values. None of those resources talk about how to check if a drop down has a value.
The two filters that I cannot seem to get to work are:
{ "filter":[ {//Territory is a dropdown that contains a large number of values. I just want to make sure to get the ones where the value is set "territory_c":{ "$not_null" } } ] } { "filter":[ { //There are a number of account types, I only want one account type. "account_type":{ "$in":{"hospital"} } } ] }