Question

Default “order by” in Apps 9

  • 9 October 2019
  • 5 replies
  • 643 views

Userlevel 1
Badge +3
Is there any way to modify the default “order by” clause in the enterprise application?


5 replies

Userlevel 7
Badge +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!
Userlevel 1
Badge +3
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.
Userlevel 1
Badge +3
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.
Userlevel 1
Badge +3
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.

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.
Userlevel 4
Badge +8

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