QSQL examples (28-10-2015 12:11:21)

1. [Base] AllTemplates template
   SELECT o.* AS col_0 FROM All o

2. [Base] Specific template
   SELECT o.* AS col_0 FROM BacklogItem o

3. [Base] Specific template with namespace
   SELECT o.* AS col_0 FROM BacklogItem:Special:QualiWare o

4. [Base] Get IEnumerable<RepositoryObject>
   SELECT o.* AS col_0 FROM BacklogItem o

5. [Base] Simple sort and filter
   SELECT bi.* AS col_0 FROM BacklogItem bi WHERE bi.Complexity = '1' ORDER BY bi.Name

6. [Base] Simple sort and filter (using Linq extension methods)
   SELECT bi.* AS col_0 FROM BacklogItem bi WHERE bi.Complexity = '1' ORDER BY bi.Name

7. [Base] Select from AllTemplate case - Person
   SELECT [all].* AS col_0 FROM All all WHERE all.Template = 'Person' ORDER BY all.Name

8. [Base] Select from AllTemplate case - Milestone
   SELECT [all].* AS col_0 FROM All all WHERE all.Template = 'Milestone' ORDER BY all.Name

9. [Base] Select from AllTemplate case - ItemStatus
   SELECT [all].* AS col_0 FROM All all WHERE all.Template = 'ItemStatus' ORDER BY all.Name

10. [Base] Select from AllTemplate case - BacklogItem
    SELECT [all].* AS col_0 FROM All all WHERE all.Template = 'BacklogItem' ORDER BY all.Name

11. [Other] English uppercase attribute name
    SELECT o.* AS col_0 FROM Task o WHERE CAST(o.attrName AS VARCHAR) = 'attrval'

12. [Other] English lowercase attribute name
    SELECT o.* AS col_0 FROM Task o WHERE CAST (o.attrname AS VARCHAR) = 'attrval'

13. [Other] Russian uppercase attribute name
    SELECT o.* AS col_0 FROM Task o WHERE CAST([o.имяАтрибута] AS VARCHAR) = 'значениеатрибута'

14. [Other] Russian lowercase attribute name
    SELECT o.* AS col_0 FROM Task o WHERE CAST([o.имяатрибута] AS VARcHAR) = 'значениеатрибута'

15. [Other] Query options: default
    SELECT o.* AS col_0 FROM BacklogItem o WHERE o.Name LIKE '%support%'

16. [Other] Query options: ignore case
    SELECT o.* AS col_0 FROM BacklogItem o WHERE o.Name LIKE '%support%'

17. [Other] Query options: custom collation (case insensitive)
    SELECT o.* AS col_0 FROM BacklogItem o WHERE o.Name LIKE '%support%'

18. [Other] Query options: custom collation (case sensitive)
    SELECT o.* AS col_0 FROM BacklogItem o WHERE o.Name LIKE '%support%'

19. [Other] Possible conflict with AttrVal
    SELECT o.* AS col_0 FROM Task o WHERE CAST(o.AttrVal AS VARCHAR) = 'attrval'

20. [Other] Possible conflict with AttrName
    SELECT o.* AS col_0 FROM Task o WHERE CAST(o.AttrName AS VARCHAR) = 'attrname'

21. [Other] Possible conflict with Revision
    SELECT o.* AS col_0 FROM Task o WHERE CAST(o.Revision AS VARCHAR) = 'revision'

22. [Filter] Between operation in where
    SELECT o.* AS col_0 FROM BacklogItem o WHERE CAST(o.Id as int) BETWEEN 4000 AND 4100

23. [Filter] Between operation in where (string attribute)
    SELECT o.* AS col_0 FROM BacklogItem o WHERE o.Id BETWEEN '4000' AND '4100'

24. [Filter] Between operation in where (>= AND <=)
    SELECT o.* AS col_0 FROM BacklogItem o WHERE CAST(o.Id as int)  >= 4000 AND CAST(o.Id as int) <= 4100

25. [Filter] Between datetimes in where
    SELECT o.* AS col_0 FROM BacklogItem o WHERE CAST(o.sys_Created AS VARCHAR) BETWEEN '2011.01.01 00:00:00' AND '2011.12.31 00:00:00'

26. [Filter] Between datetimes in where (>= AND <=)
    SELECT o.* AS col_0 FROM BacklogItem o WHERE CAST(o.sys_Created AS DATETIME) >= CAST('2011-01-01' AS DateTime) AND CAST(o.sys_Created AS DATETIME) <= CAST('2011-12-31' AS DateTime)

27. [Filter] Between BacklogItem names in where
    SELECT o.* AS col_0 FROM BacklogItem o WHERE o.Name BETWEEN 'Fix' AND 'QLM'

28. [Filter] Filter by IN expresion
    SELECT o.* AS col_0 FROM BacklogItem o WHERE CAST(o.Id as int) IN (4161, 4203)

29. [Filter] Filter by IN expresion (using OR statements)
    SELECT o.* AS col_0 FROM BacklogItem o WHERE o.Id = '4161' OR o.Id = '4203'

30. [Filter] Filter by IN expression and predefined attribute
    select o.* AS col_0 from BacklogItem o where CAST(o.sys_ObjectId as VARCHAR) in ('f09d4450-e0fd-45fa-aa0a-38a57632762c', '0071a04d-c27f-4e0e-a48a-7f68112da7b5')

31. [Filter] Equal operation in where
    SELECT o.* AS col_0 FROM BacklogItem o WHERE CAST(o.Id AS int) = 4203

32. [Filter] Equal operation in where (backward order)
    SELECT o.* AS col_0 FROM BacklogItem o WHERE 4203 = CAST(o.Id AS int)

33. [Filter] Not Equal operation in where
    SELECT o.* AS col_0 FROM BacklogItem o WHERE CAST(o.Id AS int) <> 4203

34. [Filter] Equal to empty string in where
    SELECT o.* AS col_0 FROM BacklogItem o WHERE o.Complexity = ''

35. [Filter] Greater than operation in where
    SELECT o.* AS col_0 FROM BacklogItem o WHERE CAST(o.Id AS int) > 4000

36. [Filter] Greater than or equal operation in where
    SELECT o.* AS col_0 FROM BacklogItem o WHERE CAST(o.Id AS int) >= 4034

37. [Filter] Less than operation in where (backward order)
    SELECT o.* AS col_0 FROM BacklogItem o WHERE 4000 < CAST(o.Id AS int)

38. [Filter] Less than operation in where
    SELECT o.* AS col_0 FROM BacklogItem o WHERE CAST(o.Id AS int) < 4000

39. [Filter] Less than or equal operation in where
    SELECT o.* AS col_0 FROM BacklogItem o WHERE CAST(o.Id AS int) <= 4034

40. [Filter] Filter by non-existing attribute (empty result)
    SELECT o.* AS col_0 FROM BacklogItem o WHERE CAST(o.NonExisting AS VARCHAR) = 'aaa'

41. [Filter] Filter by attribute with empty result
    SELECT o.* AS col_0 FROM Task o WHERE o.Name = '4203'

42. [Filter] Name in multilink (via Join) (distinct result)
    SELECT DISTINCT o.* AS col_0 FROM BacklogItem o INNER JOIN Task t ON t.sys_ObjectId = o.Tasks WHERE t.Name = 'Document' OR t.Name = 'Implement'

43. [Filter] Name greater lowercase
    select o.* AS col_0 from Task o where o.Name > 'abc'

44. [Filter] name greater or equal lowercase
    select o.* AS col_0 from Task o where o.Name >= 'abc'

45. [Filter] Name less lowercase
    select o.* AS col_0 from Task o where o.Name < 'abc'

46. [Filter] Name less or equal lowercase
    select o.* AS col_0 from Task o where o.Name <= 'abc'

47. [Filter] Name equal lowercase
    select o.* AS col_0 from Task o where o.Name = 'abc'

48. [Filter] Name not equal lowercase
    select o.* AS col_0 from Task o where o.Name <> 'abc'

49. [Filter] Name greater lowercase with spaces
    select o.* AS col_0 from Task o where o.Name > '  abc'

50. [Filter] Name equal to empty (empty result)
    select o.* AS col_0 from Task o where o.Name = ''

51. [Filter] Name greater XML tag
    select o.* AS col_0 from Task o where o.Name > '<abc/>'

52. [Filter] Name greater XML symbol
    select o.* AS col_0 from Task o where o.Name > '&lt'

53. [Filter] Name equal camel-case
    select o.* AS col_0 from Task o where o.Name = 'ABc'

54. [Filter] Name equal danish
    select o.* AS col_0 from Task o where o.Name = 'æø¨åы'

55. [Filter] Name equal number
    select o.* AS col_0 from Task o where o.Name = '19970324'

56. [Filter] sys_Created greater or equal date part (yyyy.MM)
    select o.* AS col_0 from Task o where o.sys_Created >= '2010.04'

57. [Filter] sys_Created greater or equal date part (yyyy)
    select o.* AS col_0 from Task o where o.sys_Created >= '2011'

58. [Filter] sys_Created less or equal date part (yyyy.MM)
    select o.* AS col_0 from Task o where o.sys_Created <= '2010.04'

59. [Filter] sys_Created less or equal date part (yyyy)
    select o.* AS col_0 from Task o where o.sys_Created <= '2011'

60. [Filter] AND operation
    select o.* AS col_0 from Project o where o.sys_ModifiedBy = 'Yuriy Mann' and o.sys_CreatedBy = 'Vladimir Kovalenko' and NOT(o.IsFrozen = true)

