Quantcast

Data Changes Logging

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Data Changes Logging

Preeti Bhat
Hi All,

We got a peculiar requirement from client, not sure whether the SOLR supports it or not. We would like to have alerts in place if we have the changes on the particular column for more than specific threshold on said day.
For example: Say, we have column say "Name" on which we have say around 30% changes we would like an alert. I am not sure whether we have some logging mechanism to get this done. Any ideas would be appreciated.


Thanks and Regards,
Preeti



NOTICE TO RECIPIENTS: This communication may contain confidential and/or privileged information. If you are not the intended recipient (or have received this communication in error) please notify the sender and [hidden email] immediately, and destroy this communication. Any unauthorized copying, disclosure or distribution of the material in this communication is strictly forbidden. Any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company. Finally, the recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email.


Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Data Changes Logging

Rick Leir-2
Preeti,
Suppose you have a field named 'modifiedDate' and you update it when you change the 'column' (i assume you mean some field in your document). Then you need to decide how often to check for alerts. When you check for an alert you would do a select with a bit of date math to see how many of your documents have a recent modifiedDate. I am leaving out the details.
Cheers -- Rick

On April 21, 2017 12:28:21 AM EDT, Preeti Bhat <[hidden email]> wrote:

>Hi All,
>
>We got a peculiar requirement from client, not sure whether the SOLR
>supports it or not. We would like to have alerts in place if we have
>the changes on the particular column for more than specific threshold
>on said day.
>For example: Say, we have column say "Name" on which we have say around
>30% changes we would like an alert. I am not sure whether we have some
>logging mechanism to get this done. Any ideas would be appreciated.
>
>
>Thanks and Regards,
>Preeti
>
>
>
>NOTICE TO RECIPIENTS: This communication may contain confidential
>and/or privileged information. If you are not the intended recipient
>(or have received this communication in error) please notify the sender
>and [hidden email] immediately, and destroy this
>communication. Any unauthorized copying, disclosure or distribution of
>the material in this communication is strictly forbidden. Any views or
>opinions presented in this email are solely those of the author and do
>not necessarily represent those of the company. Finally, the recipient
>should check this email and any attachments for the presence of
>viruses. The company accepts no liability for any damage caused by any
>virus transmitted by this email.

--
Sorry for being brief. Alternate email is rickleir at yahoo dot com
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Data Changes Logging

Walter Underwood
Do a range search on that field with the desired date range. Request rows=0. Compare the numFound to the total docs.

wunder
Walter Underwood
[hidden email]
http://observer.wunderwood.org/  (my blog)


> On Apr 22, 2017, at 8:40 AM, Rick Leir <[hidden email]> wrote:
>
> Preeti,
> Suppose you have a field named 'modifiedDate' and you update it when you change the 'column' (i assume you mean some field in your document). Then you need to decide how often to check for alerts. When you check for an alert you would do a select with a bit of date math to see how many of your documents have a recent modifiedDate. I am leaving out the details.
> Cheers -- Rick
>
> On April 21, 2017 12:28:21 AM EDT, Preeti Bhat <[hidden email]> wrote:
>> Hi All,
>>
>> We got a peculiar requirement from client, not sure whether the SOLR
>> supports it or not. We would like to have alerts in place if we have
>> the changes on the particular column for more than specific threshold
>> on said day.
>> For example: Say, we have column say "Name" on which we have say around
>> 30% changes we would like an alert. I am not sure whether we have some
>> logging mechanism to get this done. Any ideas would be appreciated.
>>
>>
>> Thanks and Regards,
>> Preeti
>>
>>
>>
>> NOTICE TO RECIPIENTS: This communication may contain confidential
>> and/or privileged information. If you are not the intended recipient
>> (or have received this communication in error) please notify the sender
>> and [hidden email] immediately, and destroy this
>> communication. Any unauthorized copying, disclosure or distribution of
>> the material in this communication is strictly forbidden. Any views or
>> opinions presented in this email are solely those of the author and do
>> not necessarily represent those of the company. Finally, the recipient
>> should check this email and any attachments for the presence of
>> viruses. The company accepts no liability for any damage caused by any
>> virus transmitted by this email.
>
> --
> Sorry for being brief. Alternate email is rickleir at yahoo dot com

Loading...