How to sort the result of the Services?

[xcheung]

Hi all,

I am now using File Repository Thing template to get ftp file info, and one of its service is called "GetFileListingWithLinks".

The result is an infotable, but I dont know how to sort the result by LastModifiedTime, which is one of the columns in the result table. (Cannot see/modified the code inside..).

I hope to get the latest File Info, so hope someone can help.

Thanks!

[supandey]

Hi Xiaoying, if the service you are using has the option to include Query parameter you can consider including the Sort option, this is covered in the Help documentation you can check here

[ssauvage-2]

Hi.

I think "sorts" parameter must be inside "filter" parameter, which contains also "filters" parameter...

So something like this:

filter: {
      "sorts": [
          {
              "fieldName": "UID",
              "isAscending": false
          }
      ],
	"filters": {
		"fieldName": "Name",
		"type": "EQ",
		"value": "myNameValue"
	}
}

Sébastien

[CarlesColl]

Alternatively you can use also Sort snippets, there's two:

// Option 1 - In-place

myInfotable.Sort({ name: "fieldName", ascending: true/false });

// Option 2 - New Sorted Infortable

var myInfotableSorted = Resources["InfoTableFunctions"].Sort({

    t: myInfotable,

    sortColumn: "fieldName",

    ascending: true/false

});