Appian Sites: Requirement to Stay the Entered Filter text After Submission

Question

Hello Everyone, 
 I have a requirement that says: 
 On a sail interface of an 'Appian site', I have a textField for a filter and a grid with data. 
 User searches for a text using the filter and the data gets filtered and then, he/she selects a record and add some notes for that selected record and submits. 
 The data gets saved into database and the as it's an Appian sites, the flow comes back to the same start form screen but filter text is blank now. 
 How can I keep the filter text value in the text field as it was entered by the user? 
 
 Thanks, 
 Omkar

Omkar K · Accepted Answer

Thank you Chaitanyam and Lakshmi. As I am using Appian sites and an Appian site has to start with a start form, hence, I just wanted entered local!filterText variable's value to retain it's value when user submits the form. However, it loads the UI again and the value gets set to null. Hence, to avoid any DB calls due to performance restrictions and to solve this issue, there is a workaround that adding a User Input Task after the start form task and having it in a infinite loop with timer exception condition so that the process instance won't be active for infinite time.

Krishna Chaitanya · Answer

hi omkar, 1)create a table in data base where columns are id,user,search field. 
 2)when user entered the filter,with that filter text ,after submit save the data in data base table which you have created above(one user have only one record,if the same user entered the filter you have to replace with old one with new one ) 
 3)take one local variable in your interface,with logged in user fetch the filter text from db,if their populate in you text filed else nothing.

Lakshmi Meyyappan · Answer

This SAIL recipe should help: docs.appian.com/.../recipe_save_a_users_report_filters_to_data_store_entity.html