Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    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 18:23 Go to next message
Swati Sapar is currently offline Swati SaparFriend
Messages: 20
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 ?

Re: SQL Results View : Usage of "SQL Results/Type query expression here" [message #659310 is a reply to message #657424] Sat, 12 March 2011 02:36 Go to previous messageGo to next message
Brian Payton is currently offline Brian PaytonFriend
Messages: 152
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 ?
>
>
Re: SQL Results View : Usage of "SQL Results/Type query expression here" [message #659815 is a reply to message #659310] Tue, 15 March 2011 17:12 Go to previous messageGo to next message
Swati Sapar is currently offline Swati SaparFriend
Messages: 20
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.
Re: SQL Results View : Usage of "SQL Results/Type query expression here" [message #718160 is a reply to message #659310] Tue, 23 August 2011 13:04 Go to previous message
san.futura is currently offline san.futuraFriend
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 13:12]

Report message to a moderator

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


Current Time: Thu Nov 27 12:20:19 GMT 2014

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

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