What data type should I use for a MultiComboBoxItem

[wallytax]

Hi Blama,

Thanks for your reply. My comments per bullet:

• Check
• Check
• Either via initialSort: [{ property: 'id', direction: 'descending'

...

[wallytax]

I should not have mentioned the SQL example where no ORDER BY was specified. I would indeed not leave the sorting to the database: in case no sorting...

[wallytax]

I come to a point that I hardly dare to ask anything, without feeling stupid... It's not feeling very comfortable.

Let's say that having...

[wallytax]

Suppose the screen has no initial sorting, the user adds a sorting column and later decides that sort order has to made undone. In this case, I would...

[wallytax]

I've read your answer and I've decided to drop my functionality. So when a record is created or updated (and I believe then it only happens if the sorting...

[wallytax]

I think (and hope) that I have a working solution for my project. I discussed this with a fellow programmer and we think that it is consistent to clear...

[wallytax]

BTW, maybe I'm lost in the whole discussion but for me it's unclear if this behavior has changed since around April 1st, 2020. If this is the case, then...

[wallytax]

You are right about the 2 b/c point. Reading it a day later makes me realise that is not desired behavior. But I don't think I want the sorting settings...

[wallytax]

And a final question about displaying the roles in the corresponding grid. I've managed to do this, by defining this method on the grid field:
...

[wallytax]

When using a field in the form that does not exist in the data source, it works! Is the data source field type "text" the problem?
...

[wallytax]

I have a data source with a "text" field that has its values separated with "|" to store user roles (to keep the database simple I...

[wallytax]

To be 100% clear about what you're saying... partial cache means that only a subset of all available data is loaded into the grid, isn't? So this happens...

[wallytax]

For me, right now it would be sufficient to know that if I set updatePartialCache to true, adding a record does not remove the sort. The same would be...

[wallytax]

Hi Blama, thanks for your reply! Maybe it's the time of day and that I'm a bit tired, but I've not seen the "full solution". I'm pretty sure...

[wallytax]

When allowing multiple sort columns in a grid, a request query string is constructed like this:

_sortBy=-number&_sortBy=name

(first sort field is...

[wallytax]

Could this issue be back? I'm not using inline editing, but external editing via the same data source and the grid gets reloaded.

[wallytax]

I have debugged for another 4 (!) hours now, without any real result, but let me give you something that I have found, hoping that somebody knows what's...

[wallytax]

I'm not sure why I wanted this back then (I surely had a good reason for it). Right now, I will not set the option and see what happens. I've tested quite...

[wallytax]

I narrowed it down to changes between versions v12.0p_2020-03-29/LGPL and v12.0p_2020-04-01/LGPL. Somewhere in between this behavior seems to have changed....

[wallytax]

It looks like my code breaks after 4,5 years. I see refreshes of data in my grids after I save records via the same data source. After disabling this...