It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Guidelines | FAQ
Follow this question
Question details

×42,876
×12,004
×201

question asked: Jan 07 '15, 3:26 p.m.
question was seen: 4,284 times
last updated: Jan 12 '15, 8:53 a.m.

Related questions

Querying on a small string variable

0
Sterling Ferguson-II (1.6k●13●288●273) | 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

0
permanent link
Lily Wang (4.9k●7●14) | 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

Most liked answers ↑|Newest answers|Oldest answers

0
permanent link
Abhinav Mishra (144●31●39) | 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.