When an entity has had attributed moved around in terms of their order, and then added new ones after the fact and moved those around etc, I find that when using aggregates in OutSystems the preview data shows the columns not in the same order as the entity but rather the order of what I think is the actual database - which shows in original order and last added fields at the end etc. This makes it very confusing to find fields to the group and to check the data etc.
Is there a way to make it order the way the entity is ordered or should I log an idea for this?
Hi Nicholas Campbell,
I have the same thought as you, so when you try to inject a sample record by using the entity preview panel, it shows only the records that order by the Id in ascending order, which sometime did confuse me when I just want see if the test record did contain the correct data type in the DB.
Usually, I will just add a new sorting base on condition or add a test filter to see if my test data did inserted to the DB correctly.
So maybe an idea could be propose for such use case. :)
Hi Kay Lun
I think we may be talking about different things.
I am meaning the order of the columns/attributes not the order of the rows of actual data which is what I think you are talking about?
Ah Sorry for misunderstaind, so you means the entity attributes.
Yes I agree, the order of the attributes in DB was order by the creation time, but not the same order as we can see in the Entity of Service Studio, not sure if that's what you mean, but I think sometimes that does annoying. Also there's no work around to reorder them except recreating the entity...
Although I know it's normal cuz every attribute creation is just like a migration, when we create the column in table, the migration will run based on the file name order to insert a new column unless you have specific where they should put.
No problem. Yes this is what I mean, makes it hard to find the fields.
I agree, not sure how OS implement in the migration, but if they could insert the new attribute as we can see in Service Studio, that would be better.
But I guess it might be out of scrope tho.
Yeah, I am not too worried about the migration, but I think it is valid to want the aggregate preview to show in the same order as the entity... both are in Service Studio so they should match up...
What I mean is that what they do behind the scenes is up to them, but from a dev perspective I would want to see the data match up in terms or column order