API v1.0 - Revision history

Tvi: Added limit

2024-04-22T09:21:28Z

Added limit

← Older revision		Revision as of 11:21, 22 April 2024
Line 55:		Line 55:
	Order records by income in descending order (true).		Order records by income in descending order (true).

	Finally execute the query and return the results		By default the API limits solution queries to 100 rows. To increase this:<syntaxhighlight lang="java">
			myQuery.setLimit(100000);
			</syntaxhighlight>To do pagination use this:<syntaxhighlight lang="java">
			myQuery.setLimitAndOffset(100, 100);
			</syntaxhighlight>Finally execute the query and return the results

	<syntaxhighlight lang="java">		<syntaxhighlight lang="java">

2023-10-04T08:58:59Z

Code example

← Older revision		Revision as of 10:58, 4 October 2023
Line 131:		Line 131:
	e.printStackTrace();		e.printStackTrace();
	}		}
			catch (TsCloseObjectRequired ex) {}
	finally {		finally {
	session.close();		session.close();
	}		}
	</syntaxhighlight>		</syntaxhighlight>

2023-10-04T08:48:44Z

Code example

← Older revision		Revision as of 10:48, 4 October 2023
Line 95:		Line 95:
	String templateKeyToParentTemplate = "SKABELON"; //Entity		String templateKeyToParentTemplate = "SKABELON"; //Entity
	String instanceSolutionName = "taskinstance";		String instanceSolutionName = "taskinstance";
			String instanceKeyToParent = "LIST";
	</syntaxhighlight>		</syntaxhighlight>

2023-10-04T08:47:30Z

Code example

← Older revision		Revision as of 10:47, 4 October 2023
Line 116:		Line 116:

	for(int fi=0; fi<fieldsTemplate.size(); fi++ ) {		for(int fi=0; fi<fieldsTemplate.size(); fi++ ) {
	String value = recordsToCopy.getRecordValue( i, ~~fieldsTemplate.get(fi)~~);		String fieldNameToCopy = fieldsTemplate.get(fi);
	instance.setValue( ~~fieldsInstance.get(fi)~~, value );		String value = recordsToCopy.getRecordValue( i, fieldNameToCopy );
			instance.setValue( fieldNameToCopy, value );
	}		}
	instance.setValueInteger( instanceKeyToParent, c.DataID );		instance.setValueInteger( instanceKeyToParent, c.DataID );

2023-10-04T08:45:52Z

Code example

← Older revision		Revision as of 10:45, 4 October 2023
Line 94:		Line 94:
	ArrayList fieldsTemplate = new ArrayList(String [] {"TASK","DEADLINE","RESPONSIBLE"}); //list of fields		ArrayList fieldsTemplate = new ArrayList(String [] {"TASK","DEADLINE","RESPONSIBLE"}); //list of fields
	String templateKeyToParentTemplate = "SKABELON"; //Entity		String templateKeyToParentTemplate = "SKABELON"; //Entity
			String instanceSolutionName = "taskinstance";
	</syntaxhighlight>		</syntaxhighlight>

2023-10-04T08:42:46Z

Code example

← Older revision		Revision as of 10:42, 4 October 2023
Line 93:		Line 93:
	String templateSolutionName = "tasktemplate"; //Entity		String templateSolutionName = "tasktemplate"; //Entity
	ArrayList fieldsTemplate = new ArrayList(String [] {"TASK","DEADLINE","RESPONSIBLE"}); //list of fields		ArrayList fieldsTemplate = new ArrayList(String [] {"TASK","DEADLINE","RESPONSIBLE"}); //list of fields
			String templateKeyToParentTemplate = "SKABELON"; //Entity
	</syntaxhighlight>		</syntaxhighlight>

2023-10-04T08:42:11Z

Code example

← Older revision		Revision as of 10:42, 4 October 2023
Line 90:		Line 90:

	<syntaxhighlight lang="java">		<syntaxhighlight lang="java">
	String thisKeyToParentTemplate = "~~listoftasks~~"; //Entity		String thisKeyToParentTemplate = "VALGTSKABELON"; //Entity
	String templateSolutionName = "tasktemplate"; //Entity		String templateSolutionName = "tasktemplate"; //Entity
	ArrayList fieldsTemplate = new ArrayList(String [] {"TASK","DEADLINE","RESPONSIBLE"}); //list of fields		ArrayList fieldsTemplate = new ArrayList(String [] {"TASK","DEADLINE","RESPONSIBLE"}); //list of fields

2023-10-04T08:39:01Z

Code example

← Older revision		Revision as of 10:39, 4 October 2023
Line 91:		Line 91:
	<syntaxhighlight lang="java">		<syntaxhighlight lang="java">
	String thisKeyToParentTemplate = "listoftasks"; //Entity		String thisKeyToParentTemplate = "listoftasks"; //Entity
	String templateSolutionName = "tasktemplate";		String templateSolutionName = "tasktemplate"; //Entity
			ArrayList fieldsTemplate = new ArrayList(String [] {"TASK","DEADLINE","RESPONSIBLE"}); //list of fields
			</syntaxhighlight>

			Now to the code ...

			<syntaxhighlight lang="java">
	int parentTemplateDataID = Parser.getInteger( c.fields.getElementByFieldName(thisKeyToParentTemplate).FieldValue );		int parentTemplateDataID = Parser.getInteger( c.fields.getElementByFieldName(thisKeyToParentTemplate).FieldValue );

2023-10-04T08:37:24Z

Code example

← Older revision		Revision as of 10:37, 4 October 2023
Line 90:		Line 90:

	<syntaxhighlight lang="java">		<syntaxhighlight lang="java">
			String thisKeyToParentTemplate = "listoftasks"; //Entity
			String templateSolutionName = "tasktemplate";

	int parentTemplateDataID = Parser.getInteger( c.fields.getElementByFieldName(thisKeyToParentTemplate).FieldValue );		int parentTemplateDataID = Parser.getInteger( c.fields.getElementByFieldName(thisKeyToParentTemplate).FieldValue );

2022-09-06T19:18:40Z

Retrieve data

← Older revision		Revision as of 21:18, 6 September 2022
Line 65:		Line 65:

	<syntaxhighlight lang="java">		<syntaxhighlight lang="java">
	for( int i=0; i<3; i++ ) {		for( int i=0; i<resultSet.size(); i++ ) {
	String text = "Value nr " + i " = " + '''resultSet.getRecordValue( i, "MYVALUE" );'''		String text = "Value nr " + i " = " + '''resultSet.getRecordValue( i, "MYVALUE" );'''
	System.out.println( text );		System.out.println( text );