Linking to Lucity Web

There are times it would be useful to have a create a URL that will take a user directly into the Lucity Web to look at an asset, without going through the Lucity Web interface. One example of this would be to embed the URL into a crystal report.

The following URL is a template to jump directly into the 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]]

There are six parts of the template that need to be replaced.

[myserver]

This is the name of the server that is hosting Lucity web

[virtualdirectory]

This is the virtual directory that Lucity Web is installed in. By default this is LucityWeb.

[moduleid]

This is the identifying number for the module that will be opened. To zoom to a specific sewer pipe ID, the module ID would be the module ID for the Sewer Pipes. To zoom to a work order, it would be the module ID for the Work Order module. All of the module IDs are stored in the GBAUser.dbo.Modules table. Within that table the KeyID is the module ID.

[viewname]

This is the name that you would like to appear at the top of the view when it is loaded.

  • Use + or %20 to replace space character in the view name.

[Filter......]

All of the following parameters fall within this section. They are used as an example, but enter a filter here starting with the table found in the From clause of a SQL statement to filter the records that are displayed in the view.

  • Use %3D to replace an = sign.

[tablename]

This is the name of the table that the feature or record is stored in.

[autoNumberField]

This is the name of the field that the autonumber is stored in.

[autoNumber]

This is the database record number that the program automatically assigns to each feature. This ID is the modules database record number that is designed to help the program identify the feature. For the GBASewer.dbo.SWNET table this would be NT_ID.

Examples

This URL will open the web and display a 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

See Also

Advanced

Linking to Lucity Webmap

Override Crystal Page Limits

Customizing the Dashboard Background Image

Disable HTML Reports