Maintenance Filters and Search Filters  Topic is solved

Discussions relating to plugin development, and the Jiwa API.

Maintenance Filters and Search Filters

Postby SBarnes » Fri Feb 05, 2021 12:27 pm

How can you add Maintenance Screen Filters and Search Filters programmatically?

Is there a way to export and import them between databases?
Regards
Stuart Barnes
SBarnes
Shihan
Shihan
 
Posts: 1618
Joined: Fri Aug 15, 2008 3:27 pm
Topics Solved: 175

Re: Maintenance Filters and Search Filters  Topic is solved

Postby Mike.Sheen » Mon Feb 08, 2021 12:14 pm

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.
Mike Sheen
Chief Software Engineer
Jiwa Financials

If I do answer your question to your satisfaction, please mark it as the post solving the topic so others with the same issue can readily identify the solution
User avatar
Mike.Sheen
Overflow Error
Overflow Error
 
Posts: 2444
Joined: Tue Feb 12, 2008 11:12 am
Location: Perth, Republic of Western Australia
Topics Solved: 756

Re: Maintenance Filters and Search Filters

Postby SBarnes » Mon Feb 08, 2021 12:25 pm

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?
Regards
Stuart Barnes
SBarnes
Shihan
Shihan
 
Posts: 1618
Joined: Fri Aug 15, 2008 3:27 pm
Topics Solved: 175

Re: Maintenance Filters and Search Filters

Postby Mike.Sheen » Mon Feb 08, 2021 2:17 pm

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.
Mike Sheen
Chief Software Engineer
Jiwa Financials

If I do answer your question to your satisfaction, please mark it as the post solving the topic so others with the same issue can readily identify the solution
User avatar
Mike.Sheen
Overflow Error
Overflow Error
 
Posts: 2444
Joined: Tue Feb 12, 2008 11:12 am
Location: Perth, Republic of Western Australia
Topics Solved: 756

Re: Maintenance Filters and Search Filters

Postby SBarnes » Mon Feb 08, 2021 2:19 pm

Thanks.
Regards
Stuart Barnes
SBarnes
Shihan
Shihan
 
Posts: 1618
Joined: Fri Aug 15, 2008 3:27 pm
Topics Solved: 175


Return to Technical and or Programming

Who is online

Users browsing this forum: No registered users and 5 guests

cron