API enhancement suggestion: NULL-sorting in com.smartgwt.client.types.SortDirection

[Blama]

Hi Isomorphic,

As Oracle (and most likely other RDBMS as well) support a NULLS-clause in the ORDER BY clause, you could support that, too.

I think you could either add four new items (ASCENDING_NULLS_FIRST, ASCENDING_NULLS_LAST, DESCENDING_NULLS_FIRST, DESCENDING_NULLS_LAST) to SortDirection
(http://www.smartclient.com/smartgwte...Direction.html) or create a new constructor for SortSpecifier (http://www.smartclient.com/smartgwte...Specifier.html) which might look like

SortSpecifier(java.lang.String fieldName, SortDirection sortDirection, NullsDirection nullsDirection)

with NullsDirection being a two item enum.

I don't think this is a high-priority request, but it would be nice to see SmartGWT cover this small hole. What do you think?

Best regards,
Blama

[Isomorphic]

This could make sense, but would require a lot of DB-specific work and testing to complete the feature. Since it hasn't been requested before, it's unlikely this will happen unless someone sponsors the feature.