Help, Please! List View Filters on multiple tables became Global!

[cdiorio]

Hi,

Some time ago, all of the Filters on all of our List Views became Global...it seemed to happen to all at the same time. Users were able to edit each others Filters, and for a short time, ALL new Filters were created as Global (this stopped after a short time, I do not know why).

I've been trying to think of ways to fix this, and the basic one is to go through the sys_filter table, find all the Filters with no User and no Group, then reassign them based on what I can figure out from the Filter itself.

BUT...I don't want this to happen again, and I've googled high and low and cannot figure out how it happened in the first place. I've looked at Customer Updates, but if it was some setting somewhere or a script that was run, it wouldn't really show up there.

Does anyone have any ideas?

Thanks!

Christopher DiOrio

(Cross-posting to Dev Forum and SysAdmin Forum)

[Bert_c1]

Hi,

You may check the sys_update_version table, with filter 'name', 'starts with', 'sys_filter'. I also have records in sys_update_xml that I see with the same filter conditions.  You can look at records in the sys_filter table and for any you suspect were changed, and look at the "Updated" field to see when it was last changed.  And see if any are recent.  if within the last 30 days, App Node logs can help. Try reviewing the Transaction Log also.

Good luck

[cdiorio]

Thank you for the suggestion....I'm not seeing a large volume of updates from any one user during the time frame when this occurred, and it is hard to decipher from the Payload or XML if the Global setting was used on the specific filter. As to the Updated stamp, it's unfortunately been a while since this happened, so most of these filters have been updated since then (around Dec 1, 2022). I had also thought of looking at Customer Updates, but that didn't prove helpful, either. 

It's very strange...like there was a setting applied to ALL List View Filters at one instant, but I do not know what that could be. We used to have dozens of Filters that were specific to a Group, now there are 5 (3 of which I created last week!). I can go through all the Filters and leave those created by 'admin' or 'system' as Global, and assign the ones created by a User to that specific User....Groups will be harder to figure out, but I can get close (e.g if there is a Group in the Filter, it might have been created for use by that Group).

But my big thing is to know how it happened to avoid it ever happening again...and I cannot figure it out.

Thanks!

Chris