Identifying Database Tables for Applications and Items

Your URL provides you with database location information for your applications and items.  

Applications

Every application or App has an appID.  When you navigate to an application, you'll see the appID in the URL, which corresponds to the database table for this item.  Each appID has a corresponding set of tables in the database, as follows:

Documents: intranet/Apps/view.cfm?appID=5019

Forms:  /intranet/Forms/view.cfm?appID=7

Training Calendar: intranet/Training/view.cfm?appID=10

News on a sub-site: intranet/Apps/view_items.cfm?menuID=2000047

Folders and Categories

Your folders and categories have an ID as well to help you further isolate the information in the database.  You can use this to filter data found in the corresponding table.

Document Folder:  /intranet/Apps/view_items.cfm?MenuID=5019&CategoryID=1

Formbuilder Folder:  intranet/Forms/view_items.cfm?MenuID=7&CategoryID=1

Training Calendar Category:  intranet/Training/view.cfm?MenuID=10&CategoryID=2

News on a sub-site Folder:  intranet/Apps/view_items.cfm?MenuID=2000047&CategoryID=2

Items

Each item also has its own ID to help isolate data further.  You can use this to filter data found in the corresponding table.

Document: intranet/Apps/detail_view.cfm?MenuID=5019&CategoryID=1&ID=8

Form:  intranet/forms/viewform.cfm?formID=5

Training Calendar: /intranet/Training/view.cfm?MenuID=10&section=course_view&CategoryID=1&ID=8

News on a sub-site: intranet/Apps/detail_view.cfm?MenuID=2000047&CategoryID=1&ID=1

Data Dictionary

To access a complete Data Dictionary of all tables within the Intranet Connections database, check out our IC Data Dictionary.pdf. You'll be prompted for the following information:

  • Login - primary contact’s email address, typically the person responsible for contacting Intranet Connections for support
  • Password - serial number of your product found on the Setup tab in the Admin section

Locate Tables

To find the corresponding tables for a given application, you can use the following code:

<!--- start code --->
<cfquery name="getdata" datasource="#application.config.DSN#">
Select Tablename1, Tablename2, Tablename3, Tablename4, Tablename5, Tablename6, Tablename7, Tablename8, Tablename9, Tablename10, FilefolderName from MenuCategories where MenuID = 6
</cfquery>
<cfdump var="#getdata#">
<cfabort>
<!---end code --->

You'll need to replace the MenuID listed above with the specific MenuID for the item you are investigating.

You can run the above query by copying the contents to Admin > Execute Custom Code and clicking execute. You should see something similar to the following as a result:

Tablename1 contains the primary items table for the application.

Tablename2 contains the folder or category values.

The files associated with the application are in the location shown in FilefolderName.  This location is on the web server.

Related articles