Analysis
Finding where specific fields, filters, exports, etc. are used in Slate can be quite challenging. Here are some techniques that can help.
Need to change a field's ID? Reference Field Search tool and Finding Field Usage below.
Dump Source Format Mappings
This page is under construction. SELECT fmap.c.value('@src', 'nvarchar(max)') AS src_field ,fm...
Field Search Tool
Finding custom field usage in forms is easy, thanks to the Field Search tool! You'll find it unde...
Find Forms Not Covered by Origin Source Types ☂
This query finds forms that are Person- or Application Creation-scoped and are not included any a...
Find Forms Using Old STL Conditional Logic
This has been lightly tested. Please email us at support at reworkflow.com if you find inaccuraci...
Find Rules Assigning Inactive Users
These queries will find rules that set fields with user prompts or Reader queues where the user i...
Find Rules by Checklist Group or Item
🔎 How can I find which rule(s) reference a particular checklist group? Hopefully someone put...
Find Unmapped Prompt Values in Source Formats
Although it's possible to query for Source Formats with unmapped prompt values, this query is not...
Finding Field Usage
The Fields Search tool only goes so far. Here’s some helpful SQL that can help directly search th...
Finding Keywords in Portal HTML Content
A CJ version of this query can be easily imported from a Suitcase: 4e5a7b48-104c-481d-8857-b5ce11...
Finding Queries by SFTP Export Server
Need to query for queries that export to a particular server? In this example, 34.200.21.44 is th...
Finding Query Exports and Filters by Name
Need to find all queries that use a particular filter or export? This will search for query filte...
Find Rules Assigning Bin
Finding which rule is assigning a bin requires knowing the bin's GUID. You can query this from th...
Analyze Tracking Query Usage
Configurable Joins doesn't currently support the [query.run.id] table. Find which queries have t...
Find Rules Assigning Inactive Bins
Get this query from our Analysis suitcase: 4e5a7b48-104c-481d-8857-b5ce1148e9e0:rwf Visually, a ...