Scopes are a rails thing so there's more than just hobo's docs.
On Friday, May 4, 2012 3:47:21 PM UTC-6, jhstephenson wrote:
>
> Thanks,
>
> I just have to learn more about scopes now. I wish there were more
> examples for things like this.
>
> Jim
>
> On Friday, May 4, 2012 2:33:21 PM UTC-6, kevinpfromnm wrote:
>>
>> Oh, there's a parameter in autocompleter to specify a different
>> query_scope from default now (as opposed to using a finder).
>>
>> On Friday, May 4, 2012 2:30:31 PM UTC-6, kevinpfromnm wrote:
>>>
>>> The autocompleter provides a default finder which you could override to
>>> only return results starting with your match. You might want to do that
>>> for performance reasons as matching text anywhere in a string is much more
>>> expensive than matching the beginning (of an indexed column).
>>>
>>> On Friday, May 4, 2012 1:23:30 PM UTC-6, jhstephenson wrote:
>>>>
>>>> Thanks,
>>>>
>>>> That will give me what I want. On thing I notice is that the search
>>>> result brings up anything found with the matching characters, not just
>>>> something that starts with what I type. I actually like that better than
>>>> what I planned, but if I wanted to limit it to just the starting
>>>> characters
>>>> of a name field, is there a way to filter it that way?
>>>>
>>>> Jim
>>>>
>>>> On Friday, May 4, 2012 5:56:46 AM UTC-6, Matt jones wrote:
>>>>>
>>>>>
>>>>> On May 3, 2012, at 9:22 PM, jhstephenson wrote:
>>>>>
>>>>> > Ok. Here is what the log shows when I try do it on just my Category
>>>>> field:
>>>>> >
>>>>> > Started GET "/categories/complete_name?query=Computer" for 127.0.0.1
>>>>> at 2012-05-03 19:18:24 -0600
>>>>> > [1m [36mSQL (2.0ms) [0m [1mSHOW TABLES [0m
>>>>> > [1m [35mSQL (1.0ms) [0m SHOW TABLES
>>>>> > [1m [36mSQL (2.0ms) [0m [1mSHOW TABLES [0m
>>>>> > [1m [35mSQL (1.0ms) [0m SHOW TABLES
>>>>> > [1m [36mSQL (1.0ms) [0m [1mSHOW TABLES [0m
>>>>> > [1m [35mSQL (2.0ms) [0m SHOW TABLES
>>>>> > [1m [36mSQL (2.0ms) [0m [1mSHOW TABLES [0m
>>>>> > Processing by CategoriesController#show as JS
>>>>> > Parameters: {"query"=>"Computer", "id"=>"complete_name"}
>>>>> > [1m [35mSQL (1.0ms) [0m SELECT COUNT(*) AS count_id FROM `users`
>>>>> > [1m [36mUser Load (1.0ms) [0m [1mSELECT `users`.* FROM `users`
>>>>> WHERE (`users`.`id` = 1) LIMIT 1 [0m
>>>>> > [1m [35mCategory Load (0.0ms) [0m SELECT `categories`.* FROM
>>>>> `categories` WHERE (`categories`.`id` = 0) LIMIT 1
>>>>> > Completed in 20ms
>>>>> >
>>>>> > ActiveRecord::RecordNotFound (Couldn't find Category with
>>>>> ID=complete_name):
>>>>> >
>>>>> >
>>>>> > Rendered
>>>>> C:/Ruby193/lib/ruby/gems/1.9.1/gems/actionpack-3.0.1/lib/action_dispatch/middleware/templates/rescues/_trace.erb
>>>>>
>>>>> (1.0ms)
>>>>> > Rendered
>>>>> C:/Ruby193/lib/ruby/gems/1.9.1/gems/actionpack-3.0.1/lib/action_dispatch/middleware/templates/rescues/_request_and_response.erb
>>>>>
>>>>> (3.0ms)
>>>>> > Rendered
>>>>> C:/Ruby193/lib/ruby/gems/1.9.1/gems/actionpack-3.0.1/lib/action_dispatch/middleware/templates/rescues/diagnostics.erb
>>>>>
>>>>> within rescues/layout (16.0ms)
>>>>> >
>>>>> > I assume the key entry here is the one indicating that ActiveRecord
>>>>> could not fine the Category with ID=complete_name.
>>>>> > Should there be a method in the Category controller called
>>>>> complete_name?
>>>>>
>>>>> Yep. The quickest way to get one is with the autocomplete method:
>>>>>
>>>>> http://cookbook.hobocentral.net/manual/controllers#autocompleters
>>>>>
>>>>> --Matt Jones
>>>>
>>>>
>> On Friday, May 4, 2012 2:30:31 PM UTC-6, kevinpfromnm wrote:
>>>
>>> The autocompleter provides a default finder which you could override to
>>> only return results starting with your match. You might want to do that
>>> for performance reasons as matching text anywhere in a string is much more
>>> expensive than matching the beginning (of an indexed column).
>>>
>>> On Friday, May 4, 2012 1:23:30 PM UTC-6, jhstephenson wrote:
>>>>
>>>> Thanks,
>>>>
>>>> That will give me what I want. On thing I notice is that the search
>>>> result brings up anything found with the matching characters, not just
>>>> something that starts with what I type. I actually like that better than
>>>> what I planned, but if I wanted to limit it to just the starting
>>>> characters
>>>> of a name field, is there a way to filter it that way?
>>>>
>>>> Jim
>>>>
>>>> On Friday, May 4, 2012 5:56:46 AM UTC-6, Matt jones wrote:
>>>>>
>>>>>
>>>>> On May 3, 2012, at 9:22 PM, jhstephenson wrote:
>>>>>
>>>>> > Ok. Here is what the log shows when I try do it on just my Category
>>>>> field:
>>>>> >
>>>>> > Started GET "/categories/complete_name?query=Computer" for 127.0.0.1
>>>>> at 2012-05-03 19:18:24 -0600
>>>>> > [1m [36mSQL (2.0ms) [0m [1mSHOW TABLES [0m
>>>>> > [1m [35mSQL (1.0ms) [0m SHOW TABLES
>>>>> > [1m [36mSQL (2.0ms) [0m [1mSHOW TABLES [0m
>>>>> > [1m [35mSQL (1.0ms) [0m SHOW TABLES
>>>>> > [1m [36mSQL (1.0ms) [0m [1mSHOW TABLES [0m
>>>>> > [1m [35mSQL (2.0ms) [0m SHOW TABLES
>>>>> > [1m [36mSQL (2.0ms) [0m [1mSHOW TABLES [0m
>>>>> > Processing by CategoriesController#show as JS
>>>>> > Parameters: {"query"=>"Computer", "id"=>"complete_name"}
>>>>> > [1m [35mSQL (1.0ms) [0m SELECT COUNT(*) AS count_id FROM `users`
>>>>> > [1m [36mUser Load (1.0ms) [0m [1mSELECT `users`.* FROM `users`
>>>>> WHERE (`users`.`id` = 1) LIMIT 1 [0m
>>>>> > [1m [35mCategory Load (0.0ms) [0m SELECT `categories`.* FROM
>>>>> `categories` WHERE (`categories`.`id` = 0) LIMIT 1
>>>>> > Completed in 20ms
>>>>> >
>>>>> > ActiveRecord::RecordNotFound (Couldn't find Category with
>>>>> ID=complete_name):
>>>>> >
>>>>> >
>>>>> > Rendered
>>>>> C:/Ruby193/lib/ruby/gems/1.9.1/gems/actionpack-3.0.1/lib/action_dispatch/middleware/templates/rescues/_trace.erb
>>>>>
>>>>> (1.0ms)
>>>>> > Rendered
>>>>> C:/Ruby193/lib/ruby/gems/1.9.1/gems/actionpack-3.0.1/lib/action_dispatch/middleware/templates/rescues/_request_and_response.erb
>>>>>
>>>>> (3.0ms)
>>>>> > Rendered
>>>>> C:/Ruby193/lib/ruby/gems/1.9.1/gems/actionpack-3.0.1/lib/action_dispatch/middleware/templates/rescues/diagnostics.erb
>>>>>
>>>>> within rescues/layout (16.0ms)
>>>>> >
>>>>> > I assume the key entry here is the one indicating that ActiveRecord
>>>>> could not fine the Category with ID=complete_name.
>>>>> > Should there be a method in the Category controller called
>>>>> complete_name?
>>>>>
>>>>> Yep. The quickest way to get one is with the autocomplete method:
>>>>>
>>>>> http://cookbook.hobocentral.net/manual/controllers#autocompleters
>>>>>
>>>>> --Matt Jones
>>>>
>>>>
--
You received this message because you are subscribed to the Google Groups "Hobo
Users" group.
To view this discussion on the web visit
https://groups.google.com/d/msg/hobousers/-/Nuz8_5ja1v4J.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/hobousers?hl=en.
