date:20211028

[web2py] Re: Displaying database information without repeating details

2021-10-28 Thread Jim S

In that case, then I'd do something like this:

If the product name changes, add a 'total' row showing the totals from the 
previous product name.


{{last_item_name=[]}}
{{item_quantity = 0}}
{{for sales in products:}}

{{if sales.product.name not in last_item_name:}}
{{if item_quantity > 0:}}



{{=item_quantity}}
{{item_quantity = 0}}


{{pass}}
{{=sales.product.name}}
{{=sales.product.Quantity}}
{{last_item_name.append(sales.product.name)}}
{{else:}}

{{=sales.quantity}}
{{item_quantity += sales.product.quantity}}
{{pass}}

{{pass}}


Again, I think the query will need some work, adding a left join to the 
product table and setting the sort order properly. Add the left join will 
then require that you include the table name in your field references in 
your template.

-Jim

On Thursday, October 28, 2021 at 9:31:09 AM UTC-5 mostwanted wrote:

> I apologize for that, i'm terrible at giving variables, my variable 
> confuse me at times too, *sales.product.Quantity*  is the initial stock, 
> its the Quantity in the *Products *table, different from the sold 
> quantity in the *sales *table (*sales.quantity*)
>
> On Thursday, October 28, 2021 at 4:22:15 PM UTC+2 Jim S wrote:
>
>> Ok, here is what I would do in my template:
>>
>> 
>> {{last_item_name=[]}}
>> {{item_quantity = 0}}
>> {{for sales in products:}}
>> 
>> {{if sales.product.name not in last_item_name:}}
>> {{=sales.product.name}}
>> {{last_item_name.append(sales.product.name)}}
>> {{else:}}
>> 
>> {{pass}}
>> {{=sales.product.Quantity}}
>> {{item_quantity += sales.product.Quantity}}
>> {{=item_quantity}}
>> 
>> {{pass}}
>> 
>>
>> In my controller I'd go another step further and add an orderby to ensure 
>> all products with the same name are in order and in the order of when they 
>> were purchased. But, this probably means you need a left join as well.
>>
>> I started coding this, but then was confused by what your columns are 
>> supposed to be.  From what I gathered,
>>
>> Name
>> Quantity Sold for this sale
>> Total quantity so far
>>
>> But now I'm not sure I'm right
>>
>> What does product.Quantity represent vs sales.quantity?
>>
>> -Jim
>>
>> On Thursday, October 28, 2021 at 8:57:38 AM UTC-5 mostwanted wrote:
>>
>>> Hey Jim, thanks for your proposed solution,it worked as shown below, i 
>>> hope this is how you imagined it but this works now the problem I still 
>>> have  imagine is how I do the sum up of all of the item's purchase 
>>> quantity, how would you go about it:
>>>
>>> *CONTROLLER:*
>>> products=db().select(db.sales.ALL)
>>>
>>> *VIEW:*
>>> 
>>> $(function() { *//Script to hide the empty rows*
>>> $("table tr").each(function() {
>>> var cell = $.trim($(this).find('td').text());
>>> if (cell.length == 0){console.log('empty');
>>> $(this).addClass('nodisplay');
>>> }});});
>>> 
>>>
>>> 
>>>  {{last_item_name=[]}}
>>> {{for sales in products:}}
>>> 
>>> {{if sales.product.name not in last_item_name:}}
>>> {{=sales.product.name}}
>>> {{=sales.product.Quantity}}
>>> {{=sales.quantity}}
>>> 
>>> {{last_item_name.append(sales.product.name)}}
>>> {{else:}}
>>>  
>>> {{pass}}
>>> {{pass}}
>>> 
>>> 
>>>
>>> On Thursday, October 28, 2021 at 2:01:34 PM UTC+2 Jim S wrote:
>>>
 In the solution I proposed, I would create a variable in my template 
 and sum it as I looped through the records.

 It might help if you showed a visual example of what you're trying to 
 accomplish. I may be misunderstanding the question, and if so, giving bad 
 advice.

 -Jim

 On Thursday, October 28, 2021 at 4:15:49 AM UTC-5 mostwanted wrote:

