For my use only don't use this without understanding what you are doing.
I had a bunch of old MDS features in my menu which was causing our menu to collapse on login.
(The collapse feature was set to not persist so the users had no way of fixing this).
Instead of writing code or purging all settings from MDS for that page I decided on a data fix.
Forgive my sql skills this was a quick and dirty.
TABLE : MDS_ATTRIBUTES - this is where all the mds configuration is kept for each item and attribute.
TABLE : MDS_PATHS - this is where the file name for the resource you are looking for is kept. (ie page.jsff) you can also find the user in the path so you can do this for a specific user.
CURSOR v_path_cursor IS
SELECT pa.PATH_CONTENTID FROM MDS_PATHS pa WHERE pa.PATH_PARTITION_ID = 3 AND PA.PATH_TYPE = 'DOCUMENT' AND PATH_NAME like '%portalTemplate%';
FETCH v_path_cursor INTO v_content_id;
EXIT WHEN v_path_cursor%NOTFOUND;
SELECT ATT_COMP_SEQ into v_col_seq FROM MDS_ATTRIBUTES a WHERE a.att_contentID = v_content_id AND a.ATT_PARTITION_ID = 3 AND a.ATT_VALUE = 'collapsed';
THEN v_col_seq := null;
IF v_col_seq IS NOT NULL THEN
UPDATE MDS_ATTRIBUTES SET ATT_VALUE = 'false' WHERE att_contentID = v_content_id AND ATT_PARTITION_ID = 3 AND ATT_COMP_SEQ = v_col_seq AND ATT_LOCALNAME = 'value' AND ATT_VALUE = 'true';
dbms_output.put_line('updating:' || v_content_id || '-' || v_col_seq || ' split to false');
NOTE: Restart Portal servers.