[web2py] Search and Filtering

can anyone help me to code for searching and filtering for data entered in front end web page in web2py? -- 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) ---

[web2py] Search and filtering

Consider that :you have list of names,which you have entered through front end and you have search and filter the entered data on the search box. Please send the video related or code for this. On Sun 19 Jul, 2020, 6:36 PM mostwanted, wrote: > Hey AGRogers, thanks for that suggestion, I added th

[web2py] search in sqlform.grid

Hello! I use search in SQLFORM.grid. If you want to find empty dates, nothing happens, since the query generated in sqlhtml.py (subquery variable, line 2429) contains "= NULL", while "IS NULL" is correct. Am I doing something wrong or is this a mistake? web2py 2.9.12 mySQL 5.6.36 -- Resources

[web2py] Search using search widget return not autorized

Hi, I want to pass a value to a function for using it in a query I made links with this code in the calling grid links = [lambda row: A(T('View flexi list'),_href=URL(show_flexlist,args=[row.id,0],user_signature=True)),lambda row: A(T('View flexi list'),_href=URL(show_flexlist,args=[row.id,

Re: [web2py] Search for list:string values in grid search?

Anthony, thank you for your message. I will work from the information you gave, but I just wanted to say something regarding to a portion of the message: > Finally, note that if you simply enter a string in the search box and > click> "Search" (i.e., don't use the advanced search widget), it /will

[web2py] Search for list:string values in grid search?

Is it possible at all to search for values contained in fields defined as list:string in the grid search dialog? -- 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 Issue

[web2py] Search box in navbar in defaut layout.html

What is the purpose and usage of the Search box displayed in the navbar when using the default layout.html? Here's the code in layout.html: Thanks. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (

[web2py] Search on list:reference tables with SQLFORM.Grid

I am coming back to this topic for a second time since I couldn’t get an answer last time and it would facilitate things a lot for me: The SQLFORM.Grid has a very sophisticated filter system to make queries over selected tables easy. It seems, however, that it is actually not possible to q

[web2py] search results returned by SQLFORM.grid in loaded component {{=LOAD( ....

In a index.html view I load a component "test.load" containing an SQLFORM.grid with searchable=True. When I perform a search, the results do not appear inside the index.html any more. A new page "test.load” opens with the results. For sure I am doing something wrong, or I am missing something, bec

[web2py] search date sqlform.grid

Hi, I have a table that has a date field. When you attempt to search by this date field in a SQLFORM.grid, the date picker no longer appears, just a test box !! How can i do ? thanks -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (

[web2py] search query list:reference multiple true

i have a table that have list:reference type of field. just wondering, is it possible to have search query list:reference multiple true? when i test it the form.vars value of list:reference is translate into __12__ and the query result is not shown as expected because i assume the value of

[web2py] Search in web2py book case sensitive

Hello, is the search function in web2py Book supposed to be case sensitive? I went to the online book and typed sqlform in the search field. Was a little bit surprised when I got: No results for "sqlform" Searching for SQLFORM works. Kenneth -- Resources: - http://web2py.com - http://web

[web2py] Search for fields with multiple values (list:string) in SQLFORM?

Hello everyone, I really enjoy using the SQLFORM, however I've noticed when I convert fields to list:string I can no longer search by those specific fields. Is this something I could fix in SQLFORM? -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/

[web2py] Search for Similar database entries

Hi I got a filled db table with articles each article has a title which looks like this: "Movie the article is about - Topic discussed" what I want to list all articles which have the same first half of the title: "Movie the article is about" Thanks for your help. -- Resources: - http://web2py

[web2py] search with like/contains & case sensitive

Give me a clue of how to set my search case insensitive for all kind types?!? def search(): lname = request.vars.name #form field q = db.tbl.l_name.like('%'+str(lname)+'%', case_sensitive=False) grid = _grid(q) return locals() This grid returns me all records regardless of case:

[web2py] search db, return table with pagination

Dear list, I am trying to create a search form to access a table in database and then return a table of result into a view (same page), but displaying only 3 records and next/prev buttons to scroll over results (e.g. I want to have pagination of the table display results). I am trying to follow

[web2py] search engine

how to collect data? how to create ad work indexing and stemming? -- 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

[web2py] Search operators

In SQLFORM.grid, you have a Search operation in the form. The operators include =, !=, <, >, <=, >=, starts with, contains, in, not in. I can't figure out how to use 'in' and 'not in'. What are these operators?? Are they for strings? Are they for numeric ranges? If the latter, how do you design

[web2py] search db partial string match

I got a table like this one: db.define_table('Movie', Field('Title',length=64), Field('Content',length=512), ) Now I like to search this table Title with a string like "Star Wars". My problem is that there are 6 Star Wars Movies: Star Wars: Episode I... I want to have all of those 6 as a

Re: [web2py] Search Form (Advice/Help) with custom Form

I was able to get it working thanks anyway everyone --

[web2py] Search Form (Advice/Help) with custom Form

I am developing a search form in web2py, I create the form like this Enter Keywords Select Region Choose a Region... {{for region in region_query:}}

Re: [web2py] Search Database field auto complete

Note, there have been some problems with the auto-complete widget UI in Internet Explorer. As an alternative, check out http://web2py.com/books/default/chapter/29/11#Auto-completion for the general logic for building auto-complete functionality. It should also be easy to incorporate a more full

Re: [web2py] Search Database field auto complete

http://web2py.com/books/default/chapter/29/07#Autocomplete-widget On 09/02/2012 11:05 AM, BlueShadow wrote: Hi, I got huge database with a name field... I have to search for individual lines quite often. So I wanted to make a search box for it. If Christmas was today I would love it it would b

[web2py] Search Database field auto complete

Hi, I got huge database with a name field... I have to search for individual lines quite often. So I wanted to make a search box for it. If Christmas was today I would love it it would be somewhat similar like the google search: like while your typing it shows you the possibilities with those

Re: [web2py] Search in Web2Py

We were just discussing this earlier today, see: https://groups.google.com/forum/#!topic/web2py/CzE8JhoCxeo On 08/08/2012 1:51 PM, "Mike Girard" wrote: > I notice that there is no search box on the main web2py site. The search > on the book site is somewhat unorthodox in that it only provides li

[web2py] Search in Web2Py

I notice that there is no search box on the main web2py site. The search on the book site is somewhat unorthodox in that it only provides links where the search term is located but does not show you where. Does web2py have a robust, conventional search utility? If not, what is the prescribed me

[web2py] search bar in top bar

Hi all, How can i make the top bar fixed/static at the top of the web2py default theme. I also want a nice search bar in the bar. Any ideas please. Thanks.

[web2py] search in tables

On Bruno's new site for weby2py slices, search works like one would expect. eg searching putting - pingback plugin - in the search box finds slices that contain both pingback and plugin. Now in my experience of sqlform.grid, this does not happen in its search box. If one puts two words in the searc

[web2py] Search menu

Hello everyone, I'd like to have a search menu that has two submenus. Submenus will appear if the mouse is over the search menu. The first submenu is nothing but a text field and a button where the user can enter an expression and press the button to get the results of the search (this is for basi

Re: [web2py] search

rows = db(db.blog.title.contains('search_entry').select() where 'search_entry' is string that you want to seach for. On Sat, Jul 30, 2011 at 7:14 PM, Web2Py Freak wrote: > hey guys , > > is there anyway to do a search  but other that the crud.search   or a > way to control the crud.search output

[web2py] search

hey guys , is there anyway to do a search but other that the crud.search or a way to control the crud.search output ... am doing it on blogs so every blog has a title and when i search i want it to view the blog with the title am looking for what do u think guys ?

[web2py] search by Tag blugin

hey all , am using the tags in blugin wiki . and i want to make a search using them , how can i do that ??? please help

[web2py] Search Form Help

Hi everybody!! How could I make a google like in web2py, I mean I have: db.define_table('article', Field('site', db.site), Field('section',db.section), Field('date,'datetime'), Field('author','string'), Field('header','string'), Field('body','text')) and I like to have a

[web2py] search text inside html - using html.elements find

Hi, i am trying to search inside html data, which i get from DB(sqllite). Everythink works well, but if i try to search for 'äöü', i get no match. #before ö -> ö data = 'persönliche bitte' # data from db created with wysiwyg editor html = TAG(data) #after ö -> ? el_list = html

[web2py] search plugin (plugin_wiki)

Hi, a user brought up a good point (at least i never thought about it...duh! :( ). He was looking for something, but didn't know which table to find it in. Is there an easy way to tell the search plugin in plugin_wiki to check all tables (and to allow for multiple keywords that may be set in diff

[web2py] "search" find this slice

Hello, I don't know if this slice had passed through without any attention, but don't see any mail on the list about it... Site search plugin http://web2pyslices.com/main/slices/take_slice/115 https://bitbucket.org/hc/plugin_h_search Does it anyone has tried it out and want to report experience?

Re: [web2py] Search form in CRUD

Hi All, Not sure if anyone else has worked through the CRUD URLs described in the book on p317, but the search URL described does not work: - def client_search(): return dict(form=crud.search(db.client)) ...works as expected, but using: - def data(): return dict(form=crud()) ...and

[web2py] Search form in CRUD

Hi All, If I call "search" from a controller like: - def client_search(): return dict(form=crud.search(db.client)) ...and get the expected form, but using: - def data(): return dict(form=crud()) ...at: - [app]/crm/data/search/client ...I get a 404. Am I missing something? -- Cheer

[web2py] Search engine for Python Source

Nullege is a search engine for Python source code. http://nullege.com/

[web2py] Search Function

Hello, i was trying to implement a search function so I've tried this wiki example (http://web2py.com/book/default/section/3/9) I can create pages, but I cannot search for them. Is the search function wrong? Is there others examples of search function? -- You received this message because you are

[web2py] Search function

I am trying to incorporate a "Search" function into my web2py application. I have found similar thing in the sample appliance such as the KPAX and the C.R.M application, could someone detail how I could copy code from these apps. Is there a way to trace the relevant section of code for the search f

Re: [web2py] Search frustration

What are you trying to find ? -Thadeus On Thu, Jan 21, 2010 at 3:27 PM, DenesL wrote: > > Trying to locate older posts in this group using Google, Gmane, Bing, > etc. seems like an exercise in futility. Even with the exact subject > of the post NONE of the above can locate it. Ridiculous. >

[web2py] Search frustration

Trying to locate older posts in this group using Google, Gmane, Bing, etc. seems like an exercise in futility. Even with the exact subject of the post NONE of the above can locate it. Ridiculous. No wonder some of the questions keep popping up. Does anybody know of a better way?. We might need to