> I am able to group them up using *(groupby) *e.g 
> (*products=db().select(db.sales.ALL, 
> orderby=db.sales.product.name , 
> groupby=db.sales.product.name )*) but 
> now I have a problem calculating the sum of each item's sold quantities.
>
> On Wednesday, October 27, 2021 at 8:27:50 PM UTC+2 Jim S wrote:
>
>> I have done this before, but not using SQLFORM.grid
>>
>> In a nutshell
>>
>> 1. Create table tag
>> 2. create your table header
>> 3. create a temp variable last_item_name and set to None
>> 4. loop through all the data you're going to display
>> 5. in the item_name column, check if the current item name is equal 
>> to last_item_name - if it is, put blanks in that cell, if not, put the 
>> item 
>> name
>> 6.

[web2py] Re: Displaying database information without repeating details

2021-10-28 Thread mostwanted

I apologize for that, i'm terrible at giving variables, my variable confuse 
me at times too, *sales.product.Quantity*  is the initial stock, its the 
Quantity in the *Products *table, different from the sold quantity in the 
*sales 
*table (*sales.quantity*)

On Thursday, October 28, 2021 at 4:22:15 PM UTC+2 Jim S wrote:

> Ok, here is what I would do in my template:
>
> 
> {{last_item_name=[]}}
> {{item_quantity = 0}}
> {{for sales in products:}}
> 
> {{if sales.product.name not in last_item_name:}}
> {{=sales.product.name}}
> {{last_item_name.append(sales.product.name)}}
> {{else:}}
> 
> {{pass}}
> {{=sales.product.Quantity}}
> {{item_quantity += sales.product.Quantity}}
> {{=item_quantity}}
> 
> {{pass}}
> 
>
> In my controller I'd go another step further and add an orderby to ensure 
> all products with the same name are in order and in the order of when they 
> were purchased. But, this probably means you need a left join as well.
>
> I started coding this, but then was confused by what your columns are 
> supposed to be.  From what I gathered,
>
> Name
> Quantity Sold for this sale
> Total quantity so far
>
> But now I'm not sure I'm right
>
> What does product.Quantity represent vs sales.quantity?
>
> -Jim
>
> On Thursday, October 28, 2021 at 8:57:38 AM UTC-5 mostwanted wrote:
>
>> Hey Jim, thanks for your proposed solution,it worked as shown below, i 
>> hope this is how you imagined it but this works now the problem I still 
>> have  imagine is how I do the sum up of all of the item's purchase 
>> quantity, how would you go about it:
>>
>> *CONTROLLER:*
>> products=db().select(db.sales.ALL)
>>
>> *VIEW:*
>> 
>> $(function() { *//Script to hide the empty rows*
>> $("table tr").each(function() {
>> var cell = $.trim($(this).find('td').text());
>> if (cell.length == 0){console.log('empty');
>> $(this).addClass('nodisplay');
>> }});});
>> 
>>
>> 
>>  {{last_item_name=[]}}
>> {{for sales in products:}}
>> 
>> {{if sales.product.name not in last_item_name:}}
>> {{=sales.product.name}}
>> {{=sales.product.Quantity}}
>> {{=sales.quantity}}
>> 
>> {{last_item_name.append(sales.product.name)}}
>> {{else:}}
>>  
>> {{pass}}
>> {{pass}}
>> 
>> 
>>
>> On Thursday, October 28, 2021 at 2:01:34 PM UTC+2 Jim S wrote:
>>
>>> In the solution I proposed, I would create a variable in my template and 
>>> sum it as I looped through the records.
>>>
>>> It might help if you showed a visual example of what you're trying to 
>>> accomplish. I may be misunderstanding the question, and if so, giving bad 
>>> advice.
>>>
>>> -Jim
>>>
>>> On Thursday, October 28, 2021 at 4:15:49 AM UTC-5 mostwanted wrote:
>>>
 I am able to group them up using *(groupby) *e.g 
 (*products=db().select(db.sales.ALL, 
 orderby=db.sales.product.name , 
 groupby=db.sales.product.name )*) but 
 now I have a problem calculating the sum of each item's sold quantities.

 On Wednesday, October 27, 2021 at 8:27:50 PM UTC+2 Jim S wrote:

> I have done this before, but not using SQLFORM.grid
>
> In a nutshell
>
> 1. Create table tag
> 2. create your table header
> 3. create a temp variable last_item_name and set to None
> 4. loop through all the data you're going to display
> 5. in the item_name column, check if the current item name is equal to 
> last_item_name - if it is, put blanks in that cell, if not, put the item 
> name
> 6. set last_item_name = current item name
>
> Not pretty or clever, more of a brute force way to get it to work.
>
> -Jim
>
> On Wednesday, October 27, 2021 at 9:56:28 AM UTC-5 Clemens wrote:
>
>> Have a look here:
>>
>> http://www.web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#groupby-having
>>
>> Combining this with:
>>
>> http://www.web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#sum-avg-min-max-and-len
>>
>> Is it what you need?
>>
>> Best regards
>> Clemens
>>
>>
>> On Wednesday, October 27, 2021 at 4:44:11 PM UTC+2 mostwanted wrote:
>>
>>> I have a sales database table that records items sold in a store, an 
>>> item can appear several times in the table having been sold several 
>>> times 
>>> or in different days. What i wanna do is display this information in an 
>>> html table in a view without the item names repeating also with the 
>>> sold 
>>> quantity summed up for every item that appears more than once, how can 
>>> i 
>>> achieve this?
>>>

[web2py] Re: Displaying database information without repeating details

2021-10-28 Thread Jim S

Ok, here is what I would do in my template:


{{last_item_name=[]}}
{{item_quantity = 0}}
{{for sales in products:}}

{{if sales.product.name not in last_item_name:}}
{{=sales.product.name}}
{{last_item_name.append(sales.product.name)}}
{{else:}}

{{pass}}
{{=sales.product.Quantity}}
{{item_quantity += sales.product.Quantity}}
{{=item_quantity}}

{{pass}}


In my controller I'd go another step further and add an orderby to ensure 
all products with the same name are in order and in the order of when they 
were purchased. But, this probably means you need a left join as well.

I started coding this, but then was confused by what your columns are 
supposed to be.  From what I gathered,

Name
Quantity Sold for this sale
Total quantity so far

But now I'm not sure I'm right

What does product.Quantity represent vs sales.quantity?

-Jim

On Thursday, October 28, 2021 at 8:57:38 AM UTC-5 mostwanted wrote:

> Hey Jim, thanks for your proposed solution,it worked as shown below, i 
> hope this is how you imagined it but this works now the problem I still 
> have  imagine is how I do the sum up of all of the item's purchase 
> quantity, how would you go about it:
>
> *CONTROLLER:*
> products=db().select(db.sales.ALL)
>
> *VIEW:*
> 
> $(function() { *//Script to hide the empty rows*
> $("table tr").each(function() {
> var cell = $.trim($(this).find('td').text());
> if (cell.length == 0){console.log('empty');
> $(this).addClass('nodisplay');
> }});});
> 
>
> 
>  {{last_item_name=[]}}
> {{for sales in products:}}
> 
> {{if sales.product.name not in last_item_name:}}
> {{=sales.product.name}}
> {{=sales.product.Quantity}}
> {{=sales.quantity}}
> 
> {{last_item_name.append(sales.product.name)}}
> {{else:}}
>  
> {{pass}}
> {{pass}}
> 
> 
>
> On Thursday, October 28, 2021 at 2:01:34 PM UTC+2 Jim S wrote:
>
>> In the solution I proposed, I would create a variable in my template and 
>> sum it as I looped through the records.
>>
>> It might help if you showed a visual example of what you're trying to 
>> accomplish. I may be misunderstanding the question, and if so, giving bad 
>> advice.
>>
>> -Jim
>>
>> On Thursday, October 28, 2021 at 4:15:49 AM UTC-5 mostwanted wrote:
>>
>>> I am able to group them up using *(groupby) *e.g 
>>> (*products=db().select(db.sales.ALL, 
>>> orderby=db.sales.product.name , 
>>> groupby=db.sales.product.name )*) but now 
>>> I have a problem calculating the sum of each item's sold quantities.
>>>
>>> On Wednesday, October 27, 2021 at 8:27:50 PM UTC+2 Jim S wrote:
>>>
 I have done this before, but not using SQLFORM.grid

 In a nutshell

 1. Create table tag
 2. create your table header
 3. create a temp variable last_item_name and set to None
 4. loop through all the data you're going to display
 5. in the item_name column, check if the current item name is equal to 
 last_item_name - if it is, put blanks in that cell, if not, put the item 
 name
 6. set last_item_name = current item name

 Not pretty or clever, more of a brute force way to get it to work.

 -Jim

 On Wednesday, October 27, 2021 at 9:56:28 AM UTC-5 Clemens wrote:

