cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Gopi
Level 8

searching only 500 rows in group by gallery

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.

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: searching only 500 rows in group by gallery

Hi @Gopi

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.

1 REPLY 1
Super User
Super User

Re: searching only 500 rows in group by gallery

Hi @Gopi

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.