61. [Filter] Direct boolean value
    select o.* AS col_0 from Project o where o.IsFrozen = true

62. [Filter] OR operation
    select o.* AS col_0 from Project o where NOT(o.IsFrozen = true) or o.IsFrozen = true

63. [Filter] OR operation (reverse operands)
    select o.* AS col_0 from Project o where o.IsFrozen = true or NOT(o.IsFrozen = true)

64. [Filter] NOT operation
    select o.* AS col_0 from Project o where NOT (o.sys_CreatedBy = 'Yuriy Mann')

65. [Filter] AND, OR, NOT operations
    select o.* AS col_0 from Project o where o.sys_ModifiedBy = 'Yuriy Mann' and not(o.sys_CreatedBy = 'Vladimir Kovalenko' or o.IsFrozen = true)

66. [Filter] Name LIKE '%change%'
    select o.* AS col_0 from BacklogItem o where o.Name like '%change%' order by o.Name

67. [Filter] Name LIKE '[QS]%'
    select o.* AS col_0 from BacklogItem o where o.Name like '[QS]%' order by o.Name

68. [Filter] Name LIKE '[q-u]%'
    select o.* AS col_0 from BacklogItem o where o.Name like '[q-u]%' order by o.Name

69. [Filter] Name LIKE '%a%'
    select o.* AS col_0 from BacklogItem o where o.Name like '%a%' order by o.Name

70. [Filter] Name LIKE '_C%'
    select o.* AS col_0 from BacklogItem o where o.Name like '_C%' order by o.Name

71. [Filter] Name LIKE 'Imp_%'
    select o.* AS col_0 from BacklogItem o where o.Name like 'Imp_%' order by o.Name

72. [Filter] Name LIKE 'Q-SQL: table aliases'
    select o.* AS col_0 from BacklogItem o where o.Name like 'Q-SQL: table aliases' order by o.Name

73. [Filter] Name LIKE 'Q[^LE]%'
    select o.* AS col_0 from BacklogItem o where o.Name like 'Q[^LE]%' order by o.Name

74. [Filter] Name LIKE '____________________'
    select o.* AS col_0 from BacklogItem o where o.Name like '____________________' order by o.Name

75. [Filter] Name LIKE '%_%'
    select o.* AS col_0 from BacklogItem o where o.Name like '%_%' order by o.Name

76. [Filter] Name LIKE '[^LS]%n'
    select o.* AS col_0 from BacklogItem o where o.Name like '[^LS]%n' order by o.Name

77. [Filter] sys_Created LIKE '%2010%'
    select o.* AS col_0 from BacklogItem o where o.sys_Created like '%2010%' order by o.Name

78. [Filter] Name NOT LIKE '%change%'
    select o.* AS col_0 from BacklogItem o where o.Name not like '%change%' order by o.Name

79. [Filter] Name NOT LIKE '%a%'
    select o.* AS col_0 from BacklogItem o where o.Name not like '%a%' order by o.Name

80. [Filter] Name NOT LIKE 'Q-SQL: table aliases'
    select o.* AS col_0 from BacklogItem o where o.Name not like 'Q-SQL: table aliases' order by o.Name

81. [Filter] sys_Created NOT LIKE '%2010%'
    select o.* AS col_0 from BacklogItem o where o.sys_Created not like '%2010%' order by o.Name

82. [Filter] Template
    select o.* AS col_0 from All o where o.Template = 'Project'

83. [Filter] Filter by Name
    select o.* AS col_0 from Task o where o.Name = 'Create impact tests'

84. [Filter] Filter by sys_CreatedBy
    select o.* AS col_0 from Task o where o.sys_CreatedBy = 'Maria Babenko'

85. [Filter] Filter by sys_ModifiedBy
    select o.* AS col_0 from Task o where o.sys_ModifiedBy = 'Sergey Gulik'

86. [Filter] Filter by IsFrozen
    SELECT o.* AS col_0 FROM Task o WHERE o.IsFrozen = true

87. [Filter] Filter by IsDeleted
    SELECT o.* AS col_0 FROM Task o WHERE o.IsDeleted = false

88. [Filter] Filter by .NET DateTime
    SELECT o.* AS col_0 FROM BacklogItem o WHERE CAST(o.ApprovalDate AS DateTime) = CAST('23-02-2009 13:08:00' AS DATETIME)

89. [Filter] Filter by .NET Boolean
    SELECT o.* AS col_0 FROM BacklogItem o WHERE CAST(o.IncludeInReleaseHistory AS bit) = true

90. [Filter] Filter by .NET Boolean - 2
    select o.* AS col_0 from BacklogItem o where CAST(o.IncludeInReleaseHistory AS bit) = false

91. [Filter] Filter by .NET Int
    SELECT o.* AS col_0 FROM BacklogItem o WHERE CAST(o.Id AS int) = 3888

92. [Filter] Compare predefined and custom boolean attributes
    SELECT bi.* AS col_0 FROM BacklogItem bi WHERE bi.IsFrozen = CAST(bi.IncludeInReleaseHistory AS bit)

93. [Filter] Search in full xhtml value
    SELECT bi.* AS col_0 FROM BacklogItem bi WHERE CAST(bi.Description AS XhtmlText) LIKE '%font-weight: bold%'

94. [Filter] Conditional as generated by Telerik
    SELECT bi.* AS col_0 FROM BacklogItem bi WHERE bi.Name LIKE '%QIS%'

95. [Filter] Conditional as generated by Telerik without unnecessary ToString
    SELECT bi.* AS col_0 FROM BacklogItem bi WHERE bi.Name LIKE '%QIS%'

96. [Filter] Coalesce operator
    SELECT bi.* AS col_0 FROM BacklogItem bi WHERE bi.Name LIKE '%QIS%'

97. [Filter] Coalesce without unnecessary ToString
    SELECT bi.* AS col_0 FROM BacklogItem bi WHERE bi.Name LIKE '%QIS%'

98. [Join] 1.0 (empty result)
    SELECT bi.* AS col_0 FROM BacklogItem bi JOIN Person p ON p.sys_ObjectId = bi.Name

99. [Join] 1.1.1
    SELECT bi.* AS col_0 FROM BacklogItem bi LEFT JOIN Task t ON t.sys_ObjectId = bi.Tasks

100. [Join] 1.1.1 (distinct result)
     SELECT DISTINCT bi.* AS col_0 FROM BacklogItem bi LEFT JOIN Task t ON t.sys_ObjectId = bi.Tasks

101. [Join] 2.1
     SELECT bi.* AS col_0 FROM BacklogItem bi JOIN Person p ON bi.MoreInfoFrom = p.sys_ObjectId

102. [Join] 2.1.2
     SELECT bi.* AS col_0 FROM BacklogItem bi JOIN REVISION LIST('9d17469f-91c5-40be-8781-981cbc0003c4','aecc3b48-9f5b-4289-99e7-b7de3d007bcc','92974222-fce2-4b5a-83f0-7c4282f369d6','14decd2b-2ad0-457c-b0b7-f8748e9fcd10','0bd806ac-814b-48ae-946c-bf150b52ffcd','73423fee-c4fa-489a-a68b-e976365bb4a9','fd60c506-585b-4587-8b69-e63e49efaaa4','4da2943f-5510-46ea-8e89-a63e2dbcde95','e2fa5f57-971e-43b2-8f15-fe093d371fb6','2dd48c8c-a262-4fd8-83e4-5cb42c3459c6','c2d70125-2e9d-4357-b005-585776795978','358f39e7-c723-4b91-8470-d61d6c662c22') list ON list.sys_ObjectId = bi.ReportedBy WHERE list.Name LIKE 'V%'

103. [Join] 2.2
     SELECT p.* AS col_0 FROM Person p JOIN BacklogItem bi ON p.sys_ObjectId = bi.MoreInfoFrom

104. [Join] 2.2 (distinct result)
     SELECT DISTINCT p.* AS col_0 FROM Person p JOIN BacklogItem bi ON p.sys_ObjectId = bi.MoreInfoFrom

105. [Join] 2.2.2 (just changed table order in join comparing to 2.2)
     SELECT p.* AS col_0 FROM BacklogItem bi JOIN Person p ON bi.MoreInfoFrom = p.sys_ObjectId

106. [Join] 2.2.2 (just changed table order in join comparing to 2.2) (distinct result)
     SELECT DISTINCT p.* AS col_0 FROM BacklogItem bi JOIN Person p ON bi.MoreInfoFrom = p.sys_ObjectId

107. [Join] 2.3
     SELECT bi.* AS col_0 FROM BacklogItem bi JOIN Person p ON bi.MoreInfoFrom = p.sys_ObjectId ORDER BY p.Name DESC, bi.Name

108. [Join] 2.4
     SELECT t.* AS col_0 FROM Task t LEFT JOIN All a ON t.AllAttributes = a.sys_ObjectId

109. [Join] 2.4 (distinct result)
     SELECT DISTINCT t.* AS col_0 FROM Task t LEFT JOIN All a ON t.AllAttributes = a.sys_ObjectId

110. [Join] 2.4.1
     SELECT p.* AS col_0 FROM Project p JOIN All a ON p.AllAttributes = a.sys_ObjectId ORDER BY a.Name, p.Name

111. [Join] 3.1
     SELECT bi.* AS col_0 FROM BacklogItem bi JOIN Task t ON bi.Tasks = t.sys_ObjectId

112. [Join] 3.1 (distinct result)
     SELECT DISTINCT bi.* AS col_0 FROM BacklogItem bi JOIN Task t ON bi.Tasks = t.sys_ObjectId

