Search for items by modified date?

Apr 5, 2013 at 5:44 PM
Trying to query a web app or site by modified date.

example:
select * from site
where modified > 01/01/2013

Can this be done?
Apr 17, 2013 at 3:26 PM
Yes you can. You'll need to use the Sharepoint API and query the scope(). Something like this:
<QueryPacket Revision="1000">
<Query>
  <Context>
    <QueryText language="en-US" type="MSSQLFT">Select Size, Rank, Path, Title, Description, Write, Author FROM Scope() WHERE (("SCOPE"='MySearch')) ORDER BY "Write" DESC</QueryText>
  </Context>
  <OrderBy>
      <FieldRef Name="Write" />
  </OrderBy>
  <SupportedFormats Format="urn:Microsoft.Search.Response.Document.Document" />
  <ResultProvider>SharepointSearch</ResultProvider>
  <Range>
    <StartAt>1</StartAt>
    <Count>20</Count>
  </Range>
</Query>
I did run into issues however which I've documented here: http://www.ambretechnology.com/?p=385 Mossman's Query tool was a great help in troubleshooting my issues.