43
Views
8
Comments
Difference between Records and Attributes inside a Static Entity in O11

Can someone explain to me the difference between Records and Attributes inside a Static Entity in O11 ?


2025-04-15 04-00-33
Prakhar Sharma

Hi @May Bronshtin,

An attribute is a column in the table that defines the type of value. Record however, are the actual values.

Eg: If you create a static entity called Operating System, it can have attributes like Name, type, order etc. And it can have records like Android, IOS, Windows, MacOS etc.

You can read more about it here in this documentation.

Hope it helps!

2025-08-07 06-30-56
Amit J
Champion

Static Entity in OutSystems 11

A Static Entity is basically a lookup table you define in your model (like Status, Gender, Country). It’s compiled into your application and its data is read-only at runtime.

Inside a Static Entity you’ll see two main things:

1. Records

Each Record = one row of data in that static table.

Example: If you create a Static Entity called AppointmentStatus, your Records might be:

Scheduled

Completed

Cancelled


Think of them as the data values (rows).


2. Attributes

Attributes = the columns of the static entity.

By default, every Static Entity has:

Id (integer, unique identifier)

Label (human-readable name)

Is Active (boolean, for enabling/disabling values)


You can add your own Attributes if you want extra metadata.

Example: In AppointmentStatus, you might add an attribute Color (string) to store a hex code for UI display.

Then each Record (Scheduled, Completed, Cancelled) will have a value for that Color attribute.

 Difference in short


Records = Rows (the values of the entity)

Attributes = Columns (the properties that describe those values)

2025-03-12 07-08-15
Nilesh Trivedi

Hello,

In simple terms,

Static Entity as an entire Excel spreadsheet or database table. A Record is a single row in that table, and an Attribute is a single cell/column in that row. 

Hope it helps.

Thank u.

2025-07-28 06-45-20
Rupesh Patil
AI Generated

Hi @May Bronshtin 

In OutSystems 11 (O11), the concepts of Records and Attributes within a Static Entity are distinct but related, and understanding their roles is key to working with static data effectively.

  • Attributes: These are the individual fields or properties that define the structure of a Static Entity. Each Attribute represents a column or data point that a record can hold, such as "ID," "Name," or "Description." You define Attributes when designing the Static Entity, specifying their data types (e.g., Text, Integer, Boolean) and any constraints. Essentially, Attributes are the blueprint of the data.
  • Records: These are the actual data entries or rows within the Static Entity, based on the defined Attributes. When you create a Static Entity, you populate it with specific Records, each representing a unique instance of the entity. For example, if you have a Static Entity called "Country" with Attributes "ID" and "Name," the Records might include entries like {"1", "USA"} and {"2", "Canada"}.

Key Differences:

  1. Definition:
    • Attributes define what data can be stored (the structure).
    • Records contain the actual data (the content).
  2. Creation:
    • Attributes are created and configured in the Data tab when designing the Static Entity.
    • Records are added manually in the Static Entities section by specifying values for each Attribute.
  3. Purpose:
    • Attributes provide the schema or template for the data.
    • Records represent the specific, static dataset that the application uses at runtime.
  4. Example:
    • Static Entity: "Status"
    • Attributes: "Code" (Text), "Label" (Text)
    • Records: {"ACT", "Active"}, {"INACT", "Inactive"}

I hope this helps

Thanks

This answer was AI-generated. Please read it carefully and use the forums for clarifications
2019-11-11 17-10-24
Manish Jawla
 
MVP
2024-10-12 12-11-20
Kerollos Adel
Champion

Hallo @May Bronshtin  , 

Attributes in table columns like "Id , Name , Code"

Record is values in table like "{1 , Employee1 , Hoo1} , {2 , Employee 2 , Hppp1}"

 


2024-07-12 05-57-50
Gourav Shrivastava
Champion

Hello @May Bronshtin 

A Static Entity in OutSystems is like a small fixed list you define inside your app.

  • Records are the actual items in that list. Example: if you have a static entity called UserType, the records could be Admin, Manager, Employee.

  • Attributes are the details or properties of those items. By default, each item already has an Id and a Label, but you can add more details if you need them, like a Code or Description.


Read more about static entity

Thanks 

Regards 

Gourav Shrivastava 


2020-09-15 13-07-23
Kilian Hekhuis
 
MVP

Hi May,

A Static Entity is still a database entity (except in a library), so what goes for normal Entities also goes for Static ones. So what is, in a normal Entity, a Record, is also a Record in a Static Entity, and what is in a normal Entity, an attribute, is also an attribute in a Static Entity.

The key difference is that you specify the Records and the values of the Attributes design time, as opposed to normal Entities that you populate through your code.

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.