Software 101 – Database Part 3

Information on a folder by entering the FolderID

To find information about a folder, such as who created it and who modified it.  You need to have the FolderID.  To locate the FolderId, you will first run the following query:

• select *
  from Folder
  where CompanyId = ‘CompanyID’

When that information populates, you will locate the FolderName you are looking for and the corresponding FolderID. Using that FolderID, you will perform this following query to access information about that folder.

• select *
  from Folder
  where FolderId = ‘FolderID’

Pull all folders under a Company by entering the CompanyId

To generate a list of all folders that are created under a company use the following queries:

First, locate the company’s CompanyID,

• select CompanyId
  from company
  where [Name] = ‘Silly Productions Training Center, UOS’

***Remember, you must type out the company name exactly how it is listed on their account.  You can not type one word and hit execute thinking all accounts with that name in it will appear and you can choose the company you are looking for.  If it is not complete it will not yield any results.

Once you have located the CompanyID, execute the below query,

• select *
  from Folder
  where CompanyId = ‘112281’