First time here? Check out the FAQ!
0

Not getting any new updates

  • retag add tags

I have this query: Query: (L_UpdateDate=2018-04-11T00:00:00+),(L_Status=|1_0,1_4),(L_City=|BasinCity, BentnCity, Burbank, Connell, Eltopia, Finley, Kennewick, Kiona, Mesa, Pasco, Plymouth, Prosser, Richland, Wallula, WestRichld)

and i am not getting any results back, I know there is at least 1 new listings, anything wrong with my query? username: samgpone

thank you

sam's avatar
sam
asked 2018-05-14 10:57:37 -0500
edit flag offensive 0 remove flag close merge delete

Comments

What RETS URL and account name. (NO PASSWORDS PLEASE). Always need to provide this because many vendors pull from multiple MLS systems.

bwolven's avatar bwolven (2018-05-14 12:11:43 -0500) edit
sam's avatar sam (2018-05-14 12:38:07 -0500) edit
add a comment see more comments

1 Answer

0

When I used your query as you show I get no records returned too. But if remove the extra spaces in your query, I get properties returned. Must be treating them as values starting with a space.

(L_UpdateDate=2018-04-11T00:00:00+),(L_Status=|1_0,1_4),(L_City=|BasinCity,BentnCity,Burbank,Connell,Eltopia,Finley,Kennewick,Kiona,Mesa,Pasco,Plymouth,Prosser,Richland,Wallula,WestRichld)

bwolven's avatar
bwolven
answered 2018-05-14 14:03:58 -0500, updated 2018-05-14 14:08:14 -0500
edit flag offensive 0 remove flag delete link

Comments

OK so make sure there are no empty spaces between the values.

thank you

sam's avatar sam (2018-05-14 14:19:37 -0500) edit

Yes. I would remove all leading and trailing spaces from the values.

bwolven's avatar bwolven (2018-05-14 14:24:43 -0500) edit
add a comment see more comments

Your Answer

Login/Signup to Answer