This DTO has been deprecated as part of the Relativity Services API (RSAPI) Deprecation and is no longer supported. For more information and alternative APIs, see RSAPI deprecation process.
Relativity Script
A Relativity Script resource represents a script deployed into a Relativity workspace. You can use the REST API to read and query the already existing scripts that have been imported from the Relativity Script Library or manually created. You can also interact with Relativity scripts through the Services API. For general information about scripts, see the Relativity Documentation site.
This page contains the following information:
GET method
You can use the GET method to retrieve all Scripts in a Relativity workspace or a single Script. You can find a general overview of this functionality in Retrieve resources.
Retrieve all workspace Scripts
You can retrieve a collection of all Scripts in a workspace with a GET method.
Sample URL
The URL indicates that you are retrieving a collection of Relativity Script resources. You don't need to provide a body with this GET request.
Copy
1
/Relativity.REST/Workspace/1014823/Relativity Script
Response
View the JSON response for the retrieval all workspace Scripts
This JSON representation is an abridged response. The ellipsis (...) indicates where JSON data has been omitted.
Copy
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
{
"TotalResultCount": 3,
"ResultCount": 3,
"Results": [
{
"Artifact ID": 1037774,
"Guids": [
"ec2798ec-6c1d-4160-a3f2-db43797b5d51"
],
"Artifact Type ID": 28,
"Artifact Type Name": "Relativity Script",
"Artifact Type Guids": null,
"Parent Artifact": {
"Artifact ID": 1003663,
"Guids": null,
"Artifact Type ID": null,
"Artifact Type Name": null,
"Artifact Type Guids": null,
"__Location": null
},
"__Location": "https://hostname.mycompany.corp/Relativity.REST/Workspace/1014823/Relativity%20Script/1037774",
"Relativity Text Identifier": "Assign legacy document bates fields",
"Category": "Case Functionality",
"Description": "This script updates Bates fields you create on the Document table with the Bates numbering information stored in the Production Information RDO of a production you select.",
"__Fields": [
{
"Name": "Relativity Text Identifier",
"Field Type": "FixedLengthText",
"Field Guids": null,
"Field Artifact ID": 0
},
{
"Name": "Category",
"Field Type": "FixedLengthText",
"Field Guids": null,
"Field Artifact ID": 0
},
{
"Name": "Description",
"Field Type": "FixedLengthText",
"Field Guids": null,
"Field Artifact ID": 0
}
]
},
{
"Artifact ID": 1037775,
"Guids": [
"da2dfd3f-d5bd-4b2e-81ea-06ce2c81e6c9"
],
"Artifact Type ID": 28,
"Artifact Type Name": "Relativity Script",
"Artifact Type Guids": null,
"Parent Artifact": {
"Artifact ID": 1003663,
"Guids": null,
"Artifact Type ID": null,
"Artifact Type Name": null,
"Artifact Type Guids": null,
"__Location": null
},
"__Location": "https://hostname.mycompany.corp/Relativity.REST/Workspace/1014823/Relativity%20Script/1037775",
"Relativity Text Identifier": "Set Production Beg/End Attach Fields",
"Category": "Case Functionality",
"Description": "This Relativity script populates the production beginning and end attachment range fields for each case document included in a production.",
"__Fields": [
{
"Name": "Relativity Text Identifier",
"Field Type": "FixedLengthText",
"Field Guids": null,
"Field Artifact ID": 0
},
{
"Name": "Category",
"Field Type": "FixedLengthText",
"Field Guids": null,
"Field Artifact ID": 0
},
{
"Name": "Description",
"Field Type": "FixedLengthText",
"Field Guids": null,
"Field Artifact ID": 0
}
]
},
{
"Artifact ID": 1037895,
"Guids": [
"ffc49049-dfde-4751-bd00-c44052d454a1"
],
"Artifact Type ID": 28,
"Artifact Type Name": "Relativity Script",
"Artifact Type Guids": null,
"Parent Artifact": {
"Artifact ID": 1003663,
"Guids": null,
"Artifact Type ID": null,
"Artifact Type Name": null,
"Artifact Type Guids": null,
"__Location": null
},
"__Location": "https://hostname.mycompany.corp/Relativity.REST/Workspace/1014823/Relativity%20Script/1037895",
"Relativity Text Identifier": "Check Converted Documents in Cache",
"Category": "Case Functionality",
"Description": "Returns the list of documents and their types that have been previously converted",
"__Fields": [
{
"Name": "Relativity Text Identifier",
"Field Type": "FixedLengthText",
"Field Guids": null,
"Field Artifact ID": 0
},
{
"Name": "Category",
"Field Type": "FixedLengthText",
"Field Guids": null,
"Field Artifact ID": 0
},
{
"Name": "Description",
"Field Type": "FixedLengthText",
"Field Guids": null,
"Field Artifact ID": 0
}
]
}
],
"NextPage": null,
"PreviousPage": null,
"QueryToken": null
}
Retrieve a single Script
When you retrieve a single Relativity Script, you must supply a unique identifier (such as a GUID or ArtifactID) for the resource.
Sample URL
The URL contains the identifier for a Relativity Script resource. You don't need to provide a body with a GET request.
Copy
1
/Relativity.REST/Workspace/1014823/Relativity Script/<Artifact ID/GUID>
Response
View a JSON response for the retrieval of a single Script
Copy
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
{
"Artifact ID": 1037774,
"Guids": [
"ec2798ec-6c1d-4160-a3f2-db43797b5d51"
],
"Artifact Type ID": 28,
"Artifact Type Name": "Relativity Script",
"Artifact Type Guids": null,
"Parent Artifact": {
"Artifact ID": 1003663,
"Guids": null,
"Artifact Type ID": null,
"Artifact Type Name": null,
"Artifact Type Guids": null,
"__Location": null
},
"__Location": "https://hostname.mycompany.corp/Relativity.REST/Workspace/1014823/Relativity%20Script/1037774",
"Relativity Applications": [],
"Name": "Assign legacy document bates fields",
"Relativity Text Identifier": "Assign legacy document bates fields",
"Description": "This script updates Bates fields you create on the Document table with the Bates numbering information stored in the Production Information RDO of a production you select.",
"Version": "1",
"Body": "<script>\r\n\t<name>Assign legacy document bates fields</name>\r\n\t<description>This script updates Bates fields you create on the Document table with the Bates numbering information stored in the Production Information RDO of a production you select.</description>\r\n\t<category>Case Functionality</category>\r\n\t<version>1</version>\r\n\t<key>81C2ACFF-7F87-4BB0-8078-7AA4B22916D5</key>\r\n\t<input orientation=\"horizontal\">\r\n\t\t<sql id=\"ProductionId\" name=\"Production\">\n\t\t\nDECLARE @ProducedCodeId AS int\nDECLARE @StatusCodeArtifactTable AS nvarchar(128)\nDECLARE @ProducedStatusGuid AS varchar(50) = '2D0AA91F-4589-4733-B87D-BBFD6F869FE3'\nDECLARE @DocumentFieldGuid AS varchar(50) = 'E1B927C4-28A1-4BD5-B5A9-7F521EDEDC97'\n\nSELECT @StatusCodeArtifactTable = 'ZCodeArtifact_' + CAST(c.CodeTypeID AS varchar(20)), @ProducedCodeId = c.ArtifactID\nFROM ArtifactGuid a \nINNER JOIN Code c on a.ArtifactID = c.ArtifactID\nWHERE a.ArtifactGuid = @ProducedStatusGuid\n\nEXEC('\n\tSELECT p.Name AS ''Display'', p.ArtifactID AS ''ID'' FROM Production p\n\tINNER JOIN ' + @StatusCodeArtifactTable + ' z ON p.ArtifactID = z.AssociatedArtifactID\n\tWHERE z.CodeArtifactID = ' + @ProducedCodeId + '\n\tORDER BY p.Name'\n)\n\t\t\t\n\t</sql>\r\n\t\t<sql id=\"BegBatesFieldId\" name=\"Begin Bates Field\">\n\t\t\nDECLARE @DocumentArtifactTypeID AS int = 10\n\nSELECT f.DisplayName AS 'Display', f.ArtifactID AS 'ID' FROM Field f \nWHERE f.FieldArtifactTypeID = @DocumentArtifactTypeID\nAND f.FieldTypeID = 0\nAND f.FieldCategoryID = 0\nAND f.IsArtifactBaseField = 0\nORDER BY f.DisplayName\n\t\t\t\n\t</sql>\r\n\t\t<sql id=\"EndBatesFieldId\" name=\"End Bates Field\">\n\t\t\nDECLARE @DocumentArtifactTypeID AS int = 10\n\nSELECT f.DisplayName AS 'Display', f.ArtifactID AS 'ID' FROM Field f \nWHERE f.FieldArtifactTypeID = @DocumentArtifactTypeID\nAND f.FieldTypeID = 0\nAND f.FieldCategoryID = 0\nAND f.IsArtifactBaseField = 0\nORDER BY f.DisplayName\n\t\t\t\n\t</sql>\r\n\t\t<sql id=\"BegBatesAttachmentFieldId\" name=\"Begin Bates Attachment Field\" required=\"false\">\n\t\t\nDECLARE @DocumentArtifactTypeID AS int = 10\n\nSELECT f.DisplayName AS 'Display', f.ArtifactID AS 'ID' FROM Field f \nWHERE f.FieldArtifactTypeID = @DocumentArtifactTypeID\nAND f.FieldTypeID = 0\nAND f.FieldCategoryID = 0\nAND f.IsArtifactBaseField = 0\nORDER BY f.DisplayName\n\t\t\t\n\t</sql>\r\n\t\t<sql id=\"EndBatesAttachmentFieldId\" name=\"End Bates Attachment Field\" required=\"false\">\n\t\t\nDECLARE @DocumentArtifactTypeID AS int = 10\n\nSELECT f.DisplayName AS 'Display', f.ArtifactID AS 'ID' FROM Field f \nWHERE f.FieldArtifactTypeID = @DocumentArtifactTypeID\nAND f.FieldTypeID = 0\nAND f.FieldCategoryID = 0\nAND f.IsArtifactBaseField = 0\nORDER BY f.DisplayName\n\t\t\t\n\t</sql>\r\n\t</input>\r\n\t<display type=\"itemlist\" />\r\n\t<action returns=\"table\"><![CDATA[\n\t\nDECLARE @ProductionId AS int = #ProductionId#\nDECLARE @BegBatesFieldId AS int = #BegBatesFieldId#\nDECLARE @EndBatesFieldId AS int = #EndBatesFieldId#\n\nDECLARE @BegBatesAttachmentFieldIdInput AS varchar(20) = '#BegBatesAttachmentFieldId#'\nDECLARE @EndBatesAttachmentFieldIdInput AS varchar(20) = '#EndBatesAttachmentFieldId#'\n\n\nDECLARE @DocumentArtifactTypeId AS int = 10\nDECLARE @IdentifierFieldCategoryId AS int = 2\nDECLARE @ProductionObjectGuid AS varchar(50) = '24190650-2E73-4373-B0C4-F31142CBF300'\nDECLARE @ProductionInformationDocumentFieldGuid AS varchar(50) = 'E1B927C4-28A1-4BD5-B5A9-7F521EDEDC97'\n\n\nDECLARE @ProductionIdString AS varchar(20) = CAST(@ProductionId AS varchar(20))\nDECLARE @RelationalFieldTableName AS nvarchar(128)\nDECLARE @RelationalTableFieldColumnName1 AS nvarchar(128)\nDECLARE @RelationalTableFieldColumnName2 AS nvarchar(128)\n\nSELECT @RelationalFieldTableName = f.RelationalTableName, @RelationalTableFieldColumnName1 = f.RelationalTableColumnName, @RelationalTableFieldColumnName2 = f.RelationalTableColumnName2\nFROM QueryField f \nINNER JOIN ArtifactGuid a ON a.ArtifactID = f.FieldArtifactId\nWHERE a.ArtifactGuid = @ProductionInformationDocumentFieldGuid\n\nDECLARE @BegBatesFieldName AS nvarchar(128) = (SELECT QUOTENAME(AvfColumnName) FROM QueryField WHERE FieldArtifactId = @BegBatesFieldId)\nDECLARE @EndBatesFieldName AS nvarchar(128) = (SELECT QUOTENAME(AvfColumnName) FROM QueryField WHERE FieldArtifactId = @EndBatesFieldId)\n\nDECLARE @DocumentIdentifierFieldName AS nvarchar(128)\nSELECT @DocumentIdentifierFieldName = QUOTENAME(f.AvfColumnName) FROM QueryField f\nWHERE f.ArtifactTypeID = @DocumentArtifactTypeId\nAND FieldCategoryID = @IdentifierFieldCategoryId\n\n\nDECLARE @UpdateFieldsClause AS varchar(max) = @BegBatesFieldName + ' = p.BeginBates,' + @EndBatesFieldName + ' = p.EndBates' \nDECLARE @SelectFieldsClause AS varchar(max) = @BegBatesFieldName + ',' + @EndBatesFieldName\n\nIF (LEN(@BegBatesAttachmentFieldIdInput) > 0 AND LEN(@EndBatesAttachmentFieldIdInput) > 0)\nBEGIN\n\tDECLARE @BegBatesAttachmentFieldId AS int = CAST(@BegBatesAttachmentFieldIdInput AS int)\n\tDECLARE @EndBatesAttachmentFieldId AS int = CAST(@EndBatesAttachmentFieldIdInput AS int)\n\n\tDECLARE @BegBatesAttachmentFieldName AS varchar(100) = (SELECT QUOTENAME(AvfColumnName) FROM QueryField WHERE FieldArtifactId = @BegBatesAttachmentFieldId)\n\tDECLARE @EndBatesAttachmentFieldName AS varchar(100) = (SELECT QUOTENAME(AvfColumnName) FROM QueryField WHERE FieldArtifactId = @EndBatesAttachmentFieldId)\n\t\n\tSET @UpdateFieldsClause = @UpdateFieldsClause +\t',' + @BegBatesAttachmentFieldName + ' = p.BeginAttachment,' + @EndBatesAttachmentFieldName + ' = p.EndAttachment '\n\tSET @SelectFieldsClause = @SelectFieldsClause +\t',' + @BegBatesAttachmentFieldName + ',' + @EndBatesAttachmentFieldName\nEND\n\n\nCREATE TABLE #UpdatedDocuments(\n\tArtifactID int\n)\n\nDECLARE @BatchSize AS varchar(5) = '1000'\nDECLARE @UpdatedRows AS int = 999 \n\nWHILE (@UpdatedRows > 0)\nBEGIN\n\tEXEC(\n\t\t'UPDATE TOP(' + @BatchSize + ') d SET ' + \n\t\t@UpdateFieldsClause + '\n\t\tOUTPUT inserted.ArtifactID INTO #UpdatedDocuments\n\t\tFROM Document d \n\t\tINNER JOIN ' + @RelationalFieldTableName + ' f ON d.ArtifactID = f.' + @RelationalTableFieldColumnName2 + '\n\t\tINNER JOIN ProductionInformation p ON p.ArtifactID = f.' + @RelationalTableFieldColumnName1 + '\n\t\tINNER JOIN Artifact a ON p.ArtifactID = a.ArtifactID\n\t\tWHERE a.ParentArtifactID = ' + @ProductionIdString + '\n\t\tAND NOT EXISTS (SELECT ArtifactID FROM #UpdatedDocuments WHERE ArtifactID = d.ArtifactID)'\n\t)\n\tSELECT @UpdatedRows = @@ROWCOUNT\nEND\n\nEXEC(\n\t'SELECT d.ArtifactID, ' + @SelectFieldsClause + '\n\tFROM Document d INNER JOIN #UpdatedDocuments u ON d.ArtifactID = u.ArtifactID'\n)\n\nDROP TABLE #UpdatedDocuments\n\t\n\t]]></action>\r\n</script>",
"Key": "81C2ACFF-7F87-4BB0-8078-7AA4B22916D5",
"Category": "Case Functionality",
"System Created By": {
"Artifact ID": 777,
"Guids": null,
"Artifact Type ID": 2,
"Artifact Type Name": "User",
"Artifact Type Guids": null,
"Full Name": "Service Account, Relativity",
"__Location": "https://hostname.mycompany.corp/Relativity.REST/Relativity/User/777"
},
"System Last Modified By": {
"Artifact ID": 777,
"Guids": null,
"Artifact Type ID": 2,
"Artifact Type Name": "User",
"Artifact Type Guids": null,
"Full Name": "Service Account, Relativity",
"__Location": "https://hostname.mycompany.corp/Relativity.REST/Relativity/User/777"
},
"System Created On": "2015-11-25T21:43:16",
"System Last Modified On": "2016-09-07T21:15:22.58",
"__Fields": [
{
"Name": "Relativity Applications",
"Field Type": "MultipleObject",
"Field Guids": null,
"Field Artifact ID": 1035599
},
{
"Name": "Name",
"Field Type": "FixedLengthText",
"Field Guids": null,
"Field Artifact ID": 1035600
},
{
"Name": "Relativity Text Identifier",
"Field Type": "FixedLengthText",
"Field Guids": null,
"Field Artifact ID": 0
},
{
"Name": "Description",
"Field Type": "FixedLengthText",
"Field Guids": null,
"Field Artifact ID": 0
},
{
"Name": "Version",
"Field Type": "FixedLengthText",
"Field Guids": null,
"Field Artifact ID": 0
},
{
"Name": "Body",
"Field Type": "LongText",
"Field Guids": null,
"Field Artifact ID": 0
},
{
"Name": "Key",
"Field Type": "FixedLengthText",
"Field Guids": null,
"Field Artifact ID": 0
},
{
"Name": "Category",
"Field Type": "FixedLengthText",
"Field Guids": null,
"Field Artifact ID": 0
},
{
"Name": "System Created By",
"Field Type": "User",
"Field Guids": null,
"Field Artifact ID": 0
},
{
"Name": "System Last Modified By",
"Field Type": "User",
"Field Guids": null,
"Field Artifact ID": 0
},
{
"Name": "System Created On",
"Field Type": "Date",
"Field Guids": null,
"Field Artifact ID": 0
},
{
"Name": "System Last Modified On",
"Field Type": "Date",
"Field Guids": null,
"Field Artifact ID": 0
}
]
}
POST method
You can use the POST method to perform complex queries for Relativity Scripts. For detailed information about Relativity REST API query syntax, see Perform queries.
Query for a Script resource
You can set conditions used to query for a Relativity Script resource.
Sample URL
Copy
1
2
/Relativity.REST/Workspace/1017955/Relativity Script/QueryResult
Request
View the JSON for a Script query
Copy
1
2
3
4
5
6
//Input JSON representation of a Script query.
{
"condition":" 'Name' LIKE 'Production'",
"fields":["Artifact ID", "Name"]
}
Response
View the JSON returned when a Script query is successful
Copy
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
//Output JSON representation of results from a Script query.{
"TotalResultCount": 1,
"ResultCount": 1,
"Results": [
{
"Artifact ID": 1037775,
"Guids": [
"da2dfd3f-d5bd-4b2e-81ea-06ce2c81e6c9"
],
"Artifact Type ID": 28,
"Artifact Type Name": "Relativity Script",
"Artifact Type Guids": null,
"Parent Artifact": {
"Artifact ID": 1003663,
"Guids": null,
"Artifact Type ID": null,
"Artifact Type Name": null,
"Artifact Type Guids": null,
"__Location": null
},
"__Location": "https://hostname.mycompany.corp/Relativity.REST/Workspace/1014823/Relativity%20Script/1037775",
"Name": "Set Production Beg/End Attach Fields",
"Description": "This Relativity script populates the production beginning and end attachment range fields for each case document included in a production.",
"Body": "<script>\r\n\t<name>Set Production Beg/End Attach Fields</name>\r\n\t<version>1</version>\r\n\t<key>D2ED8336-DEF5-4578-95BB-42FFD10B332E</key>\r\n\t<category>Case Functionality</category>\r\n\t<description>This Relativity script populates the production beginning and end attachment range fields for each case document included in a production.</description>\r\n\t<input>\r\n\t\t<sql id=\"ProductionID\" name=\"Production Name\">\n\t\t\tSELECT \n\t\t\t\tDisplay= P.[Name],\n\t\t\t\tID=P.[ArtifactID]\n\t\t\tFROM [Production] P (NOLOCK)\n\t\t\tORDER BY \n\t\t\t\tP.[Name] ASC\n\t\t</sql>\r\n\t\t<field id=\"FamilyIdentifierField\" name=\"Family Identifier Field\">\r\n\t\t\t<filters>\r\n\t\t\t\t<category>5</category>\r\n\t\t\t</filters>\r\n\t\t</field>\r\n\t</input>\r\n\t<action returns=\"status\" timeout=\"300\"><![CDATA[\n\t\n\nDECLARE @ProductionID AS nvarchar(20) = #ProductionID#\nDECLARE @DocumentFieldID AS nvarchar(20)\nDECLARE @ProductionInformationFieldID AS nvarchar(20)\nDECLARE @DocumentFieldName AS nvarchar(20)\nDECLARE @ProductionInformationFieldName AS nvarchar(20)\nDECLARE @MultiObjectTableName AS nvarchar(100)\n\nSELECT @DocumentFieldID = F.ArtifactID FROM ArtifactGuid AG \nINNER JOIN Field F ON AG.ArtifactID = F.ArtifactID\nWHERE AG.ArtifactGuid = '917599EB-0D35-4F4F-BD0D-10046414FB61'\nSET @DocumentFieldName = 'f' + @DocumentFieldID + 'ArtifactID'\n\n\nSELECT @ProductionInformationFieldID = F.ArtifactID FROM ArtifactGuid AG \nINNER JOIN Field F ON AG.ArtifactID = F.ArtifactID\nWHERE AG.ArtifactGuid = 'E1B927C4-28A1-4BD5-B5A9-7F521EDEDC97'\nSET @ProductionInformationFieldName = 'f' + @ProductionInformationFieldID + 'ArtifactID'\n\nSET @MultiObjectTableName = 'f' + @DocumentFieldID + 'f' + @ProductionInformationFieldID\nSELECT @MultiObjectTableName\n\nDECLARE @sql AS NVARCHAR(MAX) = '\n\tDECLARE @rowsAffected INT\n\tSET @rowsAffected = 1\n\tWHILE @rowsAffected > 0\n\tBEGIN\n\t\tUPDATE TOP(1000) P\n\t\tSET P.BeginAttachment = SORTED.BeginBates,\n\t\tP.EndAttachment = SORTED.EndBates\n\t\tFROM ProductionInformation P\n\t\tINNER JOIN Artifact A ON P.ArtifactID = A.ArtifactID\n\t\tAND A.ParentArtifactID = ' + @ProductionID + '\n\t\tINNER JOIN ' + @MultiObjectTableName + ' F ON F.' + @ProductionInformationFieldName + ' = P.ArtifactID\n\t\tINNER JOIN Document D ON F.' + @DocumentFieldName + ' = D.ArtifactID\n\t\tINNER JOIN (\n\t\t\tSELECT MIN(P.BeginBates) AS BeginBates, MAX(P.EndBates) AS EndBates, D.[#FamilyIdentifierField#] FROM ProductionInformation P\n\t\t\tINNER JOIN Artifact A ON P.ArtifactID = A.ArtifactID\n\t\t\tAND A.ParentArtifactID = ' + @ProductionID + '\n\t\t\tINNER JOIN ' + @MultiObjectTableName + ' F ON F.' + @ProductionInformationFieldName + ' = P.ArtifactID\n\t\t\tINNER JOIN Document D ON F.' + @DocumentFieldName + ' = D.ArtifactID\n\t\t\tGROUP BY D.[#FamilyIdentifierField#]) AS SORTED ON SORTED.[#FamilyIdentifierField#] = D.[#FamilyIdentifierField#]\n\t\tWHERE \n\t\t\tISNULL(P.BeginBates, '''') <> ''''\n\t\t\tAND \n\t\t\tISNULL(P.EndAttachment, '''') = ''''\n\n\t\tSET @rowsAffected = @@ROWCOUNT\n\tEND'\nEXEC sp_executesql @sql\n\n]]></action>\r\n</script>",
"Category": "Case Functionality",
"__Fields": [
{
"Name": "Name",
"Field Type": "FixedLengthText",
"Field Guids": null,
"Field Artifact ID": 1035600
},
{
"Name": "Description",
"Field Type": "FixedLengthText",
"Field Guids": null,
"Field Artifact ID": 0
},
{
"Name": "Body",
"Field Type": "LongText",
"Field Guids": null,
"Field Artifact ID": 0
},
{
"Name": "Category",
"Field Type": "FixedLengthText",
"Field Guids": null,
"Field Artifact ID": 0
}
]
}
],
"NextPage": null,
"PreviousPage": null,
"QueryToken": null
}
