Linking to Lucity Web

At times, an agency might find it useful to create a URL that links directly to Lucity Web to view a particular asset, without navigating through the Lucity Web interface. For example, an agency may want to to embed such a URL into a Crystal report.

Use the following URL as a template for jumping directly into the Lucity Web to view an Asset:

http://[myserver]/[virtualdirectory]/Public/Routing.aspx?RouteTarget=Internal&RouteSubTarget=Views&RouteAction=OpenDefault&RouteParam1=[moduleid]&RouteParam2=[viewname]&RouteParam3=[Filter[tablename]+WHERE+[autoNumberField]=[autoNumber]]

Six parts of the template must be specified:

[myserver]	The name of the server hosting Lucity Web.
[virtualdirectory]	The virtual directory in which Lucity Web is installed. By default: LucityWeb.
[moduleid]	The identifying number for the module you wish to open. To zoom to a specific Sewer Pipe record, use the module ID for the Sewer Pipes module. To zoom to a specific Work Order, insert the ID for the Work Order module. All module IDs are stored as KeyIDs in the GBAUser.dbo.Modules table.
[viewname]	The name you wish to appear at the top of the View when it is loaded. Use + or %20 to represent spaces.
[Filter......]	The remaining parameters fall within this section of the URL. These parameters are provided as an example; however, the intent is to enter a filter that starts with the table found in the From clause of a SQL statement in order to filter the records that are displayed in the View. Use %3D to replace an = sign.
[tablename]	The name of the table in which the feature or record is stored.
[autoNumberField]	The name of the field in which the autonumber is stored.
[autoNumber]	The database record number that the program assigned to identify the desired feature. For the GBASewer.dbo.SWNET table, the [autoNumber] would be NT_ID.

Examples

The following URL will open Lucity Web and display the Work Order with WO_ID = 33945:

http://ExampleServer/LucityWeb/Public/Routing.aspx?RouteTarget=Internal&RouteSubTarget=Views&RouteAction=OpenDefault&RouteParam1=48&RouteParam2=WO%20%2312-2343&RouteParam3=WKORDER+WHERE+WO_ID+%3D+33945