AgileApps Support Wiki Pre Release

Difference between revisions of "Record Id"

From AgileApps Support Wiki
imported>Aeric
imported>Aeric
 
(One intermediate revision by the same user not shown)
Line 2: Line 2:
A record ID is a unique value used to access and update data. Record IDs can appear as: <tt>id,  record_id, or recordId</tt>, depending on the tool. The record ID is used in [[API]]s and some [[Expressions#Formula_Expressions|Formula Expressions]].  
A record ID is a unique value used to access and update data. Record IDs can appear as: <tt>id,  record_id, or recordId</tt>, depending on the tool. The record ID is used in [[API]]s and some [[Expressions#Formula_Expressions|Formula Expressions]].  


Typically, the record ID is stored in a record's <tt>id</tt> field. Those fields generally are not displayed in common [[Views]] or [[Reports]], but the field can be added by customizing the particular view or report.  
Typically, the record ID is stored in a record's <tt>id</tt> field. Those fields generally are not displayed in common [[Views]] or [[Reports]].
<noinclude>
<noinclude>
:''See also:''
:''See also:''
Line 8: Line 8:
::*[[Session Identifier]]
::*[[Session Identifier]]
</noinclude>
</noinclude>
==Get a Record Identifier from the Platform UI==
#Open the tab for the object of interest
#Click the down arrow next to the name of the current view ([[File:DownArrowIcon.png]])
#Click '''[Edit]'''
# In the Fields tab, select the <tt>ID</tt> field in the Available Fields list, and move it to the Selected Fields list.<br>(Each selected field becomes a column in the resulting view.)
#Save the view
{{Note|<br>This option is available only for views that have a sidebar.}}


==Get a Record ID Programmatically==
==Get a Record ID Programmatically==

Latest revision as of 09:01, 4 April 2017

A record ID is a unique value used to access and update data. Record IDs can appear as: id, record_id, or recordId, depending on the tool. The record ID is used in APIs and some Formula Expressions.

Typically, the record ID is stored in a record's id field. Those fields generally are not displayed in common Views or Reports.

See also:


Get a Record ID Programmatically

Record IDs can be obtained using:

In the REST APIs, the record ID is stored in the id field.

To get a record ID using the Java APIs: Field values are stored in the Parameters object that is delivered to code that is running in the platform.

  • To get the ID of the record in that object, use the get method on that object, specifying 'id' as the name field to get.
  • A field of type Lookup stores the Record ID for the object it points to. To retrieve the record ID it contains, use the get specifying 'field _name' (the name of the field, in single quotes) as the field to get.
Considerations
  • Record Identifier has a Range of: 1 - 2,147,483,647
  • In most Objects, the record id is an integer
  • Exception:In these objects, the record ID is a text string:
  • Lookup fields require a string value.
To convert a numeric Record ID to a string, use the CONCAT Formula Function:
CONCAT (id, '')
    where: 
          id is a Record Identifier
          '' is two single quote (') characters