.How to get RECID values v2019.4

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 look up 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.

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'.

Form Link

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

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 REC IDs on a normal Grid. To get the RED ID, click the  and check the box for ROW ID.

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:

• Ability to Manually edit charges - MODIFY_CHARGES_WITHOUT_SERVICE_DESK
• Ability to Modify Serial Numbers on Equipment - MODIFY_SERIAL_NUMBER
• Ability to Edit Remarks - REMARKS_EDITABLE
• Ability to Override Billing Groups on Services - MODIFY_CHARGES_WITHOUT_SERVICE_DESK
• Ability to Complete/Delete workflow with configuration specifies - SD_WORKFLOW_PERMISSIONS