> Have a look here:
>
> http://www.web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#groupby-having
>
> Combining this with:
>
> http://www.web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#sum-avg-min-max-and-len
>
> Is it what you need?
>
> Best regards
> Clemens
>
>
> On Wednesday, October 27, 2021 at 4:44:11 PM UTC+2 mostwanted wrote:
>
>> I have a sales database table that records items sold in a store, an 
>> item can appear several times in the table having been sold several 
>> times 
>> or in different days. What i wanna do is display this information in an 
>> html table in a view without the item names repeating also with the sold 
>> quantity summed up for every item that appears more than once, how can i 
>> achieve this?
>>
>> Regards
>>
>

-- 
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 web2py+unsubscr...@googlegroups.com.
To view this discussion on the web visit

[web2py] Re: Displaying database information without repeating details

2021-10-28 Thread mostwanted

Hey Jim, thanks for your proposed solution,it worked as shown below, i hope 
this is how you imagined it but this works now the problem I still have 
 imagine is how I do the sum up of all of the item's purchase 
quantity, how would you go about it:

*CONTROLLER:*
products=db().select(db.sales.ALL)

*VIEW:*

$(function() { *//Script to hide the empty rows*
$("table tr").each(function() {
var cell = $.trim($(this).find('td').text());
if (cell.length == 0){console.log('empty');
$(this).addClass('nodisplay');
}});});



 {{last_item_name=[]}}
{{for sales in products:}}

{{if sales.product.name not in last_item_name:}}
{{=sales.product.name}}
{{=sales.product.Quantity}}
{{=sales.quantity}}

{{last_item_name.append(sales.product.name)}}
{{else:}}
 
{{pass}}
{{pass}}



On Thursday, October 28, 2021 at 2:01:34 PM UTC+2 Jim S wrote:

> In the solution I proposed, I would create a variable in my template and 
> sum it as I looped through the records.
>
> It might help if you showed a visual example of what you're trying to 
> accomplish. I may be misunderstanding the question, and if so, giving bad 
> advice.
>
> -Jim
>
> On Thursday, October 28, 2021 at 4:15:49 AM UTC-5 mostwanted wrote:
>
>> I am able to group them up using *(groupby) *e.g 
>> (*products=db().select(db.sales.ALL, 
>> orderby=db.sales.product.name , 
>> groupby=db.sales.product.name )*) but now 
>> I have a problem calculating the sum of each item's sold quantities.
>>
>> On Wednesday, October 27, 2021 at 8:27:50 PM UTC+2 Jim S wrote:
>>
>>> I have done this before, but not using SQLFORM.grid
>>>
>>> In a nutshell
>>>
>>> 1. Create table tag
>>> 2. create your table header
>>> 3. create a temp variable last_item_name and set to None
>>> 4. loop through all the data you're going to display
>>> 5. in the item_name column, check if the current item name is equal to 
>>> last_item_name - if it is, put blanks in that cell, if not, put the item 
>>> name
>>> 6. set last_item_name = current item name
>>>
>>> Not pretty or clever, more of a brute force way to get it to work.
>>>
>>> -Jim
>>>
>>> On Wednesday, October 27, 2021 at 9:56:28 AM UTC-5 Clemens wrote:
>>>
 Have a look here:

 http://www.web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#groupby-having

 Combining this with:

 http://www.web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#sum-avg-min-max-and-len

 Is it what you need?

 Best regards
 Clemens


 On Wednesday, October 27, 2021 at 4:44:11 PM UTC+2 mostwanted wrote:

