How to update a recordType records with updateDictionary/update functions?

Certified Senior Developer

Hi,

I've already used the updatedictionary and update functions with CDT, but how it works with RecordType? Could you show me the correct syntax please ?

/* works fine with CDT */
  local!dataVehicles: a!queryEntity(...),

  local!vehicles: a!forEach(
    items: local!dataVehicles,
    expression: a!update(
      data: fv!item, 
      index: {
        "id",
        "model"
      }, 
      value: {
        1,
        fv!item.model
      }
    )
  )
  
/* does not work */
  local!dataVeh: a!queryRecordType(
    recordType: 'recordType!Vehicles',
    fields: {
      'Vehicles.fields.id',
      'Vehicles.fields.model'
    },
    pagingInfo: a!pagingInfo(startIndex: 1, batchSize: 500)
  ).data,

  local!vehicles: a!forEach(
    items: local!dataVeh,
    expression: a!update(
      data: fv!item['recordType!Vehicle'], 
      index: {
        'recordType!Vehicle.fields.id',
        'recordType!Vehicle.fields.model'
      }, 
      value: { 
        1,
        fv!item.model
      }
    )
  )
  
/* Does not work */
  local!vehicles: a!forEach(
    items: local!dataVeh,
    expression: updatedictionary(
      dictionary: fv!item['recordType!Vehicle'], 
      fieldsAndValues: {
        fv!item['recordType!Vehicle.fields.id']: 1,
        fv!item['recordType!Vehicle.fields.model']: "my model"
      }
    )
  )


Best regards

  Discussion posts and replies are publicly visible

Parents
  • +1
    Certified Senior Developer

    local!vehicles: a!forEach(
        items: local!dataVeh,
        expression: a!update(
          data: fv!item, 
          index: {
            'recordType!Vehicle.fields.id',
            'recordType!Vehicle.fields.model'
          }, 
          value: { 
            1,
            fv!item.model
          }
        )
      )

    Hi  ,

    for the second case, you can directly use fv!item instead of indexing record type in data parameter of index function to update the value.


    For third case, updateDictionary function will only work for dictionary/cdt types.

  • 0
    Certified Senior Developer
    in reply to Kiran

    You're right : fv!item works fine.

    Now, the last issue I have is on : fv!item.model,

    value: {
      1,
       fv!item.model
    }

    Appian needs a RecordType notation so I've changed it with : fv!item['recordType!Vehicles.fields.model'] 
    and all is fine now :-)

    Thanks, a lot

Reply Children
No Data