CAD Forum

jcapriotti wrote: ↑Sun Oct 23, 2022 3:50 pm They could certainly improve it. The only suggestion I can think of is to restore the files..... Move them into a delete sub folder to sort on them there.

Fyi, Shift delete bypasses the recycle bin and destroys the files. Not sure if you can make use of that in some way.

bnemec wrote: ↑Mon Oct 24, 2022 9:42 am I assume that's from vault view UI? Hopefully it's regulated by user/group permissions?

Diaval wrote: ↑Tue Oct 25, 2022 7:23 am There is an enhancement SPR for adding the ability to sort the Deleted Items. SPR 1099065

bnemec wrote: ↑Wed Oct 26, 2022 1:00 pm I don't understand all that goes on in the back ground, but I have learned to see a little. It seems that all these deleted files are still in the documents table just have the deleted field set to 1. If I could add that to a search, deleted = 1, and have ability to destroy from there, that would be awesome, all the columns I need are right there.

I cannot think of a need for any other interface, just use what's already there?

jcapriotti wrote: ↑Wed Oct 26, 2022 1:43 pm Searching deleted files would be nice and seems like an easy enhancement. Delete just toggles that flag in the Documents table, Destroy removes the record from the table. There are other tables affected so you can't just toggle the deleted state or remove the record without consequences.

Diaval wrote: ↑Tue Oct 25, 2022 7:23 am There is an enhancement SPR for adding the ability to sort the Deleted Items. SPR 1099065

bnemec wrote: ↑Wed Oct 26, 2022 1:00 pm I don't understand all that goes on in the back ground, but I have learned to see a little. It seems that all these deleted files are still in the documents table just have the deleted field set to 1. If I could add that to a search, deleted = 1, and have ability to destroy from there, that would be awesome, all the columns I need are right there.

I cannot think of a need for any other interface, just use what's already there?

@[ListDeleted]
§Name [All deleted files sorted by file type]

§Company [CADForum]

§Description
[This query will list all deleted files, sorted by file extension.]

§Version [1.1]

§Arguments
[
]

§Sql
[
select Docs.Filename as 'File Name',Projects.Path as Location,Hist.Time as 'Deleted On',Hist.ProjectID,Users.FullName as 'Deleted By',
lower(right(Docs.FileName, charindex('.', reverse(Docs.Filename) + '.') - 1)) as 'File Type'
from dbo.Documents as Docs 
inner join dbo.HistoryDelete as Hist on docs.DocumentID = Hist.DocumentID
inner join dbo.Users as Users on Hist.UserID = Users.UserID
inner join dbo.Projects as Projects on Hist.ProjectID = Projects.ProjectID
where Docs.Deleted = 1 order by 'File Type'
]

JSculley wrote: ↑Wed Oct 26, 2022 2:42 pm The report generator can help you out as well. Here's a report that lists all deleted files, sorted by file extension.

Code: Select all

@[ListDeleted]
§Name [All deleted files sorted by file type]

§Company [CADForum]

§Description
[This query will list all deleted files, sorted by file extension.]

§Version [1.1]

§Arguments
[
]

§Sql
[
select Docs.Filename as 'File Name',Projects.Path as Location,Hist.Time as 'Deleted On',Hist.ProjectID,Users.FullName as 'Deleted By',
lower(right(Docs.FileName, charindex('.', reverse(Docs.Filename) + '.') - 1)) as 'File Type'
from dbo.Documents as Docs 
inner join dbo.HistoryDelete as Hist on docs.DocumentID = Hist.DocumentID
inner join dbo.Users as Users on Hist.UserID = Users.UserID
inner join dbo.Projects as Projects on Hist.ProjectID = Projects.ProjectID
where Docs.Deleted = 1 order by 'File Type'
]

Gives you something like this:

image.png

The report generator occupies the space between plain vanilla EPDM search and remoting in to the server and using SQL Management Studio.

bnemec wrote: ↑Wed Oct 26, 2022 2:40 pm Just voted for that ER with note explaining why adding function to the PDM Search Tool would be great. Hopefully someone at PDM dev will see it and consider. Even if it's not possible, a reply explaining that would be nice.