Kinetic Tabular Data Find Version 2

This handler returns the request ids (field 1) for all records in the CUSTOM:KSSRVTableData_base form that match the provided query. This is returned in XML format (like below) for use in loops.

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

Sample Configuration

Results

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

KAPP Assignment Group Membership Lookup

Retrieves the login and email information for the assignee or group members of the specified group.

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 Update

Updates a specific record in 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 Email Message Create

Creates a Kinetic message record using the specified message template. Once the Kinetic Request message poller process the record, an email message is generated and sent to the target recipient.

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 Base Submission Retrieve

Retrieves a specific Kinetic Request base record from the KS_SRV_CustomerSurvey_base form.

Kinetic Request Submission Build Attachment URL

Builds and returns URL for a file download of an attachment that was uploaded as a question answer.

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 Format Answers

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.