Ask Your Question

RETS DMQL to filter by boardId not working

asked 2019-05-23 08:08:27 -0600

I’m trying to download 2 boards (out of 3) within Global MLS, but everything I try doesn’t work.





Do you know what syntax I would need to use to accomplish this?

edit retag flag offensive close merge delete


Need your RETS login URL and account name (NO PASSWORDS) to help.

bwolven gravatar imagebwolven ( 2019-05-23 09:15:30 -0600 )edit
jflaig gravatar imagejflaig ( 2019-05-23 09:16:51 -0600 )edit

Can you give me a better description of what isn't working?
Are you getting errors or not just not getting some of the listings or some other issue?

bwolven gravatar imagebwolven ( 2019-05-23 09:30:43 -0600 )edit

I just want to get listings from boardID 1 and 2, but none of the queries above do that. They just return from 1.

jflaig gravatar imagejflaig ( 2019-05-23 09:32:13 -0600 )edit

1 Answer

Sort by » oldest newest most voted

answered 2019-05-23 10:41:13 -0600

If I use this query: (LO1_board_id=2) I show 438 records with your account.
This should be the correct filter: ((LO1_board_id=|1,2)|(LO1_board_id=.EMPTY.))
But board 2 (SSSAR) does not have any (L_StatusCatID=1) listings at this time.

edit flag offensive delete link more


I don't think that works. I get listings that are in BoardID 4, I think. We have a seperate process which is meant to only include listings from board ID 4 and it uses this query:


The filter you gave me returns listings in this query.

jflaig gravatar imagejflaig ( 2019-05-23 10:50:26 -0600 )edit

Looking at our logs, every request that includes boards 1 and 2 in the past 24 hours are only pulling Active (L_StatusCatID=|1)
Here's an example:

bwolven gravatar imagebwolven ( 2019-05-23 11:13:13 -0600 )edit

The status is not the concern. I'm not sure what relevance that has.

jflaig gravatar imagejflaig ( 2019-05-23 11:14:43 -0600 )edit

board_id=2 does not have any Active status listings.

bwolven gravatar imagebwolven ( 2019-05-23 11:15:56 -0600 )edit

Well that explains it then. Though I don't understand how an entire board within GlobalMLS could have no listings unless they were merged into another board...

jflaig gravatar imagejflaig ( 2019-05-23 11:17:20 -0600 )edit

I don't know why it is that way.
You would need to ask the MLS about that.
I just support the RETS related issues and in this case is is working correctly with the data it has.

bwolven gravatar imagebwolven ( 2019-05-23 11:31:16 -0600 )edit

ok, will do

jflaig gravatar imagejflaig ( 2019-05-23 11:32:44 -0600 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-05-23 08:08:27 -0600

Seen: 536 times

Last updated: May 23 '19