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 and a detailed code sample in Create a simple .NET client.
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.
/Relativity.REST/Workspace/1014823/Relativity Script |
Response

This JSON representation is an abridged response. The ellipsis (...) indicates where JSON data has been omitted.
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.
/Relativity.REST/Workspace/1014823/Relativity Script/<Artifact ID/GUID> |
Response

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" , }, "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" , }, "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
/Relativity.REST/Workspace/1017955/Relativity Script/QueryResult |
Request

1 2 3 4 5 | //Input JSON representation of a Script query. { "condition" : " 'Name' LIKE 'Production'" , "fields" :[ "Artifact ID" , "Name" ] } |
Response

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 | //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 } |