Document toolboxDocument toolbox

.How to get RECID values v2020.1

RECIDs can be accessed from several methods. The 'API', 'AdHoc Grids', Database query access, 'History Report', or 'Sharing' links can provide this information.  Make sure to consult the Data Dictionary to verify what application record contains the RECID needed.

API

Using the SQL Endpoint, Users can execute SQL queries that lookup a specific record.  Using a SELECT statement, Users can add the RECID column to the list of fields to see for your SELECT.  The return response from the API will look something like:

{
    "status": "success",
    "page": "1",
    "count": 1,
    "total_count": "1",
    "results": {
            "RECID": "433",
            "TENANTS_RECID": "0",
            "MODIFIED_DATE": "2018-01-16 15:30:48",
            "MODIFIED_BY": "00137148",
            "USERID": "01178496",
            "CONTACTS_RECID": "21945"
        },
	"debug": {
        "APIKEY": "gXafmC5zgTv4VRI4GvXdyd7x2lmWmCQJ",
        "TYPEFORMAT": "sql.json",
        "SQL": "SELECT RECID, TENANTS_RECID, MODIFIED_DATE, MODIFIED_BY, USERID, CONTACTS_RECID FROM USERS WHERE USERID = '01178496'",
        "request_method": "POST",
        "LIMIT": "20",
        "PAGE": "1",
        "TENANTS_RECID": "0",
        "type": ""
    }
}


AdHoc Grids

Using an AdHoc Grid Users can use the Query Builder to construct an SQL Query to find the RECID you need.  All Tables have a RECID column to identify each record of that table.

AdHoc Grid Example

Database Query Access

Using the Organization's Database Access Client (such as HediSQL or Oracle SQL Developer) Users can connect to the Database directly, and construct the SQL Query to look up the RECID needed.

History Report

When accessing the 'History Report' Menu Option on a Form, a User can find the RECID at the top of the page.  The History Report calls out the RECID as the 'Record ID'.

Options Menu Example

History Report Example

PCR-360 allows Users to share specific records to other authorized Users by the use of direct links to the record in question. Open the Options Menu on the Form, and select the "Get Link" Option.

Get Link Form Example

At the end of the link to the form is the RECID for that specific record.

Admin Access

Users with Admin Privileges have access to viewing RECIDs on a normal Grid. To get the RECID, click the Grid Preferences button and check the box for ROWID.

Arrage Columns example image


Here is the full list of what Admin Privileges allow for:

Simple Admin only Items:

  • Access to Form Permission Builders
  • Access to Grid Permission Builder
  • Access to the Ad hoc Query Builder
  • Ability to create Global Events in the Calendar
  • Access to all Historical Crystal Reports (deprecated)
  • Ability to Assign/Edit Historical Crystal Reports (deprecated)
  • Ability to Add Crystal Reports to a Form (deprecated)
  • Access to all Saved Custom Reports
  • Ability to Assign/Edit Saved Custom Reports
  • Ability to Add Custom Reports to a Form
  • Ability to Add Custom Reports to a Grid
  • Ability to Edit the Menu
  • Ability to Approve Knowledge Base Articles
  • Ability to Delete Service Desk Actions
  • Access to the Manage Reports link on the form Options menu
  • Access to the Manage Validation link on the form Options menu
  • Ability to display RECIDs on grids

Additional Items that depend on a Configuration Option:

RECID vs. ROW ID

The usage of RECID or ROW ID is for clarity about what the RECID or ROW ID represents.

ROW IDs - Row Identification Numbers (ROW IDs) are unique IDs to the row of data in the grid they're assigned to. Some grids do not have a RECID but all grids have ROW IDs.

RECIDs - Record Identification Numbers (RECIDs) are unique IDs for records within a given table. When a grid references a specific record from a table, the Table Name is usually the column name of the RECID that the grid is referencing.

  1. IE: SERVICES_RECID in any given grid is referencing the RECID value from the SERVICES Table.
  2. Some table names are long and need to be abbreviated to meet the 30 character limit imposed by Oracle Databases.

There are several reasons both are used. 

  1. Some grids have multiple RECIDs and a ROW ID is unique to that row of data in the grid.
  2. Some grids don’t have a RECID and the ROW ID is unique to that row of data.
  3. Some ROW IDs are actually combined RECIDs for two or more records in the row.

Help Desk Portal - Email: help@pcr.com - Phone: 616.259.9242