Ask Your Question

Revision history [back]

DateTime=YYYY-MM-DDTHH:MM:SS+ Syntax Returns No Results

In my query, I am having trouble using the RETS DMQL2 syntax for data comparisons. I'm using rets/1.5. I am prpoerly 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

DateTime=YYYY-MM-DDTHH:MM:SS+ Syntax Returns No Results

In my query, I am having trouble using the RETS DMQL2 syntax for data date comparisons. I'm using rets/1.5. I am prpoerly 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 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