Function GetNotes
Gets secure notes for a record as a string.
This functions also allows additional notes data to be added to this returned data.
GetNotes([TABLE],[FIELD],[VALUE],[ADD_BREAKER],[APPEND_NOTES],[APPEND_SEPARATOR])Parameters
| # | Type | Passing | Default | Name | Description/Comments | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | string | required | n/a | TABLE | The table name to get secure notes from | ||||||||
| 2 | string | required | n/a | FIELD | The table field to get secure notes from | ||||||||
| 3 | string | required | n/a | VALUE | The key field value to get the notes for e.g. PROPCODE, CONCODE or CONREF
| ||||||||
| 4 | boolean | optional | false | ADD_BREAKER | Set to true to add the timestamp and user information above each notes entry. | ||||||||
| 5 | string | optional | blank | APPEND_NOTES | Pass in an additional notes field to add to the end of this date e.g. NOTES. This may be required if there are additional notes stored in the NOTES field before secure notes were switched on and they need to be include in this returned data. | ||||||||
| 6 | string | optional | n/a | APPEND_SEPARATOR | The separator to use between the returned notes and the append notes field. |
Returns
The string required
Examples
Will get the secure notes for the NOTES against the property record for PROPCODE.
{{GetNotes("PROPERTY","NOTES",ALIAS.PROPCODE)}} Will get the secure notes for the NOTES against the property record for PROPCODE and add the NOTES field data too.
{{GetNotes("PROPERTY","NOTES",ALIAS.PROPCODE,false,ALIAS.NOTES,"\r")}} Will get the secure notes for the NOTES against the property record with timestamp and user information above each entry.
{{GetNotes("PROPERTY","NOTES",ALIAS.PROPCODE,true)}} 
