Enterprise Application Development

Fast Modeling, Responsive Design, One-Button Deploy

BOOK a Demo

Economic theory-based business modeling

Resources, Events, Agents

BOOK a Demo
OMNIA – Low-Code Business Application Development Platform

Feature Highlight: Access creation and update dates in advanced queries
Posted March 16th, 2021

Feature Highlight: Access creation and update dates in advanced queries
Posted March 16th, 2021

If you’ve been developing applications with OMNIA chances are you’ve already used our Queries. Did you know that is possible to access the Entity creation and last update date in any query?

For this simple example, we’ve added the properties _created_at and _updated_at to our list and respective query. Here’s how we’ve added this properties to our query:

After the Query creation you should apply the created query onto a List and then include the List into a Dashboard. Here is an example of what our list looks like:

With the example we’ve shown today, you’ve learned how to include the creation and last update date of an Entity in an OMNIA Query.

It is important to mention that this _created_at and _updated_at properties are also accessible inside our Advanced Queries, enabling you to use them on a more complex scenario:

SELECT driver._code, driver._name, driver._updated_at, driver._created_at 
FROM vw_Driver driver 
WHERE driver._updated_at > driver._created_at 

On the example listed above, the _created_at and _updated_at properties can be used to filter the records that have been changed after their creation.

If you still don’t have this feature and want to start using it, remember to update your OMNIA platform to version 3.4.27, or above.

Platform Update and Documentation

This new feature is part of our 3.4.27 version of the platform.

πŸ“„Β Documentation