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" } ) )
Discussion posts and replies are publicly visible
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 cedric01 ,
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.
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