Skip to main content
Question

Default “order by” in Apps 9


Forum|alt.badge.img+3
Is there any way to modify the default “order by” clause in the enterprise application?

Kasun Balasooriya
Superhero (Employee)
Forum|alt.badge.img+20
Hi, Welcome to the IFS Community. The default where and the default order by are properties set during the development stage of the core forms. These properties are not available to be modified to the end user.
These properties are used during the populate operation of the form. If it needs to be changed, a customization is needed.
However, as a workaround, the default behavior can be changed to show the search dialog from the form properties and then a saved search can be used for the population.



Hope this helps!

Forum|alt.badge.img+3
  • Do Gooder (Customer)
  • October 9, 2019
Unfortunately the workaround does not solve the issue in this instance. The product structure table is a sub form type object in the module. The table is loaded after the product structure head has been loaded. The saved search applies to the head and not the table. it is then required to sort the table separately after the module has fully populated.

Forum|alt.badge.img+3
  • Do Gooder (Customer)
  • October 10, 2019
Can you set up a saved search from within Search In Context (right mouse button option when in the components table) to achieve this? The downside to that, if it would work, would be that it wouldn’t take effect until you ran it after the top level search.

Forum|alt.badge.img+3
  • Do Gooder (Customer)
  • October 10, 2019
That is what we currently have. It gets us where we need, but this seems like it should be a configurable option in IFS. The need to right click and run a saved sort every time you load the same page is the exact reason to have automation. At least have the default order by and where clauses as a table in the DB that we can update.

JDKirkendoll wrote:
Can you set up a saved search from within Search In Context (right mouse button option when in the components table) to achieve this? The downside to that, if it would work, would be that it wouldn’t take effect until you ran it after the top level search.

Forum|alt.badge.img+8
  • Sidekick (Customer)
  • April 2, 2020
KasunBalasooriya wrote:

Hi, Welcome to the IFS Community. The default where and the default order by are properties set during the development stage of the core forms. These properties are not available to be modified to the end user.
These properties are used during the populate operation of the form. If it needs to be changed, a customization is needed.
However, as a workaround, the default behavior can be changed to show the search dialog from the form properties and then a saved search can be used for the population.
 

94242fe9-b7bf-4aa4-aed3-1e605769fb88.png

 


Hope this helps!

 

 

Hello,

do this response apply also to IFS 10 or was it improved in some way?

I tried to put DefaultOrderBy in Profile Entry, but such doesn’t seem to work as well.

/Wiktor


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings