It is currently 21 April 2025, 13:10 Advanced search

clear all search criteria with one process

Questions and answers on how to best use Instant Developer

clear all search criteria with one process

Postby Ted Giles » 27 May 2021, 12:52

When creating a search is it possible to reset the search criteria without closing the form and reopening it?
The form has Value List/Distinct and if there are a number of fields populated, I'm looking for a one button reset if possible.
User avatar
Ted Giles
 
Posts: 590
Joined: 29 November 2013, 12:58
Location: The Wolds, Lincolnshire, UK

Re: clear all search criteria with one process

Postby NiPe » 27 May 2021, 12:58

Hi, i think you can build a custom command on pannel, and in linked procedure using a reflection system for looking in structure/qbe filter and remove it...
NiPe
 
Posts: 27
Joined: 28 September 2020, 8:19

Re: clear all search criteria with one process

Postby ljwilson » 27 May 2021, 14:17

Or just set each panel field's (make sure you use the "yellow" icon one) qbefilter to "" or null in a procedure in your form and link that to a button

2021-05-27_10-14-39.png
2021-05-27_10-14-39.png (3.21 KiB) Viewed 1825 times


...jack
ljwilson
 
Posts: 783
Joined: 26 November 2013, 14:15

Re: clear all search criteria with one process

Postby r.bianco » 27 May 2021, 15:46

If I understand the context, I suggest this to you:

Code: Select all
Panel.enterQBEMode()
Panel.undoChanges()
Panel.findData()
only work and no play makes jack a dull boy
r.bianco
 
Posts: 4962
Joined: 8 November 2010, 16:46

Re: clear all search criteria with one process

Postby Ted Giles » 27 May 2021, 16:27

Thanks for the suggestions.
I will try it today and report back.

Edit. Yep, the Panel commands got me started.
I will pose another question as a new item
User avatar
Ted Giles
 
Posts: 590
Joined: 29 November 2013, 12:58
Location: The Wolds, Lincolnshire, UK


Return to Tips & Tricks

Who is online

Users browsing this forum: No registered users and 28 guests

cron