> I have a sales database table that records items sold in a store, an 
> item can appear several times in the table having been sold several times 
> or in different days. What i wanna do is display this information in an 
> html table in a view without the item names repeating also with the sold 
> quantity summed up for every item that appears more than once, how can i 
> achieve this?
>
> Regards
>


-- 
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 web2py+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/web2py/fa04c325-2110-4c98-bf04-cbc0f393212cn%40googlegroups.com.

[web2py] Re: Displaying database information without repeating details

2021-10-28 Thread Jim S

In the solution I proposed, I would create a variable in my template and 
sum it as I looped through the records.

It might help if you showed a visual example of what you're trying to 
accomplish. I may be misunderstanding the question, and if so, giving bad 
advice.

-Jim

On Thursday, October 28, 2021 at 4:15:49 AM UTC-5 mostwanted wrote:

> I am able to group them up using *(groupby) *e.g 
> (*products=db().select(db.sales.ALL, 
> orderby=db.sales.product.name , 
> groupby=db.sales.product.name )*) but now I 
> have a problem calculating the sum of each item's sold quantities.
>
> On Wednesday, October 27, 2021 at 8:27:50 PM UTC+2 Jim S wrote:
>
>> I have done this before, but not using SQLFORM.grid
>>
>> In a nutshell
>>
>> 1. Create table tag
>> 2. create your table header
>> 3. create a temp variable last_item_name and set to None
>> 4. loop through all the data you're going to display
>> 5. in the item_name column, check if the current item name is equal to 
>> last_item_name - if it is, put blanks in that cell, if not, put the item 
>> name
>> 6. set last_item_name = current item name
>>
>> Not pretty or clever, more of a brute force way to get it to work.
>>
>> -Jim
>>
>> On Wednesday, October 27, 2021 at 9:56:28 AM UTC-5 Clemens wrote:
>>
>>> Have a look here:
>>>
>>> http://www.web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#groupby-having
>>>
>>> Combining this with:
>>>
>>> http://www.web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#sum-avg-min-max-and-len
>>>
>>> Is it what you need?
>>>
>>> Best regards
>>> Clemens
>>>
>>>
>>> On Wednesday, October 27, 2021 at 4:44:11 PM UTC+2 mostwanted wrote:
>>>
 I have a sales database table that records items sold in a store, an 
 item can appear several times in the table having been sold several times 
 or in different days. What i wanna do is display this information in an 
 html table in a view without the item names repeating also with the sold 
 quantity summed up for every item that appears more than once, how can i 
 achieve this?

 Regards

>>>

-- 
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 web2py+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/web2py/c5251cbc-3d38-4be0-a792-b97a6096e205n%40googlegroups.com.

Re: [web2py] Re: Displaying database information without repeating details

2021-10-28 Thread Massimiliano

You need to create an alias for your field.

Look here:
http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer?search=count%28%29#sum-avg-min-max-and-len

Massimiliano


Il 28 ott 2021, 11:15:48, mostwanted  ha scritto:

