I want to display search results using search conditions set when displaying a page with ConfiForms.

[y-mori]

Could you please tell me how to display the search results according to the specified search conditions when displaying the page?

I am using ConfiForms to create a page that displays search results that match the search conditions using the following two macros.

・ConfiForms Form Filter Control macro

・ConfiForms TableView macro

The number of data items searched when displaying the page is increasing, and it is taking time to load.

Therefore, we would like to display search results based on preset search conditions when the page is displayed.

I was able to set the initial value for the search conditions when displaying the page, but I was not able to display the search results using those search conditions.

[Humashankar VJ]

Hi @y-mori 

Please make use of the help article - To learn more:

 wiki.vertuna.com/display/CONFIFORMS/Using+and+configuring+ConfiForms+Dynamic+Filter+Control

To apply this to your scenario, you'll need to set up the ConfiForms Form Filter Control macro.

• This involves adding and configuring the macro, then defining the fields to be filtered and setting the default (preset) values for these fields.
• For example, if you want to filter by a field named "status" with a value of "Open", you would set the initial filter parameter accordingly.

To customize the layout,

• You can add ConfiForms Field macros inside the Form Filter Control macro to specify the fields and layout you want to use.
• For instance, to include a free text search with a custom layout, you would add a ConfiForms Field macro with the field name parameter set to * (wildcard).

Next, you'll need to configure the ConfiForms TableView macro.

• This involves adding and configuring the macro, then ensuring that the Filters to apply on page load parameter is set to use the same filter conditions as in the Form Filter Control macro.
• You'll also need to enable filter support for the TableView macro, as well as sync the filters and views to ensure that the filter condition is consistently applied.

To optimize loading, you can set pagination in the TableView macro to limit the number of results shown at once and enable lazy loading for the table.

Additionally, if you have a large dataset and want to show no results initially, you can use a filter that will not match anything, such as "text _today:<0". Once the user applies a valid filter, the results will be displayed.

Hope this helps - Happy to help further!!
Thank you very much and have a great one!
Warm regards