AppSuite (Additional)

Connection Settings

Connection settings are information for connecting to AppSuite.

Example

url=http://sample/dneo.cgi
basic_auth_userid=sampleid
basic_auth_password=samplepass
proxy_host=samplehost
proxy_port=1234
proxy_auth_userid=proxyid
proxy_auth_password=proxypass

Enter the following information in the key=value format.

Key	The specified value	Description
url	[URL of desknet's NEO]	Be sure to specify it. Describe the URL of desknet's NEO.
basic_auth_userid	[Basic authentication user ID]	Specify when using Basic authentication when logging in to desknet's NEO. This item is not required if Basic authentication is not performed.
basic_auth_password	[Basic authentication password]
proxy_host	[Proxy server host name]	Specify when using a proxy server at desknet's NEO. If you do not use a proxy server, this item is not required.
proxy_port	[Proxy server port number]
proxy_auth_userid	[Proxy Authentication User ID]	Specify when using proxy authentication at desknet's NEO. If you do not use proxy authentication, this item is not required.
proxy_auth_password	[Proxy Authentication Password]

* You cannot access the desknet's NEO server with a combination of HTTPS and proxy authentication.

Parts Setting

Set the parts to be processed and the order.

Example

[
  { "field_name": “Responsible"},
  { "field_name": ""},
  { "field_name": “Client"}
]

Enter the following information in json format (key and value pairs enclosed in {}).

Key	The specified value	Description
field_name	[Target part name]	Be sure to specify it.” Describe the target part name in "field_name".

Narrowing Conditions

Example

{
"item": [
  {"field_id": "101", "operator": ">=", "value": "1"},
  {"field_id": "102", "operator": "is_null"},
  {"field_id": "103", "operator": "contains", "value": " 1\t2 ", "type":" id"}
] }
}

Please specify the search condition array in "item".
If there are multiple specified search conditions, AND search is executed.
The information to be entered in the search conditions is as follows.

Key	The specified value	Description
field_id	[Part ID to search]	Be sure to specify it. Specify the ID of the part to be searched. You can check the component ID in [Application Settings> Component Management].
operator	[= \| ! = \| &gt \| &gt= \| &lt \| &lt= \| includes \| not_includes \| starts_with \| ends_with \| contains \| not_contains \| is_null \| is_not_null \| matches]	Be sure to specify it. Specify the search method.
value	[Value to search for]	Specify the value to search for. If the value to be searched includes the following characters, please convert and enter as follows. (Tabs are used as delimiters when specifying multiple conditions.) (タブ) → \t \ → \\ " → \"
type	[id \| textbox \| number \| date \| datetime \| interval \| field_id]	Specifies the type of value to search for.

[List of search condition combinations]
The combination of "operator", "value" and "type" of the component specified by "field_id" is described below.
In order to specify the search conditions, it is necessary to combine the values of "operator", "value", and "type" for each component type specified in "field_id". The combinations that can be specified are as follows.

Part type	operator	value	type
[Data ID]	= (equal to)	Any integer greater than or equal to 0	(no input)
Text (1 Line)	= (match)	Any character	(no input)
	! = (does not match)	Any character
	includes (includes \| includes either)	Arbitrary characters (multiple delimited by tab delimiters)
	not_includes (does not include \| neither)	Arbitrary characters (multiple delimited by tab delimiters)
	starts_with	Any character
	ends_with (finished)	Any character
	is_null (not entered)	(no input)
Text (Multi Line) Rich Text	includes (includes \| includes either)	Arbitrary characters (multiple delimited by tab delimiters)	(no input)
	not_includes (does not include \| neither)	Arbitrary characters (multiple delimited by tab delimiters)
	is_null (not entered)	(no input)
Radio Button Pull Down	= (matches either)	Choice value (multiple values can be specified by separating with tab)	(no input)
	! = (neither match)
	is_null (not entered)	(no input)
Checkbox list box	contains (contains either)	Choice value (multiple values can be specified by separating with tab)	(no input)
	not_contains (neither is included)
	is_null (not entered)	(no input)
Number	= (equal to)	Numerical values that can be entered in number parts	(no input)
	! = (not equal)
	<(less than)
	<= (less than)
	> (greater than)
	>= (or more)
	is_null (not entered)	(no input)
Date	= (equal to)	-"Yyyy", "yyyy-MM", or "yyyy-MM-dd" format Example: " 2018 ", " 2018-01 ", " 2018-01-10 " ・"[+\|-]n days", "[+\|-]n months: [\|1-31\|e]", "[+\|-]n years: [ 1-12 ]: One of the formats [\|1-31\|e]" Example: " +3 days" (3 days after today) Example: " -1 months:10" (10th of last month) Example: " +1 months:*" (any day in the next month) Example: " -2 years:3:e" (the end of March two years ago)	(no input)
	! = (not equal)
	<(previous)
	<= (previous)
	> (after)
	>= (and later)
	= (equal to)	ID of the part to compare	field_id
	! = (not equal)
	<(previous)
	<= (previous)
	> (after)
	>= (and later)
	is_null (not entered)	(no input)	(no input)
[Date/Time Added] [Date/Time Updated] Date and time	= (equal to)	-"Yyyy", "yyyy-MM", "yyyy-MM-dd", "yyyy-MM-ddThh", "yyyy-MM-ddThh:mm" format Example: " 2018", "2018-01", "2018-01-10", "2018-01-10T09","2018-01-10T09:30" ・"[+\|-]n days", "[+\|-]n months: [\|1-31\|e]", "[+\|-]n years: [ 1-12 ]: One of the formats [\|1-31\|e]" Example: " +3 days" (3 days after today) Example: " -1 months:10" (10th of last month) Example: " +1 months:*" (any day in the next month) Example: " -2 years:3:e" (the end of March two years ago)	(no input)
	! = (not equal)
	<(previous)
	<= (previous)
	> (after)
	>= (and later)
	= (equal to)	ID of the part to compare	field_id
	! = (not equal)
	<(previous)
	<= (previous)
	> (after)
	>= (and later)
	is_null (not entered)	(no input)	(no input)
Times of Day	= (equal to)	"hh:mm"の形式	(no input)
	! = (not equal)
	<(previous)
	<= (previous)
	> (after)
	>= (and later)
	is_null (not entered)	(no input)
Attachment Files	includes (include in file name)	Any character	(no input)
	matches (included in text in file name/attachment)	Any character
	is_not_null (file exists)	(no input)
	is_null (file does not exist)	(no input)
Auto Calculation	= (match)	Any character	textbox
	! = (does not match)	Any character
	includes (includes \| includes either)	Arbitrary characters (multiple delimited by tab delimiters)
	not_includes (does not include \| neither)	Arbitrary characters (multiple delimited by tab delimiters)
	starts_with	Any character
	ends_with (finished)	Any character
	= (equal to)	Numerical values that can be entered in number parts	number
	! = (not equal)
	<(less than)
	<= (less than)
	> (greater than)
	>= (or more)
	includes	Any character
	= (equal to)	-"Yyyy", "yyyy-MM", or "yyyy-MM-dd" format Example: " 2018 ", " 2018-01 ", " 2018-01-10 " ・"[+\|-]n days", "[+\|-]n months: [\|1-31\|e]", "[+\|-]n years: [ 1-12 ]: One of the formats [\|1-31\|e]" Example: " +3 days" (3 days after today) Example: " -1 months:10" (10th of last month) Example: " +1 months:*" (any day in the next month) Example: " -2 years:3:e" (the end of March two years ago)	date
	! = (not equal)
	<(previous)
	<= (previous)
	> (after)
	>= (and later)
	includes (including)	Any character
	= (equal to)	-"Yyyy", "yyyy-MM", "yyyy-MM-dd", "yyyy-MM-ddThh", "yyyy-MM-ddThh:mm" format Example: " 2018", "2018-01", "2018-01-10", "2018-01-10T09","2018-01-10T09:30" ・"[+\|-]n days", "[+\|-]n months: [\|1-31\|e]", "[+\|-]n years: [ 1-12 ]: One of the formats [\|1-31\|e]" Example: " +3 days" (3 days after today) Example: " -1 months:10" (10th of last month) Example: " +1 months:*" (any day in the next month) Example: " -2 years:3:e" (the end of March two years ago)	datetime
	! = (not equal)
	<(previous)
	<= (previous)
	> (after)
	>= (and later)
	includes (including)	Any character
	= (equal to)	Any integer (converted to seconds)	interval
	! = (not equal)
	<(previous)
	<= (previous)
	> (after)
	>= (and later)
	includes (including)	Any character
	is_null (not entered)	(no input)	(no input)
[Added By] [Updated By] Select User	contains (contains either)	User system ID (You can specify multiple tab-delimited)	id
	not_contains (neither is included)	User system ID (You can specify multiple tab-delimited)	id
	is_null (not entered)	(no input)	(no input)
Select Group	contains (contains either)	Group system ID (Multiple can be specified by separating with tab)	id
	not_contains (neither is included)		id
	is_null (not entered)	(no input)	(no input)

Sample 1

Search conditions that include "Installation cost" or "Cloud" in the total evaluation and the number of minimum contract months is less than "12"

{
"filter": {
  "item": [
   {"field_id": "101", "operator": "includes", "value": "Installation cost\t cloud"},
   {"field_id": "102", "operator": ">", "value": " 12 "}
  ]
}
}

Parts used in the sample

Part ID (field_id)	Part type	Part name
101	Text (Multi Line)	総評
102	Number	Minimum contract months

Sample 2

Search condition in which the department system ID of the department in charge is "3" or "4" and the number of sales results (auto calculation) is "1000000" or more

{
"filter": {
  "item": [
   {"field_id": "101", "operator": "contains", "value": " 3\t4 ", "type": "id"},
   {"field_id": "102", "operator": ">", "value": " 1000000 ", "type": "number"}
  ]
}
}

Parts used in the sample

Part ID (field_id)	Part type	Part name
101	Select Group	Department in charge
102	Auto Calculation	Sales results

Sample 3

Search conditions that include "Chiyoda-ku, Tokyo" in the address and last visited before "20 days 3 months ago"

{
"filter": {
  "item": [
   {"field_id": "101", "operator": "includes", "value": "Chiyoda ward, Tokyo"},
   {"field_id": "102", "operator": "<", "value": "-3 months:20"}
  ]
}
}

Parts used in the sample

Part ID (field_id)	Part type	Part name
101	Text (1 Line)	address
102	Date	Last visit date

Sample 4

Search conditions when the contract status is other than "Termination" and "Contract Expiration" and the contract start date is "2017/04/01" or later

{
"filter": {
  "item": [
   {"field_id": "101", "operator": "! =", "value": "Contract Delete \tContract Expired"},
   { field_id ": "102", "operator": ">=", "value": " 2017-04-01 "}
  ]
}
}

Parts used in the sample

Part ID (field_id)	Part type	Part name
101	Pull Down	Contract status
102	Date	Contract start date

Sample 5

Search conditions when the equipment rental date is "2017/04/01 09:00" and the equipment return date has not been entered.

{
"filter": {
  "item": [
   {"field_id": "101", "operator": ">=", "value": "2017-04-01T09:00"},
   {"field_id": "102", "operator": "is_null"}
  ]
}
}

Parts used in the sample

Part ID (field_id)	Part type	Part name
101	Date/Time	Equipment rental date and time
102	Date/Time	Equipment return date and time

Sample 6

Search conditions when the employee's user system ID is "10" and the leaving time is "22:00" or later

{
"filter": {
  "item": [
   {"field_id": "101", "operator": "contains", "value": "10", "type": "id"},
   {"field_id": "102", "operator": ">=", "value": "22:00"}
  ]
}
}

Parts used in the sample

Part ID (field_id)	Part type	Part name
101	Select User	Employee
102	Time	Leave time

Sample 7

Search conditions that have the same start and end dates

{
"filter": {
  "item": [
   {"field_id": "101", "operator": "=", "value": "102", "type": "field_id"}
  ]
}
}

Parts used in the sample

Part ID (field_id)	Part type	Part name
101	Date	Start Date
102	Date	End Date

Sample 8

Search conditions that include "quote" in the file name of the sent document

{
"filter": {
  "item": [
   {"field_id": "101", "operator": "includes", "value": "Estimates"}
  ]
}
}

Parts used in the sample

Part ID (field_id)	Part type	Part name
101	Attachment Files	Documents to be sent

Sample 9

Search conditions with a travel time (auto calculation) of "1 hour and a half (5400 seconds)" or more

{
"filter": {
  "item": [
   {"field_id": "101", "operator": ">=", "value": " 5400 ", "type": "interval"}
  ]
}
}

Parts used in the sample

Part ID (field_id)	Part type	Part name
101	Auto Calculation	Travel time

Sample 10

Search conditions for which the correctable date (auto calculation) is before "the end of this month"

{
"filter": {
  "item": [
   {"field_id": "101", "operator": "<", "value": "+0 months:e", "type": "date"}
  ]
}
}

Parts used in the sample

Part ID (field_id)	Part type	Part name
101	Auto Calculation	Correctable date

Sample 11

Search conditions before the estimated arrival date and time (auto calculation) "2017/04/01 17:00"

{
"filter": {
  "item": [
   {"field_id": "101", "operator": "<=", "value": "2017-04-01T17:00", "type": "datetime"}
  ]
}
}

Parts used in the sample

Part ID (field_id)	Part type	Part name
101	Auto Calculation	Estimated arrival date and time

Sample 12

Search conditions that include "Heisei" or "Showa" in the Western calendar conversion (auto calculation)

{
"filter": {
  "item": [
   {"field_id": "101", "operator": "includes", "value": "Heisei\t Showa", "type": "textbox"}
  ]
}
}

Parts used in the sample

Part ID (field_id)	Part type	Part name
101	Auto Calculation	Western calendar conversion