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.
Solved! Go to 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.
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.