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: 

Re-enable archived catalog item

TeriStevenson
By
Level 9

I have an archived catalog item in WD_WebPackages from 2018 that I need to bring back into being visible.  I can update the PackageVisible to 1 and INSERT INTO WD_Package_Category with the category id I need but the catalog item isn't showing in App Portal under the category.  My sql query f, below finds it so I must be missing something obvious... 

SELECT wp.PackageID, WD_Category.CatName, wp.PackageTitle,wp.FUID, wp.PackageVisible,
wp.CatalogCost, wp.CreatedOn, wp.BriefDescription, wp.Type, pc.CategoryID
FROM WD_Package_Category pc INNER JOIN
WD_WebPackages wp ON pc.PackageID = wp.PackageID INNER JOIN
WD_Category ON pc.CategoryID = WD_Category.CatID

where wp.PackageVisible = '1'
and wd_category.catname = 'Server licenses'

(1) Solution

jdempsey
By Moderator Moderator
Moderator

You need to set PackageVisible=1 and Deleted=0.  Deleted=1 means the item has been archived.  PackageVisible=1 means the item has been enabled for request.  You'll likely find that aside from Category, there are probably some other properties that will need to be re-established (workflows?), but it is easier to do all of that in the UI after you've unarchived the item (Deleted=0).

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".

View solution in original post

(2) Replies

jdempsey
By Moderator Moderator
Moderator

You need to set PackageVisible=1 and Deleted=0.  Deleted=1 means the item has been archived.  PackageVisible=1 means the item has been enabled for request.  You'll likely find that aside from Category, there are probably some other properties that will need to be re-established (workflows?), but it is easier to do all of that in the UI after you've unarchived the item (Deleted=0).

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".

I remembered the deleted right after I posted this... it's always something obvious 🙂