Kinetic Tabular Data Find logo

Kinetic Tabular Data Find Version 2

This handler returns the request ids (field 1) for all records in the CUSTOM:KSSRVTableDatabase form that match the provided query. This is returned in XML format (like below) for use in loops. <RequestIds> 000000000000013 000000000000381 000000000002582 It also returns the instance ids (field 179) in a similar format: AG0050569A648CU5tSUAUcZMAgc8AC AG0050569A648ClZtSUAkMVNAgVcYC AG0050569A648CMZtSUAKUBMAgMrkC Note that this is not necessary if you want every row out of a table that is saved in the same tree. In that case, the results of the table data create handler can be used.

Parameters

Name Description
Survey Instance ID Survey Instance ID
Survey Template Name Survey Template Name
Originating ID Associated Request GUID
Table Name Table Name
Value1 Value in Column 1
Value2 Value in Column 2
Value3 Value in Column 3
Value4 Value in Column 4
Value5 Value in Column 5
Value6 Value in Column 6
Value7 Value in Column 7
Value8 Value in Column 8
Value9 Value in Column 9
Value10 Value in Column 10
Value11 Value in Column 11
Value12 Value in Column 12
Value13 Value in Column 13
Value14 Value in Column 14
Value15 Value in Column 15
Value16 Value in Column 16
Value17 Value in Column 17
Value18 Value in Column 18
Value19 Value in Column 19
Value20 Value in Column 20

Sample Configuration

Name Description
Survey Template Name
Originating ID <=%dataset['Originating ID']%>
Table Name ContactTable
Value1
Value2
Value3
Value4
Value5
Value6 Alternate Contact
Value7
Value8
Value9
Value10
Value11
Value12
Value13
Value14
Value15
Value16
Value17
Value18
Value19
Value20
Survey Instance ID

Results

Name Description
RequestIdList The request ids (field 1) of the updated record.
InstanceIdList The instance ids (field 179) of the updated record.

Changelog

Kinetic Tabular Data Find (2013-06-17)

  • Expanding fields available to search by

Kinetic Tabular Data Find (2013-01-30)

  • Initial version. See README for details.


Related Handlers

Kinetic Assignment Record Retrieve
Retrieves a specific record from the KS_RQT_Assignment form.
Kinetic Assignment Record Update
Updates the Request Due Date, Work Order Due Date, and/or Priority field(S) on a specific record from the KS_RQT_Assignment form.
Kinetic Cost Calculate Costs
Returns an XML listing record ids found in the KS_SRV_Helper form.
Kinetic Helper Record Create
Creates a specific record in the KS_SRV_Helper form.
Kinetic Helper Record Find All
Returns an XML listing record ids found in the KS_SRV_Helper form.
Kinetic Helper Record Find
Returns the first record id to a specific search in the KS_SRV_Helper form.
Kinetic Helper Record Retrieve
Retrieves a specific record from the KS_SRV_Helper form.
Kinetic Request Answer Create
Creates a Submission Answer
Kinetic Request Answer Retrieve
Retrieves a Submission Answer
Kinetic Request Answer Update
Creates a Submission Answer
Kinetic Request All Answers Retrieve
Retrieves Submission Answers
Kinetic Request Approval Create
Creates an approval submission for the submission record specified by the 'Lookup Id' parameter, typically the Instance Id of the originating base request.
Kinetic Request Attribute Create
Populates Attributes Records (Settings Tab) for Service Items from a CSV data file
Kinetic Request Checkbox To XML
This handler converts a Kinetic Request checkbox answer into an XML string.
Kinetic Request Service Item Add Attribute
This handler adds an attribute to the given service item.
Kinetic Request Service Item Detect Attribute
This handler checks to see if a specific attribute is defined for the given service item.
Kinetic Request Service Item Detect
This handler checks to see if a given service item already exists.
Kinetic Request Service Item Remove Attribute
This handler removes a specific attribute that is defined for the given service item. If multiple instances of the same attribute are defined for the same service item, they are all removed.
Kinetic Request Service Item Rename
This handler renames a given service item.
Kinetic Request Service Item Update Status
This handler updates the status of a given service item.
Kinetic Request Base Submission Retrieve
Retrieves a specific Kinetic Request base record from the KS_SRV_CustomerSurvey_base form.
Kinetic Request Submission Build Review Request Url
Builds and returns the URL that corresponds to a review request view of the desired Kinetic Request submission.
Kinetic Request Submission Close All Open
Updates the Validation Status, the status that is displayed to the end user, of the specified submission record and sets the Request Status to "Closed" for all open requests associated with the provided originating ID.
Kinetic Request Submission Close
Updates the Validation Status, the status that is displayed to the end user, of the specified Kinetic Request submission record and sets the Request Status to "Closed".
Kinetic Request Submission Create Answers
This handler creates answer records related to the specified submission given one or multiple JSON answer sets.
Kinetic Request Submission Create
Creates a new base submission using the information specified.
Kinetic Request Submission Dataset Retrieve
Returns all dataset values for a given submission. For use inside of subtrees.
Kinetic Request Submission Format Answers HTML
Builds a simple result string by formatting a specified subset of answers for the source Kinetic Request submission.
Kinetic Request Submission Get Answer Set
This handler builds a JSON answer set for the current submission. The JSON structure maps question labels to their corresponding answers.
Kinetic Request Submission Update Answers
This handler creates or update answer records related to the specified submission given one or multiple JSON answer sets.
Kinetic Request Submission Update Status 7
Updates the Status field (ID 7 not validation Status).
Kinetic Request Submission Update Status
Updates the Validation Status, the status that is displayed to the end user, of the specified Kinetic Request submission record.
Kinetic Submission Complete
Sets a submission to complete and triggers the complete workflow, such as firing triggers
Kinetic Submission Retrieve Attribute
Retrieves the Kinetic Request base request with the specified values
Kinetic Submission Update Attribute
Updates the Kinetic Request base request with the specified values
Kinetic Table Data Create
Creates an entry in the CUSTOM:KS_SRV_TableData_base form
Kinetic Tabular Data Retrieve
Retrieves a single CUSTOM:KS_SRV_TableData_base entry/saved table row with the instance id specified.