Page 1 of 1

Maintenance Filters and Search Filters

PostPosted: Fri Feb 05, 2021 12:27 pm
by SBarnes
How can you add Maintenance Screen Filters and Search Filters programmatically?

Is there a way to export and import them between databases?

Re: Maintenance Filters and Search Filters  Topic is solved

PostPosted: Mon Feb 08, 2021 12:14 pm
by Mike.Sheen
SBarnes wrote:How can you add Maintenance Screen Filters and Search Filters programmatically?

Is there a way to export and import them between databases?


For the maintenance forms, take a look at DEV-6483 - it has a good example on how to add sort orders.

For the filters, you need to populate the SY_Filters table manually - no built-in way of exporting or importing those, either - but that is a simple little table.

Re: Maintenance Filters and Search Filters

PostPosted: Mon Feb 08, 2021 12:25 pm
by SBarnes
Thanks Mike,
Sort orders I have already worked out how to do.

So how are filter numbers allocated such as for a custom search, or can you just come up with magic number that's not already in the table, what I am saying is how can you avoid a conflict in an upgrade to Jiwa, is there a range that Jiwa will stay within?

Re: Maintenance Filters and Search Filters

PostPosted: Mon Feb 08, 2021 2:17 pm
by Mike.Sheen
SBarnes wrote:Thanks Mike,
Sort orders I have already worked out how to do.

So how are filter numbers allocated such as for a custom search, or can you just come up with magic number that's not already in the table, what I am saying is how can you avoid a conflict in an upgrade to Jiwa, is there a range that Jiwa will stay within?


Yep, magic numbers it is. Our currently max used is 50055 - if you number yours above say 500,000 I don't think you'll ever run into a conflict.

Re: Maintenance Filters and Search Filters

PostPosted: Mon Feb 08, 2021 2:19 pm
by SBarnes
Thanks.