113. [Join] 3.1.1
     SELECT bi.* AS col_0 FROM BacklogItem bi JOIN BacklogItem bi2 ON bi.Description = bi2.sys_ObjectId

114. [Join] 3.1.2
     SELECT t1.* AS col_0 FROM All t1 JOIN All t2 ON t1.Description = t2.sys_ObjectId WHERE t1.Template = 'BacklogItem' AND t2.Template = 'BacklogItem'

115. [Join] 3.1.3
     SELECT t.* AS col_0 FROM Task t JOIN BacklogItem bi ON t.sys_ObjectId = bi.Tasks

116. [Join] 3.1.4 (just changed table order comparing to 3.1.3)
     SELECT t.* AS col_0 FROM BacklogItem bi JOIN Task t ON t.sys_ObjectId = bi.Tasks

117. [Join] 3.2
     SELECT t.* AS col_0 FROM BacklogItem bi JOIN Task t ON t.sys_ObjectId = bi.Tasks WHERE t.Name LIKE '%nt'

118. [Join] 3.3
     SELECT bi.* AS col_0 FROM BacklogItem bi JOIN Task t ON t.sys_ObjectId = bi.Tasks ORDER BY t.Name DESC, bi.Name

119. [Join] 3.3 (distinct result)
     SELECT DISTINCT bi.* AS col_0 FROM BacklogItem bi JOIN Task t ON t.sys_ObjectId = bi.Tasks ORDER BY t.Name DESC

120. [Join] 3.4
     SELECT bi.* AS col_0 FROM BacklogItem bi JOIN All all ON all.sys_ObjectId = bi.AllAttributes WHERE all.Template = 'BacklogItem'

121. [Join] 3.4 (distinct result)
     SELECT DISTINCT bi.* AS col_0 FROM BacklogItem bi JOIN All all ON all.sys_ObjectId = bi.AllAttributes WHERE all.Template = 'BacklogItem'

122. [Join] 4.1
     SELECT bi.* AS col_0 FROM BacklogItem bi JOIN Task t ON t.sys_ObjectId = bi.Tasks JOIN Milestone m ON m.sys_ObjectId = bi.Milestone WHERE t.Name LIKE '%nt'

123. [Join] 4.1 (distinct result)
     SELECT DISTINCT bi.* AS col_0 FROM BacklogItem bi JOIN Task t ON t.sys_ObjectId = bi.Tasks JOIN Milestone m ON m.sys_ObjectId = bi.Milestone WHERE t.Name LIKE '%nt'

124. [Join] 4.1.3
     SELECT bi.* AS col_0 FROM BacklogItem bi LEFT JOIN Task t ON t.sys_ObjectId = bi.Tasks JOIN Milestone m ON m.sys_ObjectId = bi.Milestone

125. [Join] 4.1.3 (distinct result)
     SELECT DISTINCT bi.* AS col_0 FROM BacklogItem bi LEFT JOIN Task t ON t.sys_ObjectId = bi.Tasks JOIN Milestone m ON m.sys_ObjectId = bi.Milestone

126. [Join] 4.2
     SELECT bi.* AS col_0 FROM BacklogItem bi JOIN Task t ON t.sys_ObjectId = bi.Tasks JOIN Person p1 ON p1.sys_ObjectId = bi.ReportedBy JOIN Person p2 ON p2.sys_ObjectId = t.Responsible WHERE p1.Name = p2.Name

127. [Join] 4.2 (distinct result)
     SELECT DISTINCT bi.* AS col_0 FROM BacklogItem bi JOIN Task t ON t.sys_ObjectId = bi.Tasks JOIN Person p1 ON p1.sys_ObjectId = bi.ReportedBy JOIN Person p2 ON p2.sys_ObjectId = t.Responsible WHERE p1.Name = p2.Name

128. [Join] 4.2.1
     SELECT t.* AS col_0 FROM BacklogItem bi JOIN Task t ON t.sys_ObjectId = bi.Tasks JOIN Person p1 ON p1.sys_ObjectId = bi.ReportedBy JOIN Person p2 ON p2.sys_ObjectId = t.Responsible WHERE p1.Name = p2.Name

129. [Join] 4.3
     SELECT bi.* AS col_0 FROM BacklogItem bi JOIN Task t ON t.sys_ObjectId = bi.Tasks JOIN TaskStatus ts ON ts.sys_ObjectId = t.Status JOIN Person p ON p.sys_ObjectId = bi.ReportedBy WHERE ts.Name = 'Open' AND CAST(bi.Id as int) > 4000 ORDER BY bi.Name DESC

130. [Join] 4.3 (distinct result)
     SELECT DISTINCT bi.* AS col_0 FROM BacklogItem bi JOIN Task t ON t.sys_ObjectId = bi.Tasks JOIN TaskStatus ts ON ts.sys_ObjectId = t.Status JOIN Person p ON p.sys_ObjectId = bi.ReportedBy WHERE ts.Name = 'Open' AND CAST(bi.Id as int) > 4000 ORDER BY bi.Name DESC

131. [AttributeChain] 1.0
     SELECT bi.* AS col_0 FROM BacklogItem bi WHERE bi.ReportedBy.Name LIKE 'V%' AND bi.Status.Name = 'Done'

132. [AttributeChain] 1.1
     SELECT bi.* AS col_0 FROM BacklogItem bi WHERE bi.Status.Name = 'Done' OR bi.Status.Name = 'Registered'

133. [AttributeChain] 1.2
     SELECT bi.* AS col_0 FROM BacklogItem bi WHERE bi.Status.Name = 'Done' AND CAST(bi.Id as int) <= 4000

134. [AttributeChain] 1.3
     SELECT bi.* AS col_0 FROM BacklogItem bi WHERE bi.Status.Name <> 'Done'

135. [AttributeChain] 1.4.1
     SELECT bi.* AS col_0 FROM BacklogItem bi WHERE CAST(bi.MoreInfoFrom AS SingleLink) <> ''

136. [AttributeChain] 1.4.2
     SELECT bi.* AS col_0 FROM BacklogItem bi WHERE CAST(bi.MoreInfoFrom AS SingleLink) <> '' ORDER BY bi.MoreInfoFrom.Name, bi.Name

137. [AttributeChain] 1.5
     SELECT bi.* AS col_0 FROM BacklogItem bi WHERE CAST(bi.MoreInfoFrom AS SingleLink) = ''

138. [AttributeChain] 1.6 (empty result)
     SELECT bi.* AS col_0 FROM BacklogItem bi WHERE bi.nonExistingAttr.Name = 'Done'

139. [AttributeChain] 1.7 (empty result)
     SELECT bi.* AS col_0 FROM NonExistingTemplate bi WHERE bi.Status.Name = 'Done'

140. [AttributeChain] 1.8.1
     SELECT bi.* AS col_0 FROM BacklogItem bi ORDER BY bi.ReportedBy.Name, bi.Name

141. [AttributeChain] 1.8.2
     SELECT bi.* AS col_0 FROM BacklogItem bi ORDER BY bi.ReportedBy.Name, bi.Name DESC

142. [AttributeChain] 1.9
     SELECT bi.* AS col_0 FROM BacklogItem bi ORDER BY bi.ReportedBy.Name, bi.Status.Name, bi.Name DESC

143. [AttributeChain] 2.0
     SELECT bi.* AS col_0 FROM BacklogItem bi JOIN Project pr ON pr.sys_ObjectId = bi.Project ORDER BY bi.Project.Name, pr.Manager.Name, bi.Name

144. [AttributeChain] 2.1
     SELECT bi.* AS col_0 FROM BacklogItem bi WHERE bi.Project.Manager.Name <> 'Valeriy Kuchkovskyy'

145. [AttributeChain] 2.2 (attribute chain on multilink)
     SELECT bi.* AS col_0 FROM BacklogItem bi WHERE bi.Tasks.Name = 'Test'

146. [AttributeChain] 3.0
     SELECT t.* AS col_0 FROM Task t WHERE t.SimilarTask.SimilarTask.SimilarTask.SimilarTask.Name = 'AttributeChain1'

147. [AttributeChain] 3.1
     SELECT t.* AS col_0 FROM Task t WHERE t.ShortDescription.ShortDescription.ShortDescription.ShortDescription.Name = 'AttributeChain2'

148. [AttributeChain] 3.2
     SELECT t.* AS col_0 FROM Task t WHERE t.SimilarTask.SimilarTask.SimilarTask.SimilarTask.Name = 'AttributeChain1' OR t.ShortDescription.ShortDescription.ShortDescription.ShortDescription.Name = 'AttributeChain2'

149. [AttributeChain] 4.1 Select a singlelink
     SELECT CAST(bi.ReportedBy AS SingleLink) AS Result FROM BacklogItem bi ORDER BY bi.Name

150. [TableValued] Description as String - 0
     SELECT CAST (bi.Description AS VARCHAR) AS Description FROM BacklogItem bi

151. [TableValued] Description as String - 1
     SELECT CAST (bi.Description AS VARCHAR) AS col_0 FROM BacklogItem bi

152. [TableValued] Description as String - 2
     SELECT CAST (bi.Description AS XhtmlText) AS col_0 FROM BacklogItem bi

153. [TableValued] Description as XhtmlText - 0
     SELECT CAST (bi.Description AS XhtmlText) AS col_0 FROM BacklogItem bi

154. [TableValued] Description as IAttributeValue - 0
     SELECT CAST (bi.Description AS AttributeValue) AS col_0 FROM BacklogItem bi

