Ask Your Question

Query for properties with an active status

asked 2017-01-13 17:22:37 -0500

matthewbschneider gravatar image

updated 2017-01-14 20:05:43 -0500

I'm running a query for active listings, but receiving an error.

Query: (L_Status=Active)

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?

edit retag flag offensive close merge delete

1 Answer

Sort by ยป oldest newest most voted

answered 2017-01-16 18:19:13 -0500

When you query a field with a lookup attached, you use the lookup's value in the search. If you select COMPACT format it returns the field value. If you set format to COMPACT-DECODED, it returns the lookup's LongValue. Both status fields have lookups attached.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-01-13 17:22:37 -0500

Seen: 230 times

Last updated: Jan 16 '17