EntityAuditLog mapping with corresponding event(Service/Event)

[parimal gain-2]

Hi All,

When looking into EntityAuditLog table, it store the changed entity
name, change field name, old value, new value and user login id
information, but there is no information of event by which the value
is modified.

So my question is
1)  Is there any way to find out that corresponding to which request,
corresponding to which service or event call the entity field is
created/modified?
2) Is there any way to confirm that the fields of entities is modified
from webtools only either by editing a row or from sql querry?

The requirement for #2 is if we are maintaining the auditing history
then we have to make sure that the audit entity field not modified at
entity level, even not through user having root privileges.


If Answer of these two question is no then what will the best way to
achieve both of this with OFBiz best practice.

Thanks in Advance!!!
--
Parimal Gain

[parimal gain-2]

Any information/help regarding this will be appreciated.

Thanks in Advance.....
On Aug 27, 2012 11:58 PM, "parimal gain" <[hidden email]> wrote:

> Hi All,
>
> When looking into EntityAuditLog table, it store the changed entity
> name, change field name, old value, new value and user login id
> information, but there is no information of event by which the value
> is modified.
>
> So my question is
> 1)  Is there any way to find out that corresponding to which request,
> corresponding to which service or event call the entity field is
> created/modified?
> 2) Is there any way to confirm that the fields of entities is modified
> from webtools only either by editing a row or from sql querry?
>
> The requirement for #2 is if we are maintaining the auditing history
> then we have to make sure that the audit entity field not modified at
> entity level, even not through user having root privileges.
>
>
> If Answer of these two question is no then what will the best way to
> achieve both of this with OFBiz best practice.
>
> Thanks in Advance!!!
> --
> Parimal Gain
>

[Jacques Le Roux]

I can at least say that I believe the answer to your both questions is no
Did you already trace how/when the userlogin is stored? Maybe you can follow this way and do the same to an extended entities with
the new fields you require
Also maybe a look at ServerHitBin class could help...

Jacques

From: "parimal gain" <[hidden email]>

> Any information/help regarding this will be appreciated.
>
> Thanks in Advance.....
> On Aug 27, 2012 11:58 PM, "parimal gain" <[hidden email]> wrote:
>
>> Hi All,
>>
>> When looking into EntityAuditLog table, it store the changed entity
>> name, change field name, old value, new value and user login id
>> information, but there is no information of event by which the value
>> is modified.
>>
>> So my question is
>> 1)  Is there any way to find out that corresponding to which request,
>> corresponding to which service or event call the entity field is
>> created/modified?
>> 2) Is there any way to confirm that the fields of entities is modified
>> from webtools only either by editing a row or from sql querry?
>>
>> The requirement for #2 is if we are maintaining the auditing history
>> then we have to make sure that the audit entity field not modified at
>> entity level, even not through user having root privileges.
>>
>>
>> If Answer of these two question is no then what will the best way to
>> achieve both of this with OFBiz best practice.
>>
>> Thanks in Advance!!!
>> --
>> Parimal Gain
>>
>

[parimal gain-2]

Thanks Jacques for info. As I have seen the implementation, userlogin is
store as identifier, but how the identifier is assigning the current login
I have to see.
 On Aug 29, 2012 3:57 PM, "Jacques Le Roux" <[hidden email]>
wrote:

> I can at least say that I believe the answer to your both questions is no
> Did you already trace how/when the userlogin is stored? Maybe you can
> follow this way and do the same to an extended entities with the new fields
> you require
> Also maybe a look at ServerHitBin class could help...
>
> Jacques
>
> From: "parimal gain" <[hidden email]>
>
>> Any information/help regarding this will be appreciated.
>>
>> Thanks in Advance.....
>> On Aug 27, 2012 11:58 PM, "parimal gain" <[hidden email]> wrote:
>>
>>  Hi All,
>>>
>>> When looking into EntityAuditLog table, it store the changed entity
>>> name, change field name, old value, new value and user login id
>>> information, but there is no information of event by which the value
>>> is modified.
>>>
>>> So my question is
>>> 1)  Is there any way to find out that corresponding to which request,
>>> corresponding to which service or event call the entity field is
>>> created/modified?
>>> 2) Is there any way to confirm that the fields of entities is modified
>>> from webtools only either by editing a row or from sql querry?
>>>
>>> The requirement for #2 is if we are maintaining the auditing history
>>> then we have to make sure that the audit entity field not modified at
>>> entity level, even not through user having root privileges.
>>>
>>>
>>> If Answer of these two question is no then what will the best way to
>>> achieve both of this with OFBiz best practice.
>>>
>>> Thanks in Advance!!!
>>> --
>>> Parimal Gain
>>>
>>>
>>