Skip to main content



      Home
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 Go to next message
Eclipse UserFriend
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 Go to previous messageGo to next message
Eclipse UserFriend
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 Go to previous messageGo to next message
Eclipse UserFriend
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 Go to previous message
Eclipse UserFriend
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:
  


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

Powered by FUDForum. Page generated in 0.04715 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top