READPICTNOTES

Function

The action reads the notes according to the specified criteria.

Declaration

READPICTNOTES _bt, _et, _pictName, _pictDesc, _userName, _notes

Parameters

_bt, _et

in

Identifiers of the AbsTime type - defines a time interval for records selection.

_pictName

in

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.

_pictDesc

in

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.

_userName

in

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.

_notes

out

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

Types and meaning of individual columns:

noteUUID	String
picture_name	String
valid	Boolean
bt	AbsTime
et	AbsTime
text	String
create_author	Text
create_time	AbsTime
last_modified_author	Text
last_modified_time	AbsTime

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