Eclipse Community Forums: DTP » SQL Results View : Usage of "SQL Results/Type query expression here"

Home » Eclipse Projects » DTP » SQL Results View : Usage of "SQL Results/Type query expression here"(How does the text Area in SQL Results View work)

Show: Today's Messages :: Show Polls :: Message Navigator

SQL Results View : Usage of "SQL Results/Type query expression here" [message #657424]

Wed, 02 March 2011 13:23

Swati Sapar
Messages: 19
Registered: September 2010

Junior Member

There is a Text Area at the top of SQL Results View

Quote:

"SQL Results/Type query expression here"

How is this suppose to be used ?

Also if I type some text here and then try to view the Sample contents using the context menu in Data Source Explorer, then that does not show any sample contents.

Is this how it is suppose to work ?

Report message to a moderator

Re: SQL Results View : Usage of "SQL Results/Type query expression here" [message #659310 is a reply to message #657424]

Fri, 11 March 2011 21:36

Brian Payton
Messages: 144
Registered: July 2009

Senior Member

The search field in the SQL Results view is used to filter the previous
result entries in the SQL Results view. In particular it searches the
text in the "Operation" column of the result entries. For example, if
you had previously run some SQL statements such as CREATE TABLE FOO ...,
INSERT IGNORE INTO FOO VALUES..., SELECT * FROM FOO, then if you type FOO into
the search field, it will filter the list of results to those that have
the token "FOO" in their Operation entry.

On 3/2/2011 10:23 AM, Swati Sapar wrote:
> There is a Text Area at the top of SQL Results View
> Quote:
>> "SQL Results/Type query expression here"
>
>
> How is this suppose to be used ?
>
> Also if I type some text here and then try to view the Sample contents
> using the context menu in Data Source Explorer, then that does not show
> any sample contents.
>
> Is this how it is suppose to work ?
>
>

Report message to a moderator

Re: SQL Results View : Usage of "SQL Results/Type query expression here" [message #659815 is a reply to message #659310]

Tue, 15 March 2011 13:12

Swati Sapar
Messages: 19
Registered: September 2010

Junior Member

Thank you Brian.

I have some more observations to share:

When I try to see Sample contents by using Context Menu from SQL Explorer, then we do not see anything in the Operations column in SQL results view. Why is that so ? I would expect to see a Select * from TableName query expression.

Report message to a moderator

Re: SQL Results View : Usage of "SQL Results/Type query expression here" [message #718160 is a reply to message #659310]

Tue, 23 August 2011 09:04

san.futura
Messages: 1
Registered: August 2011

Junior Member

Can someone expands this, yes it filters based on word in 'operation' field, how do I filter using other fields? also it is case sensitive, is there way to make it ignore case? also it does not allow partial text search, it works with t1_t2 here if we search by t1 or t2 it works but in this case 'T1T2' searching by T2 does not show the result...

Thanks.
Regards,
Santhosh R.

[Updated on: Tue, 23 August 2011 09:12]

Report message to a moderator

Previous Topic:	No database selected
Next Topic:	jar files for IConnectionProfile

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon May 20 04:59:13 EDT 2013