READPICTNOTES

Function

The action reads the notes according to the specified criteria.

Declaration
 READPICTNOTES _bt, _et, _pictName, _pictDesc, _userName, _notes
Parameters
_bt, _etinIdentifiers of the AbsTime type - defines a time interval for records selection.
_pictNamein

Identifier of the String type - represents the condition for records loading. It loads only records with the attribute "Name" which match the mask which is entered in the parameter name.
If the input value is invalid, this condition is ignored.

_pictDescin

Identifier of the String type - represents the condition for records loading. It loads only comments assigned to schemas whose description matches the mask specified by the _pictDesc parameter.
If the input value is invalid, this condition is ignored.

_userNamein

Identifier of the String type - represents a mask (condition) for loading notes. Loads only comments created by users whose names match the mask specified by the _userName parameter.
If the input value is invalid, this condition is ignored.

_notesout

Identifier of the whole local structure - however, the structure must contain exactly 10 columns.


Types and meaning of individual columns:

noteUUID  String
picture_nameString
validBoolean
btAbsTime
etAbsTime
textString
create_authorText
create_timeAbsTime
last_modified_authorText
last_modified_timeAbsTime
Príklad
PROCEDURE ReadNotes
  TEXT _userName
  TEXT _pictName
  TEXT _pictDesc
  TIME _bt, _et
  RECORD NOALIAS (SD.PICTNOTE) _notes
  
  _userName := ""
  _pictName := ""
  _pictDesc := ""
  _bt := SysTime
  _bt := %TimeFromItems(%Year(_bt), %Month(_bt), %Day(_bt), 0, 0, 0, 0)
  _et := %TimeFromItems(%Year(_bt), %Month(_bt), %Day(_bt)+1, 0, 0, 0, 0)
  
  READPICTNOTES _bt, _et, _pictName, _pictDesc, _userName, _notes

END ReadNotes

Related pages:

Actions in scripts

Napíšte komentár