Retrieve User Extension Field Value By Object
    • 25 Sep 2024
    • 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