The Community is now in read-only mode to prepare for the launch of the new Flexera Community. During this time, you will be unable to register, log in, or access customer resources. Click here for more information.

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Show new items search

kevin_philpot
By
Level 6

For the "Show new items search", is there a way to filter the results more than just setting the day limit?

For example, can we also filter in/out folders?  We have production and non-production categories, and for that reason if we were going to use this option to show new items, we would want to limit the results to the production folders... 

I know that the "Most Requested" uses the vMostRequested sql view...which could be modified if you wanted to further limit the results.   I didn't see any other view that looked like the "Show New Items" view...so I am thinking we may not be able to do this. 

Thought I would ask.   Thanks.

 

 

(2) Replies

CharlesW
By Level 12 Flexeran
Level 12 Flexeran

No, I don't see a way to change/filter the results for "new items".. Rather than using a view, the query for new items is hard coded, so there would be no way to modify. No surprises here, but the following is the query being used for new items:

Select Distinct PackageTitle, CreatedOn FROM WD_WebPackages Where Deleted <> 1 and PackageVisible = 1 AND CreatedOn IS NOT NULL and datediff(day, CreatedOn, getDate()) < <DAYLIMITVALUE>
AND PackageID Not IN ( Select Distinct PM.PackageID from WD_PackageMapper PM Where PM.MapperType in (2,3,4) ) ORDER BY CreatedOn DESC

 

Thanks for the details @CharlesW .  That being the case, while not ideal, perhaps a workaround would be after creating an item that you don't want to appear in the New Items list, add a note to it under the Notes tab of catalog item properties in order to capture the real CreatedOn date.  Then run a script to update the CreatedOn date in the database to (Today - <DAYLIMITVALUE> - 1).

Anything expressed here is my own view and not necessarily that of my employer, Flexera. If my reply answers a question you have raised, please click "ACCEPT AS SOLUTION".