155. [TableValued] Description as XhtmlText - 1
     SELECT CAST (bi.Description AS AttributeValue) AS col_0 FROM BacklogItem bi

156. [TableValued] Complexity as String - 0
     SELECT CAST (bi.Complexity AS VARCHAR) AS Complexity FROM BacklogItem bi

157. [TableValued] Complexity as String - 1
     SELECT CAST (bi.Complexity AS VARCHAR) AS col_0 FROM BacklogItem bi

158. [TableValued] Complexity as String - 2
     SELECT CAST (bi.Complexity AS PlainText) AS col_0 FROM BacklogItem bi

159. [TableValued] Complexity as PlainText - 0
     SELECT CAST (bi.Complexity AS PlainText) AS col_0 FROM BacklogItem bi

160. [TableValued] Complexity as IAttributeValue - 0
     SELECT CAST (bi.Complexity AS AttributeValue) AS col_0 FROM BacklogItem bi

161. [TableValued] Id as Int32 - 0
     SELECT CAST (bi.Id AS INT) AS Id FROM BacklogItem bi

162. [TableValued] Id as Int32 - 1
     SELECT CAST (bi.Id AS VARCHAR) AS col_0 FROM BacklogItem bi

163. [TableValued] Id as Int32 - 2
     SELECT CAST (bi.Id AS INT) AS col_0 FROM BacklogItem bi

164. [TableValued] Id as String - 0
     SELECT CAST (bi.Id AS INT) AS Id FROM BacklogItem bi

165. [TableValued] Id as String - 1
     SELECT CAST (bi.Id AS PlainText) AS col_0 FROM BacklogItem bi

166. [TableValued] Id as String - 2
     SELECT CAST (bi.Id AS PlainText) AS col_0 FROM BacklogItem bi

167. [TableValued] Id as String - 3
     SELECT CAST (bi.Id AS VARCHAR) AS col_0 FROM BacklogItem bi

168. [TableValued] Id as PlainText - 0
     SELECT CAST (bi.Id AS PlainText) AS col_0 FROM BacklogItem bi

169. [TableValued] Id as IAttributeValue - 0
     SELECT CAST (bi.Id AS AttributeValue) AS col_0 FROM BacklogItem bi

170. [TableValued] ApprovalDate as DateTime - 0
     SELECT CAST (bi.ApprovalDate AS DATETIME) AS ApprovalDate FROM BacklogItem bi

171. [TableValued] ApprovalDate as DateTime - 1
     SELECT CAST (bi.ApprovalDate AS DATETIME) AS col_0 FROM BacklogItem bi

172. [TableValued] ApprovalDate as String - 0
     SELECT CAST (bi.ApprovalDate AS QDateTime) AS col_0 FROM BacklogItem bi

173. [TableValued] ApprovalDate as String - 1
     SELECT CAST (bi.ApprovalDate AS VARCHAR) AS col_0 FROM BacklogItem bi

174. [TableValued] ApprovalDate as QDateTime - 0
     SELECT CAST (bi.ApprovalDate AS QDateTime) AS col_0 FROM BacklogItem bi

175. [TableValued] ApprovalDate as IAttributeValue - 0
     SELECT CAST (bi.ApprovalDate AS AttributeValue) AS col_0 FROM BacklogItem bi

176. [TableValued] IncludeInReleaseHistory as Boolean - 0
     SELECT CAST (bi.IncludeInReleaseHistory AS BIT) AS IncludeInReleaseHistory FROM BacklogItem bi

177. [TableValued] IncludeInReleaseHistory as Boolean - 1
     SELECT CAST (bi.IncludeInReleaseHistory AS BIT) AS col_0 FROM BacklogItem bi

178. [TableValued] IncludeInReleaseHistory as String - 0
     SELECT CAST (bi.IncludeInReleaseHistory AS PlainText) AS col_0 FROM BacklogItem bi

179. [TableValued] IncludeInReleaseHistory as String - 1
     SELECT CAST (bi.IncludeInReleaseHistory AS VARCHAR) AS col_0 FROM BacklogItem bi

180. [TableValued] IncludeInReleaseHistory as PlainText - 0
     SELECT CAST (bi.IncludeInReleaseHistory AS PlainText) AS col_0 FROM BacklogItem bi

181. [TableValued] IncludeInReleaseHistory as IAttributeValue - 0
     SELECT CAST (bi.IncludeInReleaseHistory AS AttributeValue) AS col_0 FROM BacklogItem bi

182. [TableValued] ReportedBy as String - 0
     SELECT CAST (bi.ReportedBy AS SingleLink) AS col_0 FROM BacklogItem bi

183. [TableValued] ReportedBy as String - 1
     SELECT CAST (bi.ReportedBy AS VARCHAR) AS col_0 FROM BacklogItem bi

184. [TableValued] ReportedBy as SingleLink - 0
     SELECT CAST (bi.ReportedBy AS SingleLink) AS col_0 FROM BacklogItem bi

185. [TableValued] ReportedBy as IAttributeValue - 0
     SELECT CAST (bi.ReportedBy AS AttributeValue) AS col_0 FROM BacklogItem bi

186. [TableValued] Tasks as String - 0
     SELECT CAST (bi.Tasks AS VARCHAR) AS col_0 FROM BacklogItem bi

187. [TableValued] Tasks as MultiLink - 0
     SELECT CAST (bi.Tasks AS MultiLink) AS col_0 FROM BacklogItem bi

188. [TableValued] Tasks as IAttributeValue - 0
     SELECT CAST (bi.Tasks AS AttributeValue) AS col_0 FROM BacklogItem bi

189. [TableValued] One column
     SELECT bi.Name FROM BacklogItem bi

190. [TableValued] One column - Language
     SELECT bi.sys_Language FROM BacklogItem bi

191. [TableValued] One column - without anonymous type
     SELECT bi.Name FROM BacklogItem bi

192. [TableValued] Direct access columns
     SELECT bi.sys_Language, CAST(bi.sys_Language AS VARCHAR) AS strLang, CAST(bi.sys_Created AS VARCHAR) as sys_Created, bi.sys_Created AS typedCreated FROM BacklogItem bi

193. [TableValued] Two columns
     SELECT bi.Complexity, bi.Name FROM BacklogItem bi ORDER BY bi.sys_Created

194. [TableValued] Two tables
     SELECT bi.sys_ObjectId AS bi_id, bi.sys_Language AS bi_lang, p.sys_ObjectId AS p_id, p.sys_Language AS p_lang FROM BacklogItem bi JOIN Person p ON p.sys_ObjectId = bi.ReportedBy

195. [TableValued] Attribute chains in original format
     SELECT bi.sys_RevisionId AS r1, bi.sys_Created AS c1, bi.MoreInfoFrom.sys_RevisionId AS r2, bi.MoreInfoFrom.sys_Created AS c2 FROM BacklogItem bi

196. [TableValued] Three types of custom attributes
     SELECT CAST (bi.Id AS PlainText) AS Original, CAST(bi.Id AS VARCHAR) AS String, CAST(bi.Id AS Int) AS Int FROM BacklogItem bi

197. [TableValued] All predefined untyped attribute values
     SELECT 
                CAST(bi.IsDeleted AS VARCHAR),
                CAST(bi.IsFrozen AS VARCHAR),
                bi.Name,
                CAST(bi.sys_BaseConfigurationId AS VARCHAR),
                CAST(bi.sys_ConfigurationId AS VARCHAR),
                CAST(bi.sys_ConfigurationStatusModified AS VARCHAR),
                CAST(bi.sys_Created AS VARCHAR),
                bi.sys_CreatedBy,
                CAST(bi.sys_Id AS VARCHAR),
                CAST(bi.sys_IsDefaultRevision AS VARCHAR),
                CAST(bi.sys_IsInheritedRevision AS VARCHAR),
                CAST(bi.sys_IsPrivateWorkspace AS VARCHAR),
                CAST(bi.sys_IsSynchronized AS VARCHAR),
                CAST(bi.sys_Language AS VARCHAR),
                CAST(bi.sys_LocalRevision AS VARCHAR),
                CAST(bi.sys_Modified AS VARCHAR),
                bi.sys_ModifiedBy,
                CAST(bi.sys_ObjectId AS VARCHAR),
                CAST(bi.sys_ObjectStatus AS VARCHAR),
                CAST(bi.sys_ObjectVersion AS VARCHAR),
                CAST(bi.sys_Owner AS VARCHAR),
                CAST(bi.sys_OwnerGroup AS VARCHAR),
                CAST(bi.sys_ParentRevision AS VARCHAR),
                CAST(bi.sys_RepositoryId AS VARCHAR),
                CAST(bi.sys_RevisionId AS VARCHAR),
                CAST(bi.sys_Type AS VARCHAR),
                bi.Template
                FROM BacklogItem bi ORDER BY bi.Name

198. [TableValued] All predefined typed attribute values
     SELECT
                    bi.IsDeleted,
                    bi.IsFrozen,
                    bi.Name,
                    bi.sys_BaseConfigurationId,
                    bi.sys_ConfigurationId,
                    bi.sys_ConfigurationStatusModified,
                    bi.sys_Created,
                    bi.sys_CreatedBy,
                    bi.sys_Id,
                    bi.sys_IsDefaultRevision,
                    bi.sys_IsInheritedRevision,
                    bi.sys_IsPrivateWorkspace,
                    bi.sys_IsSynchronized,
                    bi.sys_Language,
                    bi.sys_LocalRevision,
                    bi.sys_Modified,
                    bi.sys_ModifiedBy,
                    bi.sys_ObjectId,
                    bi.sys_ObjectStatus,
                    bi.sys_ObjectVersion,
                    bi.sys_Owner,
                    bi.sys_OwnerGroup,
                    bi.sys_ParentRevision,
                    bi.sys_RepositoryId,
                    bi.sys_RevisionId,
                    bi.sys_Type,
                    bi.Template
                FROM BacklogItem bi

