query
RESULTSET
query
  CATEGORY CATEGORYDESCRIPTION CATSORTRANK CONTAINERID CONTAINERTYPE CONTENTID DOCDESCRIPTION DOCPATH DOCTITLE FILEEXT FILEID FILENAME FILESIZE HIDDEN INTERNALONLY KEEPVERSIONS LINKID LINKTYPE MAINFOLDER OWNERID OWNERTYPE PUBLISHDATE RESTRICTED SORTRANK SRCURL SUBFOLDER SUBFOLDER2 UNPUBLISHDATE UPDATEDATE UPDATEUSERID UPLOADDATE VERSIONNBR
1 5 Archived Child Specsheet 99 2429023 SKU 2470369 File was archived via an automated process and is a snapshot of the product data on February 10, 2017. http://doclibrary.com/MFR102/SKU/256821_Feb_10_2017_Archived_2459.pdf 256821 Feb 10, 2017 Specsheet PDF 33338 256821_Feb_10_2017_Archived_2459.pdf 549822 N N N [empty string] [empty string] MFR102 102 MFR 2017-02-10 00:00:00.0 N 99 [empty string] SKU [empty string] 2027-02-10 00:00:00.0 [empty string] [empty string] 2017-02-10 11:23:08.49 0
2 5 Archived Child Specsheet 99 2429023 SKU 2176807 File was archived via an automated process and is a snapshot of the product data on November 01, 2016. http://doclibrary.com/MFR102/SKU/256821_Nov_01_2016_Archived_0244.pdf 256821 Nov 01, 2016 Specsheet PDF 1941 256821_Nov_01_2016_Archived_0244.pdf 550156 N N N [empty string] [empty string] MFR102 102 MFR 2016-11-01 00:00:00.0 N 99 [empty string] SKU [empty string] 2026-11-01 00:00:00.0 [empty string] [empty string] 2016-11-01 07:02:03.727 0
CACHED false
EXECUTIONTIME 0
SQL select * from qmd_repositoryContents where hidden = 'N'