It's all about the answers!

Ask a question

Querying on a small string variable


Sterling Ferguson-II (1.6k8279269) | asked Jan 07 '15, 3:26 p.m.
RTC 405, 406
SQL Server

I have two fields that are type Small String and Editor Presentation String.

I want to run a query on one field using "exists"
The other query I want to run when field 2 is "blank"

The problem,

The first query and field return all records whether a value is there or not. The second query I can't figure how to search for a blank string.

Accepted answer


permanent link
Lily Wang (4.9k714) | answered Jan 09 '15, 1:35 a.m.
For the first query, you can use "is not". Then on Eclipse client check "Unassigned", on web client input a whitespace in the text box of the query condition.
For the second query, change "is not" to "is".
Sterling Ferguson-II selected this answer as the correct answer

Comments
Sterling Ferguson-II commented Jan 12 '15, 8:53 a.m.

Thanks about the Eclipse client. It's weird that this is only available here. When I put a whitespace in the web client, after refresh, the Condition disappears.

One other answer



permanent link
Abhinav Mishra (1443039) | answered Jan 09 '15, 4:59 a.m.
Hi Sterling,

https://jazz.net/library/article/1007

Please go through the above article.Hope this will answer your query!!


Thanks


Your answer


Register or to post your answer.


Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.