Query for properties with an active status
I'm running a query for active listings, but receiving an error.
ReplyCode 20206 (INVALID_QUERY_SYNTAX); ReplyText: An invalid value was given for a calculated field [DMQLtoSQL.getSubquery: Calculated field query value cannot be parsed into constituant parts: L_Status]. Error in the application.
I tried (L_StatusCatID=Active) and also received an error:
ReplyCode 20206 (INVALID_QUERY_SYNTAX); ReplyText: Illegal number in range for field [L_StatusCatID] Error in the application.
I noticed if I use a number for L_StatusCatID, then it works. So the query value type is different than its return type? Is there a way that I can query all the query & return values for a field like status?