Using SuiteScript 2.1, in a Suitelet that adds a

serverWidget.SublistType.LIST

and contains a

serverWidget.FieldType.DATETIMETZ

column, write an example that properly sorts this column

AI generated answer (using internal Slack threads):

Based on the conversations, it appears that Suitelets do not provide a built-in way to sort a sublist. However, you can sort your data before adding it to the sublist. This means that if you have a

serverWidget.SublistType.LIST

that contains a

serverWidget.FieldType.DATETIMETZ

column, you would need to sort your data based on this column before adding it to the sublist. Here is an example of how you might do this:

javascript
/**
 * @NApiVersion 2.1
 * @NScriptType Suitelet
 */
define(['N/ui/serverWidget', 'N/search'], function(serverWidget, search) {
    function onRequest(context) {
        if (context.request.method === 'GET') {
            var form = serverWidget.createForm({
                title: 'My Form'
            });
            var sublist = form.addSublist({
                id: 'mysublist',
                type: serverWidget.SublistType.LIST,
                label: 'My Sublist'
            });
            sublist.addField({
                id: 'datetimefield',
                type: serverWidget.FieldType.DATETIMETZ,
                label: 'Date Time Field'
            });

            // Perform a search to get your data
            var mySearch = search.create({
                // your search parameters here
            });
            var searchResults = mySearch.run().getRange({
                start: 0,
                end: 1000
            });

            // Sort your data based on the DATETIMETZ field
            searchResults.sort(function(a, b) {
                return new Date(a.getValue('datetimefield')) - new Date(b.getValue('datetimefield'));
            });

            // Add your sorted data to the sublist
            for (var i = 0; i < searchResults.length; i++) {
                sublist.setSublistValue({
                    id: 'datetimefield',
                    line: i,
                    value: searchResults[i].getValue('datetimefield')
                });
            }

            context.response.writePage(form);
        }
    }

    return {
        onRequest: onRequest
    };
});

In this example, a search is performed to get the data, which is then sorted based on the

DATETIMETZ

field. The sorted data is then added to the sublist. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******