199. [TableValued] All predefined typed/untyped attribute values
     SELECT
                    bi.IsDeleted,
                    bi.IsFrozen,
                    bi.Name,
                    bi.sys_BaseConfigurationId,
                    bi.sys_ConfigurationId,
                    bi.sys_ConfigurationStatusModified,
                    bi.sys_Created,
                    bi.sys_CreatedBy,
                    bi.sys_Id,
                    bi.sys_IsDefaultRevision,
                    bi.sys_IsInheritedRevision,
                    bi.sys_IsPrivateWorkspace,
                    bi.sys_IsSynchronized,
                    bi.sys_Language,
                    bi.sys_LocalRevision,
                    bi.sys_Modified,
                    bi.sys_ModifiedBy,
                    bi.sys_ObjectId,
                    bi.sys_ObjectStatus,
                    bi.sys_ObjectVersion,
                    bi.sys_Owner,
                    bi.sys_OwnerGroup,
                    bi.sys_ParentRevision,
                    bi.sys_RepositoryId,
                    bi.sys_RevisionId,
                    bi.sys_Type,
                    bi.Template,
                    CAST(bi.IsDeleted AS VARCHAR) AS untyped_IsDeleted,
                    CAST(bi.IsFrozen AS VARCHAR) AS untyped_IsFrozen,
                    bi.Name AS untyped_Name,
                    CAST(bi.sys_BaseConfigurationId AS VARCHAR) AS untyped_sys_BaseConfigurationId,
                    CAST(bi.sys_ConfigurationId AS VARCHAR) AS untyped_sys_ConfigurationId,
                    CAST(bi.sys_ConfigurationStatusModified AS VARCHAR) AS untyped_sys_ConfigurationStatusModified,
                    CAST(bi.sys_Created AS VARCHAR) AS untyped_sys_Created,
                    bi.sys_CreatedBy AS untyped_sys_CreatedBy,
                    CAST(bi.sys_Id AS VARCHAR) AS untyped_sys_Id,
                    CAST(bi.sys_IsDefaultRevision AS VARCHAR) AS untyped_sys_IsDefaultRevision,
                    CAST(bi.sys_IsInheritedRevision AS VARCHAR) AS untyped_sys_IsInheritedRevision,
                    CAST(bi.sys_IsPrivateWorkspace AS VARCHAR) AS untyped_sys_IsPrivateWorkspace,
                    CAST(bi.sys_IsSynchronized AS VARCHAR) AS untyped_sys_IsSynchronized,
                    CAST(bi.sys_Language AS VARCHAR) AS untyped_sys_Language,
                    CAST(bi.sys_LocalRevision AS VARCHAR) AS untyped_sys_LocalRevision,
                    CAST(bi.sys_Modified AS VARCHAR) AS untyped_sys_Modified,
                    bi.sys_ModifiedBy AS untyped_sys_ModifiedBy,
                    CAST(bi.sys_ObjectId AS VARCHAR) AS untyped_sys_ObjectId,
                    CAST(bi.sys_ObjectStatus AS VARCHAR) AS untyped_sys_ObjectStatus,
                    CAST(bi.sys_ObjectVersion AS VARCHAR) AS untyped_sys_ObjectVersion,
                    CAST(bi.sys_Owner AS VARCHAR) AS untyped_sys_Owner,
                    CAST(bi.sys_OwnerGroup AS VARCHAR) AS untyped_sys_OwnerGroup,
                    CAST(bi.sys_ParentRevision AS VARCHAR) AS untyped_sys_ParentRevision,
                    CAST(bi.sys_RepositoryId AS VARCHAR) AS untyped_sys_RepositoryId,
                    CAST(bi.sys_RevisionId AS VARCHAR) AS untyped_sys_RevisionId,
                    CAST(bi.sys_Type AS VARCHAR) AS untyped_sys_Type,
                    bi.Template AS untyped_Template
                FROM BacklogItem bi

200. [TemplateSet] 1
     SELECT ts.* AS col_0 FROM TemplateSet(BacklogItem,Person,Milestone) ts

201. [TemplateSet] 2
     SELECT ts.* AS col_0 FROM TemplateSet(TaskStatus,ItemStatus,Project) ts

202. [TemplateSet] 3
     SELECT ts.* AS col_0 FROM TemplateSet(TaskStatus,ItemStatus,Project) ts WHERE ts.Name LIKE 'Q%'

203. [TemplateSet] 4.1.1
     SELECT ts.* AS col_0 FROM TemplateSet(BacklogItem) ts

204. [TemplateSet] 4.1.2
     SELECT ts.* AS col_0 FROM BacklogItem ts

205. [TemplateSet] 4.2.1
     SELECT ts.* AS col_0 FROM TemplateSet(Person) ts

206. [TemplateSet] 4.2.2
     SELECT ts.* AS col_0 FROM Person ts

207. [TemplateSet] 4.3.1
     SELECT ts.* AS col_0 FROM TemplateSet(Milestone) ts

208. [TemplateSet] 4.3.2
     SELECT ts.* AS col_0 FROM Milestone ts

209. [TemplateSet] 5
     SELECT p.* AS col_0 FROM TemplateSet(Person) p JOIN TemplateSet(BacklogItem) bi ON p.sys_ObjectId = bi.MoreInfoFrom

210. [Sorting] Order by Name
     SELECT bi.* AS col_0 FROM BacklogItem bi ORDER BY bi.Name

211. [Sorting] Order by Name (using LINQ extension methods)
     SELECT bi.* AS col_0 FROM BacklogItem bi ORDER BY bi.Name

212. [Sorting] Order by Name, Id (custom)
     SELECT bi.* AS col_0 FROM BacklogItem bi ORDER BY bi.Name, CAST(bi.Id as int)

213. [Sorting] Order by Id (custom), Name
     SELECT bi.* AS col_0 FROM BacklogItem bi ORDER BY CAST(bi.Id AS int), bi.Name

214. [Sorting] Order by Id (custom) DESC, Name
     SELECT bi.* AS col_0 FROM BacklogItem bi ORDER BY CAST(bi.Id AS int) desc, bi.Name

215. [Sorting] Order by unknownAttribute
     SELECT bi.* AS col_0 FROM BacklogItem bi ORDER BY CAST(bi.unknownAttribute AS VARCHAR), bi.Name

216. [Sorting] Order with empty result
     SELECT bi.* AS col_0 FROM BacklogItem bi WHERE bi.Name = 'no such name' ORDER BY bi.Name

217. [Sorting] Order by Multilink (distinct result)
     SELECT DISTINCT bi.* AS col_0 FROM BacklogItem bi ORDER BY bi.sys_Created, CAST(bi.Tasks.Name AS VARCHAR), CAST(bi.Id AS int)

218. [Sorting] Order by Multilink (result is not distinct)
     SELECT bi.* AS col_0 FROM BacklogItem bi ORDER BY bi.sys_Created, CAST(bi.Tasks.Name AS VARCHAR), CAST(bi.Id AS int)

219. [Sorting] Order by attribute chain
     SELECT bi.Name FROM BacklogItem bi ORDER BY bi.ReportedBy.Name, bi.Name

220. [Sorting] Order by attribute chain (distinct result)
     SELECT DISTINCT bi.Name FROM BacklogItem bi ORDER BY bi.ReportedBy.Name, bi.Name

221. [Sorting] Order by attribute chain, including sys_RevisionId (distinct result)
     SELECT DISTINCT bi.Name, bi.sys_RevisionId FROM BacklogItem bi ORDER BY bi.ReportedBy.Name, bi.Name

222. [ObjectList] Filter by revision and template
     SELECT list.* AS col_0 FROM REVISION LIST('9d17469f-91c5-40be-8781-981cbc0003c4','aecc3b48-9f5b-4289-99e7-b7de3d007bcc','92974222-fce2-4b5a-83f0-7c4282f369d6','14decd2b-2ad0-457c-b0b7-f8748e9fcd10','0bd806ac-814b-48ae-946c-bf150b52ffcd','73423fee-c4fa-489a-a68b-e976365bb4a9','fd60c506-585b-4587-8b69-e63e49efaaa4','4da2943f-5510-46ea-8e89-a63e2dbcde95','e2fa5f57-971e-43b2-8f15-fe093d371fb6','2dd48c8c-a262-4fd8-83e4-5cb42c3459c6','c2d70125-2e9d-4357-b005-585776795978','358f39e7-c723-4b91-8470-d61d6c662c22','ad48ddac-7eff-4d27-b560-090306362ebb','88104da1-ee29-4ebe-8991-4fc42cb73470','3cbd476c-ec1a-4555-b304-c6c3b33d9fd1','b161b316-e59a-4682-a6e4-06a0613fb02c') OF Person list WHERE list.Initials != 'YUS'