> I am able to group them up using *(groupby) *e.g 
> (*products=db().select(db.sales.ALL,
> orderby=db.sales.product.name ,
> groupby=db.sales.product.name )*) but now I
> have a problem calculating the sum of each item's sold quantities.
>
> On Wednesday, October 27, 2021 at 8:27:50 PM UTC+2 Jim S wrote:
>
>> I have done this before, but not using SQLFORM.grid
>>
>> In a nutshell
>>
>> 1. Create table tag
>> 2. create your table header
>> 3. create a temp variable last_item_name and set to None
>> 4. loop through all the data you're going to display
>> 5. in the item_name column, check if the current item name is equal to
>> last_item_name - if it is, put blanks in that cell, if not, put the item
>> name
>> 6. set last_item_name = current item name
>>
>> Not pretty or clever, more of a brute force way to get it to work.
>>
>> -Jim
>>
>> On Wednesday, October 27, 2021 at 9:56:28 AM UTC-5 Clemens wrote:
>>
>>> Have a look here:
>>>
>>> http://www.web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#groupby-having
>>>
>>> Combining this with:
>>>
>>> http://www.web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#sum-avg-min-max-and-len
>>>
>>> Is it what you need?
>>>
>>> Best regards
>>> Clemens
>>>
>>>
>>> On Wednesday, October 27, 2021 at 4:44:11 PM UTC+2 mostwanted wrote:
>>>
 I have a sales database table that records items sold in a store, an
 item can appear several times in the table having been sold several times
 or in different days. What i wanna do is display this information in an
 html table in a view without the item names repeating also with the sold
 quantity summed up for every item that appears more than once, how can i
 achieve this?

 Regards

>>> --
> 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 web2py+unsubscr...@googlegroups.com.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/web2py/313a1e44-7044-4cd9-b603-d0659c73b04dn%40googlegroups.com
> 
> .
>

-- 
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 web2py+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/web2py/CANPTPxKxPBRqv1qMH2gY%3DQODM2eNk%3D8b4TUD0KoRKoeqgKt-%3Dg%40mail.gmail.com.

[web2py] Re: Displaying database information without repeating details

2021-10-28 Thread mostwanted

I am able to group them up using *(groupby) *e.g 
(*products=db().select(db.sales.ALL, 
orderby=db.sales.product.name, groupby=db.sales.product.name)*) but now I 
have a problem calculating the sum of each item's sold quantities.

On Wednesday, October 27, 2021 at 8:27:50 PM UTC+2 Jim S wrote:

> I have done this before, but not using SQLFORM.grid
>
> In a nutshell
>
> 1. Create table tag
> 2. create your table header
> 3. create a temp variable last_item_name and set to None
> 4. loop through all the data you're going to display
> 5. in the item_name column, check if the current item name is equal to 
> last_item_name - if it is, put blanks in that cell, if not, put the item 
> name
> 6. set last_item_name = current item name
>
> Not pretty or clever, more of a brute force way to get it to work.
>
> -Jim
>
> On Wednesday, October 27, 2021 at 9:56:28 AM UTC-5 Clemens wrote:
>
>> Have a look here:
>>
>> http://www.web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#groupby-having
>>
>> Combining this with:
>>
>> http://www.web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#sum-avg-min-max-and-len
>>
>> Is it what you need?
>>
>> Best regards
>> Clemens
>>
>>
>> On Wednesday, October 27, 2021 at 4:44:11 PM UTC+2 mostwanted wrote:
>>
>>> I have a sales database table that records items sold in a store, an 
>>> item can appear several times in the table having been sold several times 
>>> or in different days. What i wanna do is display this information in an 
>>> html table in a view without the item names repeating also with the sold 
>>> quantity summed up for every item that appears more than once, how can i 
>>> achieve this?
>>>
>>> Regards
>>>
>>

-- 
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 web2py+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/web2py/313a1e44-7044-4cd9-b603-d0659c73b04dn%40googlegroups.com.

[web2py] Re: Displaying database information without repeating details

[web2py] Re: Displaying database information without repeating details

[web2py] Re: Displaying database information without repeating details

[web2py] Re: Displaying database information without repeating details

[web2py] Re: Displaying database information without repeating details

Re: [web2py] Re: Displaying database information without repeating details

[web2py] Re: Displaying database information without repeating details

7 matches

Site Navigation

Mail list logo

Footer information