USP_WEALTHPOINT_UNRESOLVEDDATAREFRESHSEARCHES
This stored procedure returns a list of data refresh searches that are unresolved.
Definition
Copy
create procedure dbo.USP_WEALTHPOINT_UNRESOLVEDDATAREFRESHSEARCHES
as
begin
select
WP.ID
from
dbo.WPSEARCHHISTORY WP
where
WP.STATUSCODE in (0, 1) and
WP.SEARCHTYPECODE = 2
end