One basic and trivial solution could be to have schema like; Date (of type date/string) --> this would store the 'yyyy-mm-dd' format date Tag (of type string) --> the text/tag 'Account' goes into this account-id (of type sint/int) --> account id like '123' goes into this action (of type sting) --> values like 'created'/'updated' goes into this
Then just push your logs into solr. http://wiki.apache.org/solr/UpdateCSV http://wiki.apache.org/solr/UpdateCSV Then to get log activity for account id '123', you could query like: http://localhost:<port>/solr/select/?q=id:123&fq=Tag:Account&fq=Date:[d1 TO d2] then process the results for plotting/reporting OR you could ask for faceting on the 'action' field like; http://localhost:<port>/solr/select/?q=id:123&fq=Tag:Account&fq=Date:[d1 TO d2]&facet=true&facet.field=action This way you have facet count for created/updated/deleted etc. Hope this is what u r looking for. Thanx Pravesh -- View this message in context: http://lucene.472066.n3.nabble.com/need-basic-information-tp4004588p4004637.html Sent from the Solr - User mailing list archive at Nabble.com.