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)

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

Wed, 02 March 2011 13:23

Eclipse User

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 ?

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

Eclipse User

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 ?
>
>

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

Eclipse User

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.

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

Eclipse User

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] by Moderator

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

Goto Forum:

-=] Back to Top [=-

Current Time: Tue Jul 08 12:59:56 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter