Skip to Content (Press Enter)
UserImage.jpg
Jean-Pierre Brits
119Views
1Comments
Solved
Adding a boolean field to existing populated table
Question
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?
0
0
21 Apr 2016
Copy Link
2020-09-15 13-07-23
Kilian Hekhuis
 
MVP
Solution
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.
0
0
21 Apr 2016
Copy Link
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.