223. [ObjectList] Filter by id and template
     SELECT list.* AS col_0 FROM OBJECT List('209e09ed-7e40-48ce-8dd3-bd4d05e36df8','9bf4b1c8-bdf9-4c76-84c0-b16d99675da3','cf0c0c05-9c63-4a18-b644-701098537fad','4e69664a-5487-4a48-ab1c-d97a2682695d','d13e9696-10ac-42aa-bbb8-28d621943413','8e537c8d-6900-4ac6-aa89-18cc923b399e','cc2d16f4-a829-410b-9a05-d0558cd358c1','c4e24174-0632-4c55-a311-a134950a554a','aafc4b5a-5fe9-47af-9449-1c2d8edcdee8','98599e25-d504-4c73-9d7c-4af6188766f8','fd2ede26-6d55-4d44-8340-86d10a91800a','cc73b44f-1d6b-41b4-8c8a-d2e8410ad0f3','e5dc537a-0072-4efd-b537-acd542478fdf','1727a497-9912-423b-9ebe-b4c60ae40a15','4bbc14ea-e1d4-4977-88aa-440d4b20d90b','7c16d118-bc85-49d2-8fd3-d3c5fcdac6d9') OF Person list WHERE list.Initials != 'YUS'

224. [ObjectList] Join two tables with object lists
     SELECT l1.Name as Name1, l2.Name as Name2 FROM REVISION LIST('9d17469f-91c5-40be-8781-981cbc0003c4') l1 CROSS JOIN OBJECT LIST('209e09ed-7e40-48ce-8dd3-bd4d05e36df8') l2

225. [ObjectList] One template case 1
     SELECT list.* AS col_0 FROM REVISION List('9d17469f-91c5-40be-8781-981cbc0003c4','aecc3b48-9f5b-4289-99e7-b7de3d007bcc','92974222-fce2-4b5a-83f0-7c4282f369d6','14decd2b-2ad0-457c-b0b7-f8748e9fcd10','0bd806ac-814b-48ae-946c-bf150b52ffcd','73423fee-c4fa-489a-a68b-e976365bb4a9','fd60c506-585b-4587-8b69-e63e49efaaa4','4da2943f-5510-46ea-8e89-a63e2dbcde95','e2fa5f57-971e-43b2-8f15-fe093d371fb6','2dd48c8c-a262-4fd8-83e4-5cb42c3459c6','c2d70125-2e9d-4357-b005-585776795978','358f39e7-c723-4b91-8470-d61d6c662c22') list

226. [ObjectList] One template case 2
     SELECT list.* AS col_0 FROM REVISION List('9d17469f-91c5-40be-8781-981cbc0003c4','aecc3b48-9f5b-4289-99e7-b7de3d007bcc','92974222-fce2-4b5a-83f0-7c4282f369d6','14decd2b-2ad0-457c-b0b7-f8748e9fcd10','0bd806ac-814b-48ae-946c-bf150b52ffcd','73423fee-c4fa-489a-a68b-e976365bb4a9','fd60c506-585b-4587-8b69-e63e49efaaa4','4da2943f-5510-46ea-8e89-a63e2dbcde95','e2fa5f57-971e-43b2-8f15-fe093d371fb6','2dd48c8c-a262-4fd8-83e4-5cb42c3459c6','c2d70125-2e9d-4357-b005-585776795978','358f39e7-c723-4b91-8470-d61d6c662c22') list WHERE list.Name LIKE 'V%' ORDER BY list.Name

227. [ObjectList] One template case 3 (list of object ids)
     SELECT list.* AS col_0 FROM OBJECT List('209e09ed-7e40-48ce-8dd3-bd4d05e36df8','9bf4b1c8-bdf9-4c76-84c0-b16d99675da3','cf0c0c05-9c63-4a18-b644-701098537fad','4e69664a-5487-4a48-ab1c-d97a2682695d','d13e9696-10ac-42aa-bbb8-28d621943413','8e537c8d-6900-4ac6-aa89-18cc923b399e','cc2d16f4-a829-410b-9a05-d0558cd358c1','c4e24174-0632-4c55-a311-a134950a554a','aafc4b5a-5fe9-47af-9449-1c2d8edcdee8','98599e25-d504-4c73-9d7c-4af6188766f8','fd2ede26-6d55-4d44-8340-86d10a91800a','cc73b44f-1d6b-41b4-8c8a-d2e8410ad0f3') list WHERE list.Name LIKE 'V%' ORDER BY list.Name

228. [ObjectList] Several templates case 1
     SELECT list.* AS col_0 FROM REVISION List('9d17469f-91c5-40be-8781-981cbc0003c4','aecc3b48-9f5b-4289-99e7-b7de3d007bcc','92974222-fce2-4b5a-83f0-7c4282f369d6','14decd2b-2ad0-457c-b0b7-f8748e9fcd10','0bd806ac-814b-48ae-946c-bf150b52ffcd','73423fee-c4fa-489a-a68b-e976365bb4a9','fd60c506-585b-4587-8b69-e63e49efaaa4','4da2943f-5510-46ea-8e89-a63e2dbcde95','e2fa5f57-971e-43b2-8f15-fe093d371fb6','2dd48c8c-a262-4fd8-83e4-5cb42c3459c6','c2d70125-2e9d-4357-b005-585776795978','358f39e7-c723-4b91-8470-d61d6c662c22','7a6359e2-35f1-4fe7-baf9-15be09d9a77c','2221ddd6-5de1-4221-b830-3135a91c094e','5c1f0583-ff35-4457-8b47-6f14936097e3','694e9dcb-dd6d-4c29-a35b-1798fdc380b1','136eb5a9-b747-4f6c-af5a-7d8d7afe476e','09d59157-b0c5-4b37-8db1-ba206941ee93','859dd6f6-acad-42c2-b690-fcc2be6f16c0','006a7a5f-d62d-4e53-8a14-86d64c292179','ad48ddac-7eff-4d27-b560-090306362ebb','88104da1-ee29-4ebe-8991-4fc42cb73470','3cbd476c-ec1a-4555-b304-c6c3b33d9fd1','b161b316-e59a-4682-a6e4-06a0613fb02c') list

229. [ObjectList] Several templates case 2
     SELECT list.* AS col_0 FROM REVISION List('9d17469f-91c5-40be-8781-981cbc0003c4','aecc3b48-9f5b-4289-99e7-b7de3d007bcc','92974222-fce2-4b5a-83f0-7c4282f369d6','14decd2b-2ad0-457c-b0b7-f8748e9fcd10','0bd806ac-814b-48ae-946c-bf150b52ffcd','73423fee-c4fa-489a-a68b-e976365bb4a9','fd60c506-585b-4587-8b69-e63e49efaaa4','4da2943f-5510-46ea-8e89-a63e2dbcde95','e2fa5f57-971e-43b2-8f15-fe093d371fb6','2dd48c8c-a262-4fd8-83e4-5cb42c3459c6','c2d70125-2e9d-4357-b005-585776795978','358f39e7-c723-4b91-8470-d61d6c662c22','7a6359e2-35f1-4fe7-baf9-15be09d9a77c','2221ddd6-5de1-4221-b830-3135a91c094e','5c1f0583-ff35-4457-8b47-6f14936097e3','694e9dcb-dd6d-4c29-a35b-1798fdc380b1','136eb5a9-b747-4f6c-af5a-7d8d7afe476e','09d59157-b0c5-4b37-8db1-ba206941ee93','859dd6f6-acad-42c2-b690-fcc2be6f16c0','006a7a5f-d62d-4e53-8a14-86d64c292179','ad48ddac-7eff-4d27-b560-090306362ebb','88104da1-ee29-4ebe-8991-4fc42cb73470','3cbd476c-ec1a-4555-b304-c6c3b33d9fd1','b161b316-e59a-4682-a6e4-06a0613fb02c') list WHERE list.Name LIKE '%a%' ORDER BY list.Name

230. [ObjectList] Several templates case 3 - Person
     SELECT list.* AS col_0 FROM REVISION List('9d17469f-91c5-40be-8781-981cbc0003c4','aecc3b48-9f5b-4289-99e7-b7de3d007bcc','92974222-fce2-4b5a-83f0-7c4282f369d6','14decd2b-2ad0-457c-b0b7-f8748e9fcd10','0bd806ac-814b-48ae-946c-bf150b52ffcd','73423fee-c4fa-489a-a68b-e976365bb4a9','fd60c506-585b-4587-8b69-e63e49efaaa4','4da2943f-5510-46ea-8e89-a63e2dbcde95','e2fa5f57-971e-43b2-8f15-fe093d371fb6','2dd48c8c-a262-4fd8-83e4-5cb42c3459c6','c2d70125-2e9d-4357-b005-585776795978','358f39e7-c723-4b91-8470-d61d6c662c22','7a6359e2-35f1-4fe7-baf9-15be09d9a77c','2221ddd6-5de1-4221-b830-3135a91c094e','5c1f0583-ff35-4457-8b47-6f14936097e3','694e9dcb-dd6d-4c29-a35b-1798fdc380b1','136eb5a9-b747-4f6c-af5a-7d8d7afe476e','09d59157-b0c5-4b37-8db1-ba206941ee93','859dd6f6-acad-42c2-b690-fcc2be6f16c0','006a7a5f-d62d-4e53-8a14-86d64c292179','ad48ddac-7eff-4d27-b560-090306362ebb','88104da1-ee29-4ebe-8991-4fc42cb73470','3cbd476c-ec1a-4555-b304-c6c3b33d9fd1','b161b316-e59a-4682-a6e4-06a0613fb02c') list WHERE list.Template = 'Person' ORDER BY list.Name

