Ask Your Question

Glen Mann's profile - activity

2017-08-25 14:54:33 -0500 received badge  Famous Question (source)
2017-03-23 11:10:32 -0500 received badge  Notable Question (source)
2016-11-17 11:47:44 -0500 received badge  Popular Question (source)
2016-11-16 15:29:15 -0500 commented answer DateTime=YYYY-MM-DDTHH:MM:SS+ Syntax Returns No Results

Yes I normally use the COMPACT format. I asked our local MLS/RETS admin why I was given a version 1.5 login URL rather than 1.7.2 or 1.8, but do not yet have an answer. Do you know if RAYAC supports 1.7.2 and/or 1.8? Simple URLs seem to work in any version. Thanks!

2016-11-16 14:34:25 -0500 received badge  Scholar (source)
2016-11-16 14:33:55 -0500 answered a question DateTime=YYYY-MM-DDTHH:MM:SS+ Syntax Returns No Results

You are correct. I somehow did not think about that, so
  (L_UpdateDate=2016-11-16T00:00:00%2b)
works as expected.

Thanks for the speedy answer to a defacto silly question.

Concerning PHRETS, I tried it and found the lack of documentation, hidden functionality, complexity, and the numerous other included components unsuitable for me. The '+' issue aside, it's been quicker for me to use straight PHP and curl, and the CLI with curl for certain scheduled events. After all, the entire RETS universe seems to revolve around correctly formulating URLs and parsing the results.

I'm about to "Answer my own question..." since the comment length is limited.

2016-11-16 07:22:49 -0500 received badge  Editor (source)
2016-11-16 07:04:24 -0500 asked a question DateTime=YYYY-MM-DDTHH:MM:SS+ Syntax Returns No Results

In my query, I am having trouble using the RETS DMQL2 syntax for date comparisons. I'm using rets/1.5. I am properly authenticated and other queries work fine.

http://rayac.rets.fnismls.com/rets/fnisrets.aspx/RAYAC/Search?rets-version=rets/1.5&SearchType=Property&Class=RF_1&Count=0&Query=(L_UpdateDate=2016-11-15T00:00:00+)&QueryType=DMQL2

So This query returns no results:
  Query=(L_UpdateDate=2016-11-15T00:00:00+)

but this query returns one record (an exact match):
  Query=(L_UpdateDate=2016-11-15T00:24:00)

To make sure I understand the datetime field, I've tried stuff like:
  Query=(L_UpdateDate=2016-11-01T00:00:00+)
with no results. There should be many results, as I have verified using other methods

Any ideas? Does Paragon support the DQML2 '+' syntax for dates and datetimes?

Thanks

--Glen Mann