Search for items by modified date?

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

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

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