Not sure if this personal experience helps but...
I only use SQLFORM.grid when it is clearly a quick and simple solution.
Otherwise, I use DataTables, which I think is great.
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code
Thank you this was very helpful and pointed me in the right direction!
On Monday, April 15, 2019 at 7:42:24 PM UTC+1, João Matos wrote:
>
> My bad. distinct only works in select. But a grid doesn't accept a select
> only a query.
>
> I see 3 options:
> 1. Don't use the grid and you can use the di
My bad. distinct only works in select. But a grid doesn't accept a select
only a query.
I see 3 options:
1. Don't use the grid and you can use the distinct=True in the select;
2. Use the grid and use groupby as a replacement of distinct (this is not a
recommend use, but for some situations it wo
Unfortunately the alternative isn't enough, I've looked into distinct =
True, but as I mentioned earlier I couldn't get it to work with the
SQLFORM.grid sorry again I'm still very new to python and web2py.
My code looks like this
controller contains:
def car_records():
fields =[db.car.vehicle_
Thank you for replying couldn't get it to work with the grid but found an
alternative for now.
On Sunday, April 14, 2019 at 9:26:18 AM UTC+1, João Matos wrote:
>
> Check distinct=True in the book.
>
> domingo, 14 de Abril de 2019 às 04:27:33 UTC+1, Jacob escreveu:
>>
>> Hello I'm new to web2py an
Check distinct=True in the book.
domingo, 14 de Abril de 2019 às 04:27:33 UTC+1, Jacob escreveu:
>
> Hello I'm new to web2py and I have a query which joins tables and displays
> the results in an SQLgrid. Within the grid of results there values which
> are appearing more than once due to many to
6 matches
Mail list logo