Note: If a new user is ever created with the same name as the deleted user, the old user's documents and notes will be indistinguishable from the new.
For | SQL Statement |
Document User Groups | SELECT * FROM DOCUGRP00 WHERE GUSER = ? OR GGROUP = ? |
Document Folder Security | SELECT * FROM DOCSEC00 WHERE DUSER = ? |
Document Type User Access | SELECT * FROM DOCTYPU00 WHERE DRUSER = ? |
Document Routing Definition Detail/Steps | SELECT * FROM DOCFLOWD00 WHERE FDFLOWUSER = ?
SELECT * FROM DOCFLOWS00 WHERE FSUSER = ? OR |
Document Users | SELECT * FROM DOCUSR00 WHERE USERGROUP = ? |
Document User Predefined Filter Criteria | SELECT * FROM DOCUSFLT00 WHERE FUSERNAM = ? |
Document Catalog | SELECT * FROM DOCS00 WHERE CHKOUSER = ? OR CHKUSER = ? OR REVUSER = ? |
Document Versions | SELECT * FROM DOCVER00 WHERE VERUSER = ? |
Document Notes/Annotations | SELECT * FROM DOCNOT00 WHERE NUSER = ? |
Document Log File | SELECT * FROM DOCLOG00 WHERE LUSER = ? |
Document Route Detail/Steps | SELECT * FROM DOCFLOW00 WHERE FAPVUSER = ? OR FFLOWUSER = ? OR FORIGUSER = ? |
Document Session Table | SELECT * FROM DOCSES00 WHERE SESSUSER = ? OR SGROUPUSER = ? OR SWORKFLOWU = ? |
Document Event File | SELECT * FROM DOCEVENT WHERE EUSER = ? |
Document Users (DELETE) | DELETE FROM DOCUSR00 WHERE USERNAM = ? |
For | SQL Statement |
Document Folder Security |
SELECT * FROM DOCSEC00 WHERE DFOLDER1 = ?1 AND
DFOLDER2 = ?2 AND DFOLDER3 = ?3 AND DFOLDER4 = ?4 AND DFOLDER5 = ?5 |
If level 2 is blank |
SELECT * FROM DOCSEC00 WHERE DFOLDER1 = ?1 AND
DFOLDER2 <> ' ' |
If level 3 is blank |
SELECT * FROM DOCSEC00 WHERE DFOLDER1 = ?1 AND
DFOLDER2 = ?2 AND DFOLDER3 <> ' ' |
If level 4 is blank |
SELECT * FROM DOCSEC00 WHERE DFOLDER1 = ?1 AND
DFOLDER2 = ?2 AND DFOLDER3 = ?3 AND DFOLDER4 <> ' ' |
If level 5 is blank |
SELECT * FROM DOCSEC00 WHERE DFOLDER1 = ?1 AND
DFOLDER2 = ?2 AND DFOLDER3 = ?3 AND DFOLDER4 = ?4 AND DFOLDER5 <> ' ' |
Document Session Table |
SELECT * FROM DOCSES00 WHERE SFOLDER1 = ?1 AND
SFOLDER2 = ?2 AND SFOLDER3 = ?3 AND SFOLDER4 = ?4 AND SFOLDER5 = ?5 |
If level 2 is blank |
SELECT * FROM DOCSES00 WHERE SFOLDER1 = ?1 AND
SFOLDER2 <> ' ' |
If level 3 is blank |
SELECT * FROM DOCSES00 WHERE SFOLDER1 = ?1 AND
SFOLDER2 = ?2 AND SFOLDER3 <> ' ' |
If level 4 is blank |
SELECT * FROM DOCSES00 WHERE SFOLDER1 = ?1 AND
SFOLDER2 = ?2 AND SFOLDER3 = ?3 AND SFOLDER4 <> ' ' |
If level 5 is blank |
SELECT * FROM DOCSES00 WHERE SFOLDER1 = ?1 AND
SFOLDER2 = ?2 AND SFOLDER3 = ?3 AND SFOLDER4 = ?4 AND SFOLDER5 <> ' ' |
Document Catalog |
SELECT * FROM DOCS00 WHERE ( FOLDER1 = ?1 AND
FOLDER2 = ?2 AND FOLDER3 = ?3 AND FOLDER4 = ?4 AND FOLDER5 = ?5 ) OR ( RFOLDER1 = ?1 AND RFOLDER2 = ?2 AND RFOLDER3 = ?3 AND RFOLDER4 = ?4 AND RFOLDER5 = ?5 ) |
If level 2 is blank |
SELECT * FROM DOCS00 WHERE ( FOLDER1 = ?1 AND
FOLDER2 <> ' ' ) OR ( RFOLDER1 = ?1 AND RFOLDER2 <> ' ' ) |
If level 3 is blank |
SELECT * FROM DOCS00 WHERE ( FOLDER1 = ?1 AND
FOLDER2 = ?2 AND FOLDER3 <> ' ' ) OR ( RFOLDER1 = ?1 AND RFOLDER2 = ?2 AND RFOLDER3 <> ' ' ) |
If level 4 is blank |
SELECT * FROM DOCS00 WHERE ( FOLDER1 = ?1 AND
FOLDER2 = ?2 AND FOLDER3 = ?3 AND FOLDER4 <> ' ' ) OR ( RFOLDER1 = ?1 AND RFOLDER2 = ?2 AND RFOLDER3 = ?3 AND RFOLDER4 <> ' ' ) |
If level 5 is blank |
SELECT * FROM DOCS00 WHERE ( FOLDER1 = ?1 AND
FOLDER2 = ?2 AND FOLDER3 = ?3 AND FOLDER4 = ?4 AND FOLDER5 <> ' ' ) OR ( RFOLDER1 = ?1 AND RFOLDER2 = ?2 AND RFOLDER3 = ?3 AND RFOLDER4 = ?4 AND RFOLDER5 <> ' ' ) |
Document Users |
SELECT * FROM DOCUSR00 WHERE USERDFLR1 = ?1 AND
USERDFLR2 = ?2 AND USERDFLR3 = ?3 AND USERDFLR4 = ?4 AND USERDFLR5 = ? |
If level 2 is blank |
SELECT * FROM DOCUSR00 WHERE USERDFLR1 = ?1 AND
USERDFLR2 <> ' ' |
If level 3 is blank |
SELECT * FROM DOCUSR00 WHERE USERDFLR1 = ?1 AND
USERDFLR2 = ?2 AND USERDFLR3 <> ' ' |
If level 4 is blank |
SELECT * FROM DOCUSR00 WHERE USERDFLR1 = ?1 AND
USERDFLR2 = ?2 AND USERDFLR3 = ?3 AND USERDFLR4 <> ' ' |
If level 5 is blank |
SELECT * FROM DOCUSR00 WHERE USERDFLR1 = ?1 AND
USERDFLR2 = ?2 AND USERDFLR3 = ?3 AND USERDFLR4 = ?4 AND USERDFLR5 <> ' ' |
Select Folders |
|
If level 2 is blank |
SELECT * FROM DOCFLR00 WHERE DOCFLR1 = ?1 AND
DOCFLR2 <> ' ' |
If level 3 is blank |
SELECT * FROM DOCFLR00 WHERE DOCFLR1 = ?1 AND
DOCFLR2 = ?2 AND DOCFLR3 <> ' ' |
If level 4 is blank |
SELECT * FROM DOCFLR00 WHERE DOCFLR1 = ?1 AND
DOCFLR2 = ?2 AND DOCFLR3 = ?3 AND DOCFLR4 <> ' ' |
If level 5 is blank |
SELECT * FROM DOCFLR00 WHERE DOCFLR1 = ?1 AND
DOCFLR2 = ?2 AND DOCFLR3 = ?3 AND DOCFLR4 = ?4 AND DOCFLR5 <> ' ' |
Document Folders (DELETE) |
DELETE FROM DOCFLR00 WHERE DOCFLR1 = ?1 AND
DOCFLR2 = ?2 AND DOCFLR3 = ?3 AND DOCFLR4 = ?4 AND DOCFLR5 = ?5 |
For | SQL Statement |
Document Lookup Pulldown Fields | SELECT * FROM DOCL00 WHERE LDOCTYPE = ? AND LKEYVAL = 'USERKEY[1-10]' |
Document Custom Lookup Pulldown SQL | SELECT * FROM DOCLS00 WHERE LSDOCTYPE = ? AND LSKEYVAL = 'USERKEY[1-10]' |
Document Catalog | SELECT * FROM DOCS00 WHERE DOCTYPE2 = ? AND KEYWORD[1-10] <> ' ' |
Document Linked Indexes | SELECT * FROM DOCLINK00 WHERE LDOCTYPE2 = ? AND LKEYWORD[1-10] <> ' ' |
Document Settings (DELETE) | DELETE FROM DOCKEY00 WHERE KEYTYPE = ? AND KEYVAL = USERKEY[1-10] |
For | SQL Statement |
Document Settings | SELECT * FROM DOCKEY00 WHERE KEYTYPE = ? |
Document Type User Access | SELECT * FROM DOCTYPU00 WHERE DRTYPE = ? |
Document Lookup Pulldown Fields | SELECT * FROM DOCL00 WHERE LDOCTYPE = ? |
Document Custom Lookup Pulldown SQL | SELECT * FROM DOCLS00 WHERE LSDOCTYPE = ? |
Document Users | SELECT * FROM DOCUSR00 WHERE USERDTYPE = ? |
Document Catalog | SELECT * FROM DOCS00 WHERE DOCTYPE2 = ? |
Document Linked Indexes | SELECT * FROM DOCLINK00 WHERE LDOCTYPE2 = ? |
Document Session Table | SELECT * FROM DOCSES00 WHERE SESDOCTYP = ? |
Document Type (DELETE) | DELETE FROM DOCTYPE00 WHERE DCTYPE = ? |
Still have questions? We can help. Submit a case to Technical Support.