Creating Custom URLs to Access Pages

You can create custom URL so that users can directly access pages.

In order to create custom URLs, you must be a database user, such as privuser or admuser, that can make queries against the P6 EPPM database for project wbsids. If you do not have database access to P6 EPPM, refer to your P6 EPPM database administrator.

Users can only access custom URLs to access pages as long as they have Project module access and OBS access to projects and project templates.

Any P6 EPPM user can use a custom URL, as long as they have Project module access. If the user does not have access to the projects listed in the URL, P6 EPPM will open to the Open Projects dialog box.

To create a custom URL:

  1. Determine the base URL for your P6 EPPM instance.

    The base URL follows the format http://<server>:<port>/p6/bookmark?uri=navigatetopage&ctx=

    For example, http://corporatep6server:8203/p6/bookmark?uri=navigatetopage&ctx=

  2. Determine the wbs_ids of the projects that you want users to access by completing the following:
    1. Log in to the P6 EPPM database with the following script and provide the relevant password when prompted:

      sqlplus <admuser or privuser>@<db_tns_names_entry>

    2. Run the following scripts for the project wbs_ids:

      column wbs_short_name format a20

      column wbs_name format a30

      select pw.wbs_id, pw.proj_id, pw.wbs_short_name, pw.wbs_name from projwbs pw inner join project p on pw.proj_id=p.proj_id where pw.proj_node_flag = 'Y' and p.project_flag='Y' and orig_proj_id is null;

      Notes:

      • In addition to returning wbs_ids and proj_ids, the last line of the script also returns the wbs_short_name and wbs_name in order to provide you more context for each wbs_id and proj_id that you return.
      • By default, the wbs_short_name and wbs_name have a length of 40 and 100 characters respectively. The first two lines of the script reduce the displayed characters of the wbs_short_name and wbs_name to 20 and 30 characters respectively in order to prevent the column length from overtaking the output.
  3. Create a string of parameters and their values to describe the view. You must list the parameters in the order described in this step and separate the parameters with an ampersand. Do not include an ampersand after the last parameter. The parameters available are:
    • projectList: A comma-separated list of wbs_ids for the projects that you want to display.

      For example, 3165,65422,984&

    • key: Determines which page will be opened.

      Supported values: activities

      For example, key=activities&

    • (Optional) showNavigation: Determines whether to show the header bar when P6 EPPM opens. If this parameter is not included or it is set to true, P6 EPPM opens with the header bar. If this parameter is set to false, P6 EPPM opens without the header bar.

      Supported values: true or false

      For example, showNavigation=false

      Note: Your string should be similar to projectList=3165,65422,984&key=activities&showNavigation=false

  4. Percent-encode the string.

    For example, you could use URL Encoder/Decoder at http://meyerweb.com/eric/tools/dencoder/.

    Note: After you percent-encode your string, the string should be similar to projectList%3D3165%2C65422%2C984%26key%3Dactivities%26showNavigation%3Dfalse

  5. Append the string to the base URL.

    For example: http://corporatep6server:8203/p6/bookmark?uri=navigatetopage&ctx=projectList%3D3165%2C65422%2C984%26key%3Dactivities%26showNavigation%3Dfalse


Last Published Friday, February 2, 2024