Login / Signup

HDS - Only Log Bit Changes with a specific Domain

 
Archive Data mgt
Last Post by n.kunzer 8 years ago
5 Posts
2 Users
0 Likes
40 Views
RSS
 m.nau@ypsys.com
(@m.nau@ypsys.com)
Posts: 0
New Member Guest
 

Hi everyone,

do you know a way, a trick ,a solution to archive Bit changes (not only display) in a HDS Log table with a specific Domain or Nature like "attribute filter" for the proprietary log list?

Thank you

 
Posted : 28/11/2018 4:11 pm
n.kunzer
 n.kunzer
(@n-kunzerarcinfo-com)
Posts: 1236
Member Moderator
 

Hi Manu,

It is unfortunately impossible and agree it's quite a big problem.
The only trick I found and implemented so far in some sites is quite rough!
Keep HDS archiving all and then create a SQL job (5mn) that is removing the records not needed.
Yes...rough...

Nico

 
Posted : 28/11/2018 4:47 pm
 m.nau@ypsys.com
(@m.nau@ypsys.com)
Posts: 0
New Member Guest
 

So bad , so sad.

 
Posted : 28/11/2018 10:25 pm
 m.nau@ypsys.com
(@m.nau@ypsys.com)
Posts: 0
New Member Guest
 

Hi Nico,

Do you have an example of your SQL Job please? I 'm not an expert of SQL queries.

Thanks

Manu

 
Posted : 10/12/2018 4:30 pm
n.kunzer
 n.kunzer
(@n-kunzerarcinfo-com)
Posts: 1236
Member Moderator
 

Hi Manu,

It's a simple query. For example, let's say you have 4 domains DOM1, DOM2, DOM3, DOM4 and you want to keep only the DOM1

Query is:
DELETE FROM [mytable] where Domain DOM1

 
Posted : 10/12/2018 4:43 pm
Forum Jump:
  Previous Topic
Next Topic