Retrieve User Extension Field Value By Object
  • 27 Feb 2025
  • 1 Minute to read
  • Dark
    Light

Retrieve User Extension Field Value By Object

  • Dark
    Light

Article summary

Get
/sys-rest-api/rest/1/sdobjusrextvalue

Query Standards

Finder

Following row finders are available for data filtering and optimizing request performance.

  • Select by SdObjUsrExtValueFinder
  • Select by FragmentUevCodeFinder
  • By UUID

Select by SdObjUsrExtValueFinder

Recommended finder parameters. Refer to Query Parameters for example.

ParameterDescriptionSample
TableNameTable NamePMPROJECT_TABLE
AuditDateAudit Date2015-01-01
SchemaNameSchema NameDA
ObjectKey1ObjectKey 1001
ObjectKey2ObjectKey 214001

Select by SdObjUsrExtValueFinder

This is the optional finder for querying User Extension Field Value by UEV Codes.

ParameterDescriptionSample
UevCode1VarUev Code 1user defined
UevCode2VarUev Code 2user defined
UevCode3VarUev Code 3user defined
UevCode4VarUev Code 4user defined
.........

By UUID

This is an optional finder for querying a specific User Extension Field Value by row ID.

ParameterDescriptionSample
/VUUIDThe VUuid attribute is the Unique row ID/sys-rest-api/rest/1/uevalidfielddata/F291FEBDBFFF282FE05316821FAC71D4
Security
HTTP
Type basic

Basic authentication

Query parameters
finder
string
ExampleSdObjUsrExtValueFinder; TableName=PMPROJECT_TABLE, AuditDate=2015-01-01, SchemaName=DA, ObjectKey1=001, ObjectKey2=14001
limit
integer
Example500
offset
integer
Example0
totalResults
boolean
ExampleTrue
orderBy
string
ExampleevUedSchemaName:desc
Responses
200

Successful response