Ask Your Question
0

RETS DMQL to filter by boardId not working

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

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?

edit retag flag offensive close merge delete

Comments

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

bwolven gravatar imagebwolven ( 2019-05-23 09:15:30 -0500 )edit
jflaig gravatar imagejflaig ( 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 gravatar imagebwolven ( 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 gravatar imagejflaig ( 2019-05-23 09:32:13 -0500 )edit

1 Answer

Sort by » oldest newest most voted
0

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

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

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 gravatar imagejflaig ( 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 gravatar imagebwolven ( 2019-05-23 11:13:13 -0500 )edit

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

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

board_id=2 does not have any Active status listings.

bwolven gravatar imagebwolven ( 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 gravatar imagejflaig ( 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 gravatar imagebwolven ( 2019-05-23 11:31:16 -0500 )edit

ok, will do

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

Question Tools

1 follower

Stats

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

Seen: 89 times

Last updated: May 23