| Table of Contents | ||||
|---|---|---|---|---|
|
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:
...
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.
...
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 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.
...
At the end of the link to the form is the RECID for that specific record.
...
Users with Admin Privileges have access to viewing RECIDs on a normal Grid. To get the RECID, click the
button and check the box for ROWID.
...
Here is the full list of what Admin Privileges allow for:
| Insert excerpt | ||||||
|---|---|---|---|---|---|---|
|
RECID vs. ROW ID
| Excerpt |
|---|
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.
There are several reasons both are used.
|