Migrating from IFS8 to IFS10, is there a way to export the list of Saved Searches, or query them directly in SQL, to verify they all came through the migration intact — 'My Administration' > 'Saved Searches' shows the list in the UI but doesn't offer an export option?

All FAQ questions / Developer Studio, deployment, and upgrades

Answer

Saved Search definitions are stored as profile entries in the FNDRR_CLIENT_PROFILE_VALUE table, with each saved search's name embedded within its profile_section value, following a pattern like .../SavedSearches/<name>, and its actual condition stored under a profile_entry = 'CONDITION' row. Querying that table, extracting the search-name portion of profile_section, and filtering by profile_entry = 'CONDITION' and by the specific user's ID, resolvable via fndrr_client_profile_api.Get_Owner, produces a straightforward list of saved search names for a given user, which can then be compared directly between two environments, like IFS8 vs IFS10, to verify all saved searches migrated correctly.

Documentation-based answer. Confirm the product and release before applying it. This answer has not been verified in an IFS environment.

← Browse Developer Studio, deployment, and upgrades questions