Hello,

I would like to know which SQL table or functiun use What's New ? 1.0 module in DNN 5.1.2.

We would like to disallow some modules and tabs to be inserted in the What's new modules.

In DNN 4.4 and What's NEw 3.3 we used to update the GetSearchItems functiun, but it doesn't not seems to work with this same table in the latest What's new module

Regards

Throught business API ? That is to say i can't make exceptions based on Module and Tab ID ?

In 4.4 it was just a SQL functiun, here is what we did

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO

ALTER PROCEDURE [dbo].[GetSearchItems]
@PortalId int,
@TabId int,
@ModuleId int

AS
SELECT distinct si.*,
       'AuthorName' = u.FirstName + ' ' + u.LastName,
       t.TabId
FROM   dbo.SearchItem si
    LEFT OUTER JOIN dbo.Users u ON si.Author = u.UserID
    INNER JOIN dbo.Modules m ON si.ModuleId = m.ModuleID
    INNER JOIN dbo.TabModules tm ON m.ModuleId = tm.ModuleID
    INNER JOIN dbo.Tabs t ON tm.TabID = t.TabID
    INNER JOIN dbo.Portals p ON t.PortalID = p.PortalID
WHERE (p.PortalId = @PortalId or @PortalId is null)
    AND   (t.TabId = @TabId or @TabId is null)
    AND   (t.TabId <> 102 and t.TabId <> 159 and t.TabId <> 120 and t.TabId <> 116 and t.TabId <> 99 and t.TabId <> 134 and t.TabId <> 60 and t.TabId <> 109 and t.TabId <> 203)
    AND   (m.ModuleId = @ModuleId or @ModuleId is null)
    AND   (m.ModuleDefId = 119 or m.ModuleDefId = 95 or m.ModuleDefId = 96 or m.ModuleDefId = 97)
    AND   (si.SearchKey NOT LIKE '%-%')
ORDER BY PubDate DESC

Hello,

I make different filter option based on the PROCEDURE [dbo].[GetSearchItems] and each times the result are the same, as if it's not taking care of the filters wrote in the procedure.

Any Idea ?

Are you sure that GetSearchItems is still used ?