searching only 500 rows in group by gallery

[Anonymous]

Hi,

When I use the first function in gallery items I can able to search more than 500 lines but when I use the second function in gallery item it is searching only first 500 rows.

First function: 

Search('[Quo_FU].[Quotes]',TextInput2.Text,"Document_number")

Second function: 

AddColumns(Search(GroupBy('[Quo_FU].[Quotes]',"Document_number","Sales_Group_number","Sales_Group_name","Customer_Name","Customer_number","Item_Project_x002f_EAU__x0023_","Status","Marketing_Manager","Sales_Person_Name","Created_By_Name","grp"),TextInput2.Text,"Document_number"),"QuoteValue",Sum(grp,Item_Value_as_Quoted))

How can this be solved? Kindly help.

[timl · Accepted solution]

Hi @Anonymous

I assume that you're using SQL Server. The way I would approach this is to create a SQL view that carries out the sum calculation. I'd then modify the search function in the Items property of the gallery control to reference this view.