My code is not Javascript -- it is Python and goes in the controller where 
you create the grid (note it refers to the "grid"). It *disables* the 
Javascript that triggers the drop down, but it is not Javascript code.

On Wednesday, February 25, 2015 at 4:53:37 PM UTC-5, Alex Glaros wrote:
>
> thanks Anthony,
>
> Javascript didn't work - where does it go?  Tried both in <script> within 
> html page, and in controller but didn't do anything.
>
> below works but is it a good way to write search?
>
> (1) First create regular full query that shows in default results (all).
> (2) Then within the "form", get search_term, and recreate query with that 
> additional filter.
>
> optional, but how would you write the "clear" button?
>
> Alex
>
> ## Regular default results user sees on entering the web page. No filter.
>   my_connection_requests_i_sent_query = ((db.Role.superObjectID == 
> db.auth_user.superObjectID) & (auth.user_id != db.auth_user.id) & 
> (db.Role.relationshipID == db.Relationship.id) & 
> (db.Relationship.relationshipType == 6) & (db.Relationship.relationshipType 
> == db.RelationshipType.id) & (db.Role.roleType == db.RoleType.id) & 
> (db.Role.created_by == auth.user_id))   
>     form  = SQLFORM.factory(Field('key')).process()
>    if form.accepted and form.vars.key:
>        search_term = form.vars.key   
>                 ## below is search plus has new search_term filter
>        my_connection_requests_i_sent_query = ((db.Role.superObjectID == 
> db.auth_user.superObjectID) & (auth.user_id != db.auth_user.id) & 
> (db.Role.relationshipID == db.Relationship.id) & 
> (db.Relationship.relationshipType == 6) & (db.Relationship.relationshipType 
> == db.RelationshipType.id) & (db.Role.roleType == db.RoleType.id) & 
> (db.auth_user.first_name.contains(search_term)) & (db.Role.created_by == 
> auth.user_id))
>    grid = SQLFORM.grid(my_connection_requests_i_sent_query, 
> editable=False, create=False, deletable=False, details=False, 
> searchable=False, fields=[db.auth_user.first_name, db.auth_user.last_name, 
> db.auth_user.id, db.RoleClass.roleType, db.Role.created_on, 
> db.Role.modified_on, db.Role.id, db.RoleType.roleType], links = 
> [dict(header='Cancel connection',  body=lambda row: A('Withdraw my 
> invitation', _href=URL('edit_connection_request', args=row.Role.id), 
> _class='btn'))],  maxtextlengths={'RoleType.roleType':200})
>
>
>

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to [email protected].
For more options, visit https://groups.google.com/d/optout.

Reply via email to