ramcomment

Defines a comment against any row in the database.

Syntax:

[ DynamicComponentDependency ] ramcomment RAMCommentName {
[ TimeSpanUOM ] [ TimeZoneOverride ] [ ChangeDetection ] [ CustomChangeHandler ] #SqlDml.QueryBlock ;
}

Mandatory columns

Column Name Data Type Description Default Value
id String(32) A unique id.
datetime Date The time the comment was added.
object_pk_name1 String(32) The column name of one of the primary key columns in this table.
object_pk1 String(32) The value of the column named above for this row.
object_type_id String(32) The name of the table that the row the comment applies to is in.

Optional columns

Column Name Data Type Description Default Value
comment String(2048) The comment.
object_pk_name2 String(32) The column name of one of the primary key columns in this table.
object_pk_name3 String(32) The column name of one of the primary key columns in this table.
object_pk_name4 String(32) The column name of one of the primary key columns in this table.
object_pk2 String(32) The value of the column named above for this row.
object_pk3 String(32) The value of the column named above for this row.
object_pk4 String(32) The value of the column named above for this row.
ram_rota_id String(32) The id of the rota that the comment applies to.
user_id String(256) The user making the comment. 


            ramcomment RAMComment {{SelectName}} {
               SELECT
                     ..                  id,
                     ..                  datetime,
                     ..                  object_pk_name1,
                     ..                  object_pk1,
                     ..                  object_type_id,
                  -- optional columns
                     ..                  comment_,
                     ..                  object_pk_name2,
                     ..                  object_pk_name3,
                     ..                  object_pk_name4,
                     ..                  object_pk2,
                     ..                  object_pk3,
                     ..                  object_pk4,
                     ..                  ram_rota_id,
                     ..                  user_id
               FROM {{sourceTableName}}
               WHERE ...;
            }

Note:   All selected columns must have correct aliases that match a IFS Scheduling RAMComment.

RAMCommentName

Syntax:

<Identifier>

This page is generated from IFS Developer Studio at 2021-08-13 08:49.