231. [ObjectList] Several templates case 3 - Milestone
     SELECT list.* AS col_0 FROM REVISION List('9d17469f-91c5-40be-8781-981cbc0003c4','aecc3b48-9f5b-4289-99e7-b7de3d007bcc','92974222-fce2-4b5a-83f0-7c4282f369d6','14decd2b-2ad0-457c-b0b7-f8748e9fcd10','0bd806ac-814b-48ae-946c-bf150b52ffcd','73423fee-c4fa-489a-a68b-e976365bb4a9','fd60c506-585b-4587-8b69-e63e49efaaa4','4da2943f-5510-46ea-8e89-a63e2dbcde95','e2fa5f57-971e-43b2-8f15-fe093d371fb6','2dd48c8c-a262-4fd8-83e4-5cb42c3459c6','c2d70125-2e9d-4357-b005-585776795978','358f39e7-c723-4b91-8470-d61d6c662c22','7a6359e2-35f1-4fe7-baf9-15be09d9a77c','2221ddd6-5de1-4221-b830-3135a91c094e','5c1f0583-ff35-4457-8b47-6f14936097e3','694e9dcb-dd6d-4c29-a35b-1798fdc380b1','136eb5a9-b747-4f6c-af5a-7d8d7afe476e','09d59157-b0c5-4b37-8db1-ba206941ee93','859dd6f6-acad-42c2-b690-fcc2be6f16c0','006a7a5f-d62d-4e53-8a14-86d64c292179','ad48ddac-7eff-4d27-b560-090306362ebb','88104da1-ee29-4ebe-8991-4fc42cb73470','3cbd476c-ec1a-4555-b304-c6c3b33d9fd1','b161b316-e59a-4682-a6e4-06a0613fb02c') list WHERE list.Template = 'Milestone' ORDER BY list.Name

232. [ObjectList] Several templates case 3 - ItemStatus
     SELECT list.* AS col_0 FROM REVISION List('9d17469f-91c5-40be-8781-981cbc0003c4','aecc3b48-9f5b-4289-99e7-b7de3d007bcc','92974222-fce2-4b5a-83f0-7c4282f369d6','14decd2b-2ad0-457c-b0b7-f8748e9fcd10','0bd806ac-814b-48ae-946c-bf150b52ffcd','73423fee-c4fa-489a-a68b-e976365bb4a9','fd60c506-585b-4587-8b69-e63e49efaaa4','4da2943f-5510-46ea-8e89-a63e2dbcde95','e2fa5f57-971e-43b2-8f15-fe093d371fb6','2dd48c8c-a262-4fd8-83e4-5cb42c3459c6','c2d70125-2e9d-4357-b005-585776795978','358f39e7-c723-4b91-8470-d61d6c662c22','7a6359e2-35f1-4fe7-baf9-15be09d9a77c','2221ddd6-5de1-4221-b830-3135a91c094e','5c1f0583-ff35-4457-8b47-6f14936097e3','694e9dcb-dd6d-4c29-a35b-1798fdc380b1','136eb5a9-b747-4f6c-af5a-7d8d7afe476e','09d59157-b0c5-4b37-8db1-ba206941ee93','859dd6f6-acad-42c2-b690-fcc2be6f16c0','006a7a5f-d62d-4e53-8a14-86d64c292179','ad48ddac-7eff-4d27-b560-090306362ebb','88104da1-ee29-4ebe-8991-4fc42cb73470','3cbd476c-ec1a-4555-b304-c6c3b33d9fd1','b161b316-e59a-4682-a6e4-06a0613fb02c') list WHERE list.Template = 'ItemStatus' ORDER BY list.Name

233. [ObjectList] Several templates case 3 - BacklogItem (empty result)
     SELECT list.* AS col_0 FROM REVISION List('9d17469f-91c5-40be-8781-981cbc0003c4','aecc3b48-9f5b-4289-99e7-b7de3d007bcc','92974222-fce2-4b5a-83f0-7c4282f369d6','14decd2b-2ad0-457c-b0b7-f8748e9fcd10','0bd806ac-814b-48ae-946c-bf150b52ffcd','73423fee-c4fa-489a-a68b-e976365bb4a9','fd60c506-585b-4587-8b69-e63e49efaaa4','4da2943f-5510-46ea-8e89-a63e2dbcde95','e2fa5f57-971e-43b2-8f15-fe093d371fb6','2dd48c8c-a262-4fd8-83e4-5cb42c3459c6','c2d70125-2e9d-4357-b005-585776795978','358f39e7-c723-4b91-8470-d61d6c662c22','7a6359e2-35f1-4fe7-baf9-15be09d9a77c','2221ddd6-5de1-4221-b830-3135a91c094e','5c1f0583-ff35-4457-8b47-6f14936097e3','694e9dcb-dd6d-4c29-a35b-1798fdc380b1','136eb5a9-b747-4f6c-af5a-7d8d7afe476e','09d59157-b0c5-4b37-8db1-ba206941ee93','859dd6f6-acad-42c2-b690-fcc2be6f16c0','006a7a5f-d62d-4e53-8a14-86d64c292179','ad48ddac-7eff-4d27-b560-090306362ebb','88104da1-ee29-4ebe-8991-4fc42cb73470','3cbd476c-ec1a-4555-b304-c6c3b33d9fd1','b161b316-e59a-4682-a6e4-06a0613fb02c') list WHERE list.Template = 'BacklogItem' ORDER BY list.Name

234. [TakeSkip] TOP 1
     SELECT TOP 1 o.* AS col_0 FROM BacklogItem o ORDER BY o.Name

235. [TakeSkip] TOP 10
     SELECT TOP 10 o.* AS col_0 FROM BacklogItem o ORDER BY o.Name

236. [TakeSkip] TOP 50
     SELECT TOP 50 o.* AS col_0 FROM BacklogItem o ORDER BY o.Name

237. [TakeSkip] TOP 1000
     SELECT TOP 1000 o.* AS col_0 FROM BacklogItem o ORDER BY o.Name

238. [TakeSkip] TOP with multilink join
     SELECT TOP 10 bi.* AS col_0 FROM BacklogItem bi JOIN Task t ON bi.Tasks=t.sys_ObjectId WHERE t.Name = 'Implement' ORDER BY bi.Name

239. [TakeSkip] TOP DISTINCT with multilink join (distinct result)
     SELECT DISTINCT TOP 10 bi.* AS col_0 FROM BacklogItem bi JOIN Task t ON bi.Tasks=t.sys_ObjectId WHERE t.Name = 'Implement' ORDER BY bi.Name

240. [TakeSkip] SKIP 5
     SELECT o.* AS col_0 FROM BacklogItem o ORDER BY o.Name OFFSET 5 ROWS

241. [TakeSkip] SKIP 30
     SELECT o.* AS col_0 FROM BacklogItem o ORDER BY o.Name OFFSET 30 ROWS

242. [TakeSkip] SKIP 50 (empty result)
     SELECT o.* AS col_0 FROM BacklogItem o ORDER BY o.Name OFFSET 50 ROWS

243. [TakeSkip] SKIP 1000 (empty result)
     SELECT o.* AS col_0 FROM BacklogItem o ORDER BY o.Name OFFSET 1000 ROWS

244. [TakeSkip] SKIP with multilink join
     SELECT bi.* AS col_0 FROM BacklogItem bi JOIN Task t ON bi.Tasks=t.sys_ObjectId WHERE t.Name = 'Implement' ORDER BY bi.Name OFFSET 5 ROWS

245. [TakeSkip] DISTINCT SKIP with multilink join (distinct result)
     SELECT DISTINCT bi.* AS col_0 FROM BacklogItem bi JOIN Task t ON bi.Tasks=t.sys_ObjectId WHERE t.Name = 'Implement' ORDER BY bi.Name OFFSET 5 ROWS

246. [TakeSkip] SKIP 0 TAKE 10
     SELECT o.* AS col_0 FROM BacklogItem o ORDER BY o.Name OFFSET 0 ROWS FETCH NEXT 10 ROWS ONLY

247. [TakeSkip] SKIP 10 TAKE 10
     SELECT o.* AS col_0 FROM BacklogItem o ORDER BY o.Name OFFSET 10 ROWS FETCH NEXT 10 ROWS ONLY

248. [TakeSkip] SKIP 20 TAKE 10
     SELECT o.* AS col_0 FROM BacklogItem o ORDER BY o.Name OFFSET 20 ROWS FETCH NEXT 10 ROWS ONLY

249. [TakeSkip] SKIP 30 TAKE 10
     SELECT o.* AS col_0 FROM BacklogItem o ORDER BY o.Name OFFSET 30 ROWS FETCH NEXT 10 ROWS ONLY

250. [TakeSkip] SKIP 40 TAKE 10
     SELECT o.* AS col_0 FROM BacklogItem o ORDER BY o.Name OFFSET 40 ROWS FETCH NEXT 10 ROWS ONLY

251. [TakeSkip] SKIP 50 TAKE 10 (empty result)
     SELECT o.* AS col_0 FROM BacklogItem o ORDER BY o.Name OFFSET 50 ROWS FETCH NEXT 10 ROWS ONLY

252. [TakeSkip] SKIP 60 TAKE 10 (empty result)
     SELECT o.* AS col_0 FROM BacklogItem o ORDER BY o.Name OFFSET 60 ROWS FETCH NEXT 10 ROWS ONLY

253. [TakeSkip] SKIP 70 TAKE 10 (empty result)
     SELECT o.* AS col_0 FROM BacklogItem o ORDER BY o.Name OFFSET 70 ROWS FETCH NEXT 10 ROWS ONLY

254. [TakeSkip] SKIP 80 TAKE 10 (empty result)
     SELECT o.* AS col_0 FROM BacklogItem o ORDER BY o.Name OFFSET 80 ROWS FETCH NEXT 10 ROWS ONLY

