Can someone explain to me the difference between Records and Attributes inside a Static Entity in O11 ?
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!
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)
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.
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.
Key Differences:
I hope this helps
Thanks
Hi @May Bronshtin ,
Please check the outsystems documentation regarding static documentation:
https://success.outsystems.com/documentation/11/building_apps/data_management/data_modeling/static_entities/
And this training video https://learn.outsystems.com/training/journeys/web-developer-662/static-entities/o11/412
Regards,
Manish Jawla
Hallo @May Bronshtin ,
Attributes in table columns like "Id , Name , Code"
Record is values in table like "{1 , Employee1 , Hoo1} , {2 , Employee 2 , Hppp1}"
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
Regards
Gourav Shrivastava
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.