CYPEX is in charge of handling everything from rapid prototyping to full application development.

When building a full application, it can become necessary to schedule jobs. CYPEX offers the means to make that happen using pg_timetable, a job scheduler developed by CYBERTEC. It’s able to handle all kinds of job execution tasks.

Let’s take a look at a sample use case:

• When a contract is entered, somebody else should be notified
• If there is no response, try again in two weeks

The way to integrate job scheduling with CYPEX is by using standard SQL tables. In pg_timetable, every job is stored in tables. By writing database-side code, you have a transactional way of scheduling jobs.

• Ability to remove the existing workflow
• Default table simple filter, able to filter on a numeric column
• Notifications can be created and sent by the admin to the end-user
• Ability to see the difference between the query statement and the view statement
• Added info on the queries that this app already includes
• Ability to see tables and views list during query creation
• Simple UI to build a fixed filter with expressions for the table by using autocomplete input elements
• Ability to use the page load timestamp in custom expression
• Use lodash in custom expressions
• Ability to perform any actions via a button
• Reset an autocomplete input on call button success
• Show more values in the autocomplete input than visible if values are available

• Custom query update does not refresh definition.