Ask Your Question
0

Not getting any new updates

asked 2018-05-14 10:57:37 -0500

sam gravatar image

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

edit retag flag offensive 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 gravatar imagebwolven ( 2018-05-14 12:11:43 -0500 )edit
sam gravatar imagesam ( 2018-05-14 12:38:07 -0500 )edit

1 Answer

Sort by ยป oldest newest most voted
0

answered 2018-05-14 14:03:58 -0500

updated 2018-05-14 14:08:14 -0500

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)

edit flag offensive delete link more

Comments

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

thank you

sam gravatar imagesam ( 2018-05-14 14:19:37 -0500 )edit

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

bwolven gravatar imagebwolven ( 2018-05-14 14:24:43 -0500 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2018-05-14 10:57:37 -0500

Seen: 65 times

Last updated: May 14 '18