Are you using an On-Prem version of WS or using something in the cloud? I ask because i know that in the database there is a configurations table where among many other things a user's customized views are stored. I have a pretty simple query i run to make sure i only get the records i want to clear out which i then turn into a delete statement. If you are On-Prem, you can probably use what i have. I doubt you could do so with an instance in the cloud

Hi Eric,

We are on-prem, so that would be great if you could share that! Much appreciated.

I always clear out ALL the settings for my profile although i imagine you could probably determine which specific ones you'd want to clear out by looking at the names.

Here's the query:

SELECT * FROM configuration WHERE name LIKE '%ENTER_USERNAME_HERE%';

that will give you all the preference across the entire system for that user. What i do is just change the SELECT above into a DELETE and remove the star:

DELETE FROM configuration WHERE name LIKE '%ENTER_USERNAME_HERE%';

then you would want to do a commit:

COMMIT;

If you want to try to find only the rows you want to delete, you could sort the rows by name to make it easier to identify the ones to remove. That would be:

SELECT * FROM configuration WHERE name LIKE '%ENTER_USERNAME_HERE%' ORDER BY name;

If you do want to delete only a subset of rows you'd need to modify the delete statement for example you could look only for rows that had project in the name:

SELECT * FROM configuration WHERE name LIKE '%ENTER_USERNAME_HERE%' AND name LIKE '%project%' ORDER BY name;

to delete the same items you'd do as i mentioned above. change SELECT to DELETE and remove the * then do a COMMIT.

Let me know if that doesn't work for you.

I always clear out ALL the settings for my profile although i imagine you could probably determine which specific ones you'd want to clear out by looking at the names.

Here's the query:

SELECT * FROM configuration WHERE name LIKE '%ENTER_USERNAME_HERE%';

that will give you all the preference across the entire system for that user. What i do is just change the SELECT above into a DELETE and remove the star:

DELETE FROM configuration WHERE name LIKE '%ENTER_USERNAME_HERE%';

then you would want to do a commit:

COMMIT;

If you want to try to find only the rows you want to delete, you could sort the rows by name to make it easier to identify the ones to remove. That would be:

SELECT * FROM configuration WHERE name LIKE '%ENTER_USERNAME_HERE%' ORDER BY name;

If you do want to delete only a subset of rows you'd need to modify the delete statement for example you could look only for rows that had project in the name:

SELECT * FROM configuration WHERE name LIKE '%ENTER_USERNAME_HERE%' AND name LIKE '%project%' ORDER BY name;

to delete the same items you'd do as i mentioned above. change SELECT to DELETE and remove the * then do a COMMIT.

Let me know if that doesn't work for you.

Hi Eric,

I don't have direct access to the database - I have to put in a request with our server team. Just to be sure: I should ask them to do this:

DELETE FROM configuration WHERE name LIKE '%DEVINE%'
COMMIT;

Is that correct?

If your username is DEVINE then yes.

Thank you so much, Eric!

Worked a treat - thanks again!

No problem. Happy to hear it.