createorupdatewithcommonprocess
Reactive icon

CreateOrUpdateWithCommonProcess

Stable version 2.2.1 (Compatible with OutSystems 11)
Uploaded on 22 November 2022 by 
4.0
 (1 rating)
createorupdatewithcommonprocess

CreateOrUpdateWithCommonProcess

Details
This component provides some Actions to Create or Update data for any Entity. It has compatible with SQL Server and Oracle. この部品は任意のEntityに対してデータを新設/更新するためのActionを提供します。SQL ServerとOracleに対応しています。
Read more
  • It identifies the physical table name from the eSpace name and Entity name from the Input Parameter and uses the name for Create or Update.

  • When inputting multiple records, It sorts in ascending order by primary key to avoid deadlock.

  • If the primary key is the default value, CreateorUpdate Action implements Create. When creating multiple records, It inserts them all at once. At this time, CreatedOn, CreatedBy, UpdatedOn, and UpdatedBy of Entity are updated.

  • If the primary key is not the default value CreateorUpdate Action implements Update. At this time, It confirms that there is no difference in UpdatedOn, and if there is a difference, make an exclusive error. If there is no difference, the data will be updated. At this time, UpdatedOn and UpdatedBy of Entity are also updated.

Release notes (2.2.1)
  • Change the Action name
  • Bug fixed to UpdateListByPaticularValue and DeleteList
    • Enable to treat empty list
    • Enable to treat list that has more than 1,000 records
Reviews (0)