Setting TTL on a Data Model / Table

Setting TTL on a Data Model / Table

In designing solid applications, it is best practice to consider the data you’ll be storing in Fuuz, and determine with your business users how long that data should be retained. In Fuuz you can do this by establishing appropriate TTL’s on your data models using ‘indicies’.

 Instructions

  1. Navigate to the Schema Designer

  2. Locate the Data Model you wish to apply TTL to - Drag that out to the canvas and select it by clicking on it to highlight and expose the configuration panel to the right side of the designer canvas.

  3. Scroll the panel down until you see “Indicies” - expand this panel

  4. Click the 

     option to add a custom index

  5. Within the custom index, define the date field you wish to use as your base line

  6. Set the TTL value (in seconds)

    1. This is the amount of time, from the date / time in the date field you’ve selected to effect the TTL

  7. Save and Deploy your changes

You can not set TTL on the pre-system defined indicies, however, you an add your own custom indicies (even for the same fields as the system defined inidices) and then set your TTL.

  1. Navigate to Schema Designer

  2. Select the Data Model and drag to the canvas

  3. Select the Data Model - expose the configuration panel - scroll to Indicies

  4. Click 

Then:

  1. Set the Index name

  2. Set the TTL (seconds) - example is 1 year

  3. Set the field to index on - example is [“createdAt”]

  4. Save/Deploy your updates

    • Related Articles

    • Table

      In the context of Fuuz screen design or a web page within the Fuuz platform, a "table" refers to a structured and organized grid-like layout component used to present and display data in a tabular format. Tables are a fundamental part of user ...

    • Data Model Deployment Logs

      Open the Fuuz app. Select the Fuuz dropdown menu. Select the System option. Select the Data Modeling option. Select the Data Model Deployment Logs option. From here, it is possible to perform the following task or tasks. Search for a data model ...

    • Table Feature: Master/Detail View

      Master/Detail View is a feature available for the table screen element. This functionality allows the user to drag in screen elements inside of a table to design the table’s detail view. Once the screen is rendered, each row in that table will have ...

    • Schema Designer FAQ's

      Setting TTL on a Data Model / Table Adding multiple fields in Schema Designer

    • Processing Model

      The JSONata processing model The JSONata type system JSONata is a superset of JSON and the JSONata type system is a superset of the JSON data types. In common with all functional programming languages, the function is also a first-class data type. ...