2 Replies Latest reply: Feb 2, 2011 1:04 AM by Pierre Barnard RSS

Active Links and Filters lost after form deletion

Pierre Barnard
Hi all,
I lost my active links and filters after I deleted a form (yeah I know).
I want to re-instate everything to how it was before the deletion, and have done the following:
1. Renamed the same form from a backup to the original name (form now T1677 instead of T1670 previously).
2. Restored the lost AL's and filters through the Oracle database backend into the ACTLINK and FILTER tables.
3. Updated the scema_id in actlink_mapping and filter_mapping tables to T1677.
When I run the following sql, all my deleted filters now show up again:
SELECT NAME FROM ACTLINK WHERE ACTLINKID IN (SELECT ACTLINKID FROM
ACTLINK_MAPPING WHERE SCHEMAID = (SELECT SCHEMAID FROM ARSCHEMA WHERE NAME LIKE
'%FormName%'));
The problem is, I cannot get my active links or filters to show on the Remedy Administrator tool. Even if I list ALL FORMS. I am not worried about the data that was in the form.
I am running Remedy 6.3.
What am I missing? Any help will be appreeciated please.