+3hi, I have one doubt related to the Search in IFS CLoud.
until versao 10 we had this “advanced search” where it was able to make summaries and group some data in the search, even SQL searchs it was able to do like the exampe below:
question:
how do I do this same kind of search in CLoud?
I’m asking because I dont see this advanced option of search as we had:
thanks
+18Sadly, group and sum is not available in Cloud. You will need to get a report or lobby created or export the data to Excel and pivot
Linda
+4Hi
You're absolutely right, the traditional Advanced Search feature from IFS Applications 10 (which allowed grouping, summaries, and even SQL-like queries) is no longer available in the same form in IFS Cloud.
However, IFS Cloud’s Query Designer offers much of the same functionality, including:
Grouping results by specific fields
Applying aggregations like SUM, COUNT, and AVG
Using advanced filter conditions, including HAVING clauses for aggregated data
While it’s not a 1:1 replacement, Query Designer is the recommended tool for building advanced queries in IFS Cloud.
To get there here’s the navigation: Solution Manager > Configuration > Query Designer
Here’s a link to the official documentation for more details:
🔗 Query Designer Capabilities – IFS Cloud Technical Documentation
Hope this helps clarify things!
Aaron J.
The other trick that you can do is, go to chart mode on the specific screen where you can do group and sum. But the data will be presented in a bar chart or so rather than a sum at the bottom of the table.
+22
+12Hi
Please have a look on this which might be helpful for you.
Regards,
Nikila Dissanayake
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
