Adding a boolean field to existing populated table

Hi guys.

I'v added a boolean field to existing populated table, I've set the default value to True. I then added a filter in an aggregate "IsActive=True". I do see the new field in the table, but the fields are populated with the value false. I did not set it to Default = False when I first created it.

Any idea how I could get these fields populated with the value true?

Hi Jean-Pierre,

When you set a default, all that happens is that when you create a new variable of that Entity, the Attribute is filled with that value. It does nothing to the database, even not when you newly create the Attribute. What you need to do is bootstrap the database column. You can do that with a simple database script if you have access to the database, or with an Advanced Query.