From f7ea16cd2801031de80cda82b7a92027e649e6f1 Mon Sep 17 00:00:00 2001 From: colemanw Date: Tue, 12 Sep 2023 14:29:40 -0400 Subject: [PATCH] Add missing Note metadata for FormBuilder --- CRM/Core/DAO/Note.php | 23 +++++++++++++++++++++-- xml/schema/Core/Note.xml | 21 ++++++++++++++++++++- 2 files changed, 41 insertions(+), 3 deletions(-) diff --git a/CRM/Core/DAO/Note.php b/CRM/Core/DAO/Note.php index c126f61b2e..51aad849cc 100644 --- a/CRM/Core/DAO/Note.php +++ b/CRM/Core/DAO/Note.php @@ -6,7 +6,7 @@ * * Generated from xml/schema/CRM/Core/Note.xml * DO NOT EDIT. Generated by CRM_Core_CodeGen - * (GenCodeChecksum:5b5ae6f3bd3ed46257a0b0f3e9b9075b) + * (GenCodeChecksum:aa7f2dd9a225bafdc5c551d869dfae8a) */ /** @@ -211,6 +211,10 @@ class CRM_Core_DAO_Note extends CRM_Core_DAO { 'entity' => 'Note', 'bao' => 'CRM_Core_BAO_Note', 'localizable' => 0, + 'html' => [ + 'type' => 'Select', + 'label' => ts("Reference Type"), + ], 'pseudoconstant' => [ 'optionGroupName' => 'note_used_for', 'optionEditPath' => 'civicrm/admin/options/note_used_for', @@ -234,6 +238,10 @@ class CRM_Core_DAO_Note extends CRM_Core_DAO { 'entity' => 'Note', 'bao' => 'CRM_Core_BAO_Note', 'localizable' => 0, + 'html' => [ + 'type' => 'EntityRef', + 'label' => ts("Reference Item"), + ], 'add' => '1.1', ], 'note' => [ @@ -281,6 +289,7 @@ class CRM_Core_DAO_Note extends CRM_Core_DAO { 'localizable' => 0, 'FKClassName' => 'CRM_Contact_DAO_Contact', 'html' => [ + 'type' => 'EntityRef', 'label' => ts("Created By"), ], 'add' => '1.1', @@ -326,12 +335,17 @@ class CRM_Core_DAO_Note extends CRM_Core_DAO { 'entity' => 'Note', 'bao' => 'CRM_Core_BAO_Note', 'localizable' => 0, + 'html' => [ + 'type' => 'Select Date', + 'formatType' => 'activityDateTime', + ], + 'readonly' => TRUE, 'add' => '5.36', ], 'modified_date' => [ 'name' => 'modified_date', 'type' => CRM_Utils_Type::T_TIMESTAMP, - 'title' => ts('Note Modified By'), + 'title' => ts('Note Modified Date'), 'description' => ts('When was this note last modified/edited'), 'usage' => [ 'import' => FALSE, @@ -345,6 +359,11 @@ class CRM_Core_DAO_Note extends CRM_Core_DAO { 'entity' => 'Note', 'bao' => 'CRM_Core_BAO_Note', 'localizable' => 0, + 'html' => [ + 'type' => 'Select Date', + 'formatType' => 'activityDateTime', + 'label' => ts("Modified Date"), + ], 'readonly' => TRUE, 'add' => '1.1', ], diff --git a/xml/schema/Core/Note.xml b/xml/schema/Core/Note.xml index 87f9b45f65..574d62dfce 100644 --- a/xml/schema/Core/Note.xml +++ b/xml/schema/Core/Note.xml @@ -30,6 +30,10 @@ 64 true Name of table where item being referenced is stored. + + + Select + note_used_for @@ -39,6 +43,10 @@ entity_id Note Entity ID int unsigned + + + EntityRef + true Foreign key to the referenced item. 1.1 @@ -76,6 +84,7 @@ FK to Contact ID creator + EntityRef 1.1 @@ -104,14 +113,24 @@ When the note was created. true CURRENT_TIMESTAMP + + Select Date + activityDateTime + 5.36 + true modified_date - Note Modified By + Note Modified Date timestamp When was this note last modified/edited CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP + + + Select Date + activityDateTime + 1.1 true -- 2.25.1