How is your experience with the OutSystems Community?
record-manipulation
Service icon

Record Manipulation

Stable version 2.0.0 (Compatible with OutSystems 11)
Other versions available for 10 and Older
Uploaded
 on 29 Oct (23 hours ago)
 by 
5.0
 (4 ratings)
record-manipulation

Record Manipulation

Details
Record Manipulation Extension. Get and Set the Value of a Path in any Record - can be a complex record with different structures and entities. Also get and set values of child RecordLists.
Read more
Record Manipulation Extension
 
Get and Set the Value of a Path in any Record - can be a complex record with different structures and entities - in a programmatically way, instead of having it hard-coded with long list of assigns or big switch selections.
Also get and set values of child RecordLists.
  • Access the Record Values by its Path, that can be defined in run-time:
    • "Name"
    • "Child.Name"
    • "ChildList.Current.Name"
    • "ChildList[1].Name"
  • Set Values of Records in a RecordList by its Path and Position
  • Set Values of the Current Record in a RecordList by its Path

Download an example of its use here:

Heavily based on the excellent SortRecordList extension.


Notice: This component takes advantage of private and undocumented Platform APIs, which can change without notice. As a result, this component may unexpectedly break as the Platform is upgraded. We advise proper testing to ensure that your applications continue to work as expected when upgrading/patching the Platform.

Release notes (2.0.0)

Breaking changes

  • Renamed GetRecordPathAttributes to GetRecordAttributes, and removed its Found and Message outputs. It now raises an exception when Record is empty.
  • Renamed the Message output to ErrorMessage in GetRecordPathValue, GetRecordPathStringValue, SetRecordListCurrentPathValue and SetRecordListPositionPathValue.
  • Renamed the Found output to IsSuccessful in SetRecordListCurrentPathValue and SetRecordListPositionPathValue.


New

  • GetRecordTypeName: returns the name of a record's entity or structure, for example "Customer".
  • GetRecordSSKey: returns the key of a record's entity and of the module or extension that defines it, as lowercase GUIDs, so you can look the entity up in the platform's metadata. Accepts an entity record, the record of a single entity, or a list of either.


Fixes

  • Paths into a child list, such as "ChildList.Current.Name" and "ChildList[1].Name", returned Found = False. The entity or structure name after a list is now optional, as it already was at the start of a path.
  • SetRecordListPositionPathValue ended the iteration of a For Each over the same list. It now returns IsSuccessful = False with an error message, and the For Each keeps running.
  • ErrorMessage no longer includes a .NET stack trace.
License (2.0.0)
Reviews (2)
by 
2019-06-25
in version 1.3.0
Really useful for exporting selected data from a list!
by 
2019-01-25
in version 1.3.0
Very useful to manipulate JSON strings and replace some portion of the elements into another values.
Team
Other assets in this category