First time here? Check out the FAQ!
0

RETS DMQL to filter by boardId not working

  • retag add tags

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

((LO1_board_id=1)|(LO1_board_id=2)|(LO1_board_id=.EMPTY.))

((LO1_board_id=|1,2)|(LO1_board_id=.EMPTY.))

(LO1_board_id=|1,2)

(LO1_board_id=1,2)

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

jflaig's avatar
jflaig
asked 2019-05-23 08:08:27 -0500
edit flag offensive 0 remove flag close merge delete

Comments

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

bwolven's avatar bwolven (2019-05-23 09:15:30 -0500) edit
jflaig's avatar jflaig (2019-05-23 09:16:51 -0500) 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's avatar bwolven (2019-05-23 09:30:43 -0500) 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's avatar jflaig (2019-05-23 09:32:13 -0500) edit
add a comment see more comments

1 Answer

0

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.

bwolven's avatar
bwolven
answered 2019-05-23 10:41:13 -0500
edit flag offensive 0 remove flag delete link

Comments

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:

(L_ListingID=1%2b),(L_StatusCatID=|1),(L_Keyword1=|0,1),(L_IdxInclude=|0,2),((LO1_board_id=4)|(LO1_board_id=.EMPTY.))

The filter you gave me returns listings in this query.

jflaig's avatar jflaig (2019-05-23 10:50:26 -0500) 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:
(L_StatusCatID=|1),(L_Keyword1=|0,1),(L_IdxInclude=|0,2),((LO1_board_id=|1,2)|(LO1_board_id=.EMPTY.))

bwolven's avatar bwolven (2019-05-23 11:13:13 -0500) edit

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

jflaig's avatar jflaig (2019-05-23 11:14:43 -0500) edit

board_id=2 does not have any Active status listings.

bwolven's avatar bwolven (2019-05-23 11:15:56 -0500) 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's avatar jflaig (2019-05-23 11:17:20 -0500) 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's avatar bwolven (2019-05-23 11:31:16 -0500) edit

ok, will do

jflaig's avatar jflaig (2019-05-23 11:32:44 -0500) edit
add a comment see more comments

Your Answer

Login/Signup to Answer