255. [TakeSkip] SKIP 90 TAKE 10 (empty result)
     SELECT o.* AS col_0 FROM BacklogItem o ORDER BY o.Name OFFSET 90 ROWS FETCH NEXT 10 ROWS ONLY

256. [TakeSkip] DISTINCT SKIP TOP with multilink join (distinct result)
     SELECT DISTINCT bi.* AS col_0 FROM BacklogItem bi JOIN Task t ON bi.Tasks=t.sys_ObjectId WHERE t.Name = 'Implement' ORDER BY bi.Name OFFSET 5 ROWS FETCH NEXT 3 ROWS ONLY

257. [TakeSkip] DISTINCT SKIP TOP with multilink join, order by grouped value (distinct result)
     SELECT DISTINCT bi.* AS col_0 FROM BacklogItem bi JOIN Task t ON bi.Tasks=t.sys_ObjectId WHERE t.Name = 'Implement' ORDER BY t.Name, bi.Name OFFSET 5 ROWS FETCH NEXT 3 ROWS ONLY

258. [Backward] All backward links
     SELECT backward.* AS col_0 FROM BacklogItem bi BACKWARD JOIN backward ON bi.AllAttributes = backward.sys_ObjectId

259. [Backward] All backward links, outer join
     SELECT bi.Name, backward.sys_ObjectId AS Backward FROM BacklogItem bi BACKWARD OUTER JOIN backward ON bi.AllAttributes = backward.sys_ObjectId

260. [Backward] All backward links in attribute
     SELECT bi.Name AS Name, bi.Links.Backward AS AllBackward FROM BacklogItem bi ORDER BY bi.Name

261. [Backward] All forward links in attribute
     SELECT bi.Name AS Name, bi.Links.Forward AS AllForward FROM BacklogItem bi ORDER BY bi.Name

262. [Backward] Backward links in specific attribute
     SELECT bi.Name AS Name, bi.Description.Links.Backward as BackwardDescription FROM BacklogItem bi ORDER BY bi.Name

263. [Backward] Forward links in specific attribute
     SELECT bi.Name AS Name, bi.Description.Links.Forward as ForwardDescription FROM BacklogItem bi ORDER BY bi.Name

264. [Backward] Not having forward links
     SELECT bi.Name FROM BacklogItem:Special:QualiWare bi WHERE bi.Links.Forward = '' AND CAST(bi.sys_ObjectId AS varchar) = '4402855c-85b4-4958-97bb-689e31a080d6'

265. [Backward] Not having backward links
     SELECT bi.Name FROM BacklogItem:Special:QualiWare bi WHERE bi.Links.Backward = '' AND CAST(bi.sys_ObjectId as varchar) = '4402855c-85b4-4958-97bb-689e31a080d6'

266. [Backward] Backward links chain
     SELECT bi.Links.Backward.Links.Backward.Links.Backward AS T1 
                    FROM BacklogItem bi 
                    WHERE bi.Links.Backward.Links.Backward.Links.Backward LIKE '%'
                    ORDER BY bi.Links.Backward.Links.Backward.Name

267. [Backward] Backward-forward links chain (distinct result)
     SELECT DISTINCT bi.Name AS N1, bi.Links.Backward.Links.Forward.Links.Backward.Name AS N2 FROM Task bi WHERE CAST(bi.sys_ObjectId AS varchar) = '3e7208d1-7c39-47c9-af55-31fbb5628e60'

268. [Backward] Mixed chain (distinct result)
     SELECT DISTINCT bi.Name AS N1, bi.Links.Backward.SimilarTask.SimilarTask.Links.Forward.SimilarTask.SimilarTask.Name AS N2
                FROM Task bi
                WHERE CAST(bi.sys_ObjectId AS varchar) = '3e7208d1-7c39-47c9-af55-31fbb5628e60' 
                    AND bi.Links.Backward.Links.Forward.SimilarTask.SimilarTask.Name = 'AttributeChain2'

269. [CrossJoin] Cross join without filter
     SELECT bi1.Name AS Name1, bi2.Name AS Name2 FROM BacklogItem bi1 CROSS JOIN BacklogItem bi2 ORDER BY bi1.Name, bi2.Name

270. [CrossJoin] Cross join with filter by person (attribute)
     SELECT bi.Name AS Name1, t.Name AS Name2 FROM BacklogItem bi CROSS JOIN Task t WHERE bi.ReportedBy = t.Responsible ORDER BY bi.Name, t.Name

271. [CrossJoin] Cross join with filter by person (uselist)
     SELECT bi.Name AS Name1, t.Name AS Name2 FROM BacklogItem bi CROSS JOIN Task t WHERE bi.ReportedBy.sys_Id = t.Responsible.sys_Id ORDER BY bi.Name, t.Name

272. [CrossJoin] Cross join with filter by description (multilink, uselist)
     SELECT bi1.Name AS Name1, bi2.Name AS Name2 FROM BacklogItem bi1 CROSS JOIN BacklogItem bi2 WHERE CAST(bi1.Description.sys_Id AS Varchar) = CAST(bi2.Description.sys_Id AS Varchar) ORDER BY bi1.Name, bi2.Name

273. [Contains] All contained objects in attribute
     SELECT bi.Name, bi.Graphical.Contains AS AllContained FROM StateDiagram bi ORDER BY bi.Name

274. [Contains] All objects containing current object
     SELECT bi.Name, bi.Graphical.Contained AS AllContaining FROM State bi ORDER BY bi.Name

275. [Contains] All contained links
     SELECT contains.* AS col_0 FROM StateDiagram bi GRAPHICAL CONTAINS JOIN contains ON bi.AllAttributes = contains.sys_ObjectId

276. [Contains] Not containing
     SELECT bi.Name FROM BacklogItem bi WHERE bi.Graphical.Contains = '' AND CAST(bi.sys_ObjectId as varchar) = 'f09d4450-e0fd-45fa-aa0a-38a57632762c'

277. [Contains] Not contained
     SELECT bi.Name FROM BacklogItem bi WHERE bi.Graphical.Contained = '' AND CAST(bi.sys_ObjectId as varchar) = 'f09d4450-e0fd-45fa-aa0a-38a57632762c'

278. [Contains] Obj1 is not contained in Obj2
     SELECT sd.Name FROM StateDiagram sd WHERE sd.Graphical.Contained NOT LIKE '%f09d4450-e0fd-45fa-aa0a-38a57632762c%' AND CAST(sd.sys_ObjectId as varchar) = 'a07dae12-4037-41a0-ab50-1670acb4b0de'

279. [Contains] Contains/contained chain
     SELECT bi.Graphical.Contains.Graphical.Contained.Name AS col_0 FROM StateDiagram AS bi

280. [Contains] Mixed chain
     SELECT bi.Graphical.Contains.SomeLink.SomeLink.Graphical.Contained.SomeLink.SomeLink.Links.Backward.SomeLink.Name AS T1
                FROM StateDiagram AS bi
                WHERE bi.Graphical.Contains.SomeLink.SomeLink.Graphical.Contained.SomeLink.SomeLink.Links.Backward.SomeLink.Name != ''

281. [GraphicalRelations] All sends to
     SELECT recipients.* AS col_0 FROM State bi GRAPHICAL SENDSTO JOIN recipients ON recipients.sys_ObjectId = bi.AllAttributes

282. [GraphicalRelations] All graphical relations (distinct result)
     SELECT DISTINCT bi.Graphical.Name AS col_0 FROM State bi ORDER BY bi.Graphical.Name

283. [GraphicalRelations] All graphical relations [join] (distinct result)
     SELECT DISTINCT recipients.Name FROM State bi GRAPHICAL JOIN recipients ON recipients.sys_ObjectId = bi.AllAttributes ORDER BY recipients.Name

284. [GraphicalRelations] Different relationed objects in attributes
     SELECT bi.Name AS Name, bi.Graphical.SendsTo AS AllSendsTo, bi.Graphical.ReceivesFrom AS AllReceivesFrom FROM State bi ORDER BY bi.Name

285. [GraphicalRelations] Diagram by name with object having sends to relation on it (distinct result)
     
                    SELECT DISTINCT contains.Name 
                    FROM All a 
                    GRAPHICAL CONTAINS JOIN contains ON a.AllAttributes = contains.sys_ObjectId 
                    GRAPHICAL SENDSTO JOIN c ON c.sys_ObjectId = contains.AllAttributes 
                    WHERE a.Name = 'Issue Stateflow' 
                        AND CAST(contains.sys_ObjectId as varchar) = '4e71ff6f-86fa-4f81-9388-23ab2919a4a4'

286. [GraphicalRelations] Not graphically related cases
     
                    SELECT bi.Name
                    FROM BacklogItem bi
                    WHERE bi.Graphical = '' AND CAST(bi.sys_ObjectId AS VARCHAR) = 'f09d4450-e0fd-45fa-aa0a-38a57632762c'

287. [GraphicalRelations] Graphical join chain case
     SELECT bi.Graphical.SendsTo.Graphical.ReceivesFrom.Graphical.SendsTo.Name AS N1, bi.Graphical.SendsTo.Graphical.ReceivesFrom.Name AS N2 
                FROM State bi
                WHERE bi.Graphical.SendsTo.Graphical.ReceivesFrom.Graphical.SendsTo.Name != ''

288. [GraphicalRelations] Mixed chain (distinct result)
     SELECT DISTINCT bi.Graphical.SendsTo.SomeLink.Graphical.Contained.SomeLink.SomeLink.Name AS T1 
                FROM State bi
                WHERE bi.Graphical.SendsTo.SomeLink.Graphical.Contained.SomeLink.SomeLink.Name != ''




Case number: 288