Read Notes Formula

Operation Name

Read Notes Formula

Function overview

Read the data using Notes formula.

Data Model

Data model of this type of component is table model type.

Properties

For information about using variables, refer to "variables".
Basic settings
Item name Required/Optional Use of Variables Description Remarks
Name Required Not available Enter the name on the script canvas.  
Required settings
Item name Required/Optional Use of Variables Description Remarks
Destination Required Not available Select Global Resources.
Refer to "Global Resource Properties" for global resource settings .
  • [Add]:
    Adds new global resource.
  • [Edit list]:
    Global resource settings can be managed from "Edit Resource list".
  
Form name Required Available Select or enter a form name.
  • If a script variable is specified, [Field definition] is left unconfigured.
Field definition Required - Display the field definition of the form specified in [Form name].  
Field definition / Field name Required Available Enter the name of the field.
By default, the field name in the specified form is set.		  
Field definition / Type Required Not available Select the type of the field.
By default, the field type in the specified form is set.
  • [string]
  • [datetime]
  • [double]
Notes formula Required Available Enter expression language of Notes/Domino .
  • SELECT reserved words and @ expressions you can use a combination of functions.

    Setting example:
    Notes formula Description
    SELECT @All Search for all documents in a database, then get the document in the form specified at [Form name].
    SELECT Form = "<form name>" <Form name> only gets in the form specified in the document.
    [Form name] must be specified in the form set.)
    SELECT @Created = @Today Get the document of which date of created is today.
    About @ function, please refer to Notes help.
Maximum number of retrieved documents Optional Available Enter the number of documents to retrieve.
  • The default value is "0". "0" is set when omitted.
  • If "0" is specified, gets all documents in the form.
  • If the specified value exceeds the number of all documents in the form, gets all the documents in the form.
Delimiter Required Available Enter the delimiter of multiple values.
  • Delimiters of multiple values can be specified freely.
  • The default value is ",".
  • Multiple values can only be retrieved when the type of the field is "text".
Get attachment Optional Not available Select whether to get the attachments in Notes document.
  • [Checked]: (default)
    Get an attachment in Notes document.
  • [Not Checked]:
    Do not get the attachment in Notes document.
  
Destination to save attachment Required Available Select or input directory to save the attached file in the document.

Click [Browse] button to activate the file Selectr and Select the directory.
  • [Get attachment] if you check to enable.
  • The default value is "/tmp".
  • Please specify the absolute path of the DataSpider file system as the file path.
  • Constrained Characters of DataSpider File System cannnot be used, except for the path separator "/"..
Property Action
Item name Description Remarks
Reset forms and fields Resets the form list of [Form name] and [Field definition].
  • If any form or field is added or modified by Domino Designer, the change can be reflected by using this property action.
    The change of form or field is only reflected in this operation.
Data processing method
Item name Required/Optional Use of Variables Description Remarks
Mass data processing Required Not available Select a data processing method.
  • [Use script settings]: (default)
    Apply mass data processing settings of script property to adapter.
  • [Disable]:
    Mass data processing is not performed.
  • [Enable]:
    Mass data processing is performed.
  
Comment
Item name Required/Optional Use of Variables Description Remarks
Comment Optional Not available You can write a short description of this adapter.
The description will be reflected in the specifications.		  

Schema

Input Schema

None.

Output Schema

<?xml version="1.0" encoding="UTF-8" ?>
&lt;table&gt;
  &lt;row&gt;
    <column>UniversalID</column>
    <column>NoteID</column>
    <column>Field data</column>
    :
  &lt;/row&gt;
  &lt;row&gt;
    :
  &lt;/row&gt;
</table>

Loading schema in Mapper

Schema is loaded automatically.
See "Edit Schema"for any details .

Mass data processing

Mass data processing is supported.

PSP Usage

PSP is not supported.

Available Component variables

Component variable name Description Remarks
count Returns the number of read data.
  • The value defaults to null.
message_category Stroes the category to which corresponding message code belongs to, when an error occurs.
  • The value defaults to null.
message_code Stores its corresponding message code of occured error.
  • The value defaults to null.
message_level Stores the severity of the corresponding message code of the occured error.
  • The value defaults to null.
error_type Stores the type of the occured error.
  • The value defaults to null.
  • Error is represented in the format depicted below.
    Example:java.io.FileNotFoundException
  • The message may vary depending on DataSpider Servista version.
error_message Stores the error message for the occured error.
  • The value defaults to null.
  • The message may vary depending on DataSpider Servista version.
error_trace Stores stack trace of the occurred error.
  • The value defaults to null.
  • The message may vary depending on DataSpider Servista version or the client application used.

Operation of Type Conversion

Operations of type conversion when specifying [Type] in [Field definition] are as follows.

[Type] Operation Remarks
[string]
  • Convert all fields regardless of field types into the String type and read.
 
[datetime]
  • If the field type is "Numeric type", convert the field into the Date type and read.
  • Cannot read if field type is "text" and cannot be converted to Double type.
  • e.g.) If data read from the field is "1", it will be converted into "1970-01-01T09:00:00.001+0900" (when the time zone is set to the Japanese Standard Time).
[double]
  • If the field type is "Date/time", convert the long value stored in data into the Double type and read.
  • Cannot read if field type is "text" and cannot be converted to Double type.
  • e.g.) If data read from the field is "1970-01-01T09:00:00.001+0900", it will be converted into "1" (when the time zone is set to the Japanese Standard Time).

Specification Limits

Main exceptions

Exception name Cause Solution
ResourceNotFoundException
Resource definition could not be found.Name: []		 [Destination] is not specified. Specify [Destination].
ResourceNotFoundException
Resource definition could not be found.Name: [<name of Global Resources>]		 Resource definition specified in [Destination] is not found. Check the global resource specified in [Destination].
InvalidPropertyConfigurationException
Property "<property name>" value "" is incorrect.		 [<Property name>] is not specified. Specify the [<Property name>].
InvalidPropertyConfigurationException
Given <property name> "<value of the property>" not found.		 [<Property Name>] not found in the specified property value. [<Property Name>] Please check the value of the property specified.

Notes