Skip to main content

hi, 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 

Sadly, 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

 

Hi ​@PorAlineM, 

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.

 

​@PorAlineM one thing you could also do from page designer is to add a summary for numeric columns. This was helpful for some of my clients to alleviate the missing feature of group/sum.

 

Hi ​@PorAlineM,

Please have a look on this which might be helpful for you.

Regards,

Nikila Dissanayake

https://www.linkedin.com/in/nikila-dissanayake-7140891a0/

Reply


Terms & ConditionsCookie settings