How to arrange my entries using json??

Question

I have created a new service "Mlist_service" in "Mlist_datatable" added up having field definitions "entities_name" as primary key. Then I wrote json script in my service using snippet"Add/update datatable entry". when I export my data and entities and use it in another system,the order of my entries in "entites_name" is changed.

so how can I arrange my entries in "entities_name" in ascending order??

AnnaAn · Accepted Answer

Hi Bavithraa,So you mean in your mashup,firstly you call your service which add or update datatable entry and then you will call your service QueryDataTableEntries with event "ServiceInvokeCompleted" to refresh the Grid(Or list widget you mentioned above?).As what I did locally, you could create a new service say, it's called QueryCustom, and in the QueryCustom service, you could code like this:var query ={"sorts": [{"fieldName": "f1"}]};var params = {    maxItems: undefined /* NUMBER */,    values: undefined /* INFOTABLE*/,    query: query /* QUERY */,    source: undefined /* STRING */,    tags: undefined /* TAGS */};// result: INFOTABLE dataShape: "undefined"var result = me.QueryDataTableEntries(params);And here is the screenshot for my code:So in your mashup, after you add/update your data table every time, you call the QueryCustomer service, the Grid should be refreshed and ordered ascending. The reason you should not use QueryDataTableEntries directly in your mashup is that there is no sorting options input in the query parameter(it only has filter not sorting).Please let us know if this works and if further assistance needed.Thanks,

jamesm1 · Answer

Can you simple add a sort parameter to your service that returns the records? i.e. QueryDataTableEntries with a query parameter such as:

var query =
{
  "sorts": [
  {
      "fieldName": "entities_name"
  }
  ]
}

See this page for more details: Query Parameter for Query Services

Or is the field you're trying to sort a JSON object and you are wondering why it loses its sorting? If so, please note the definition of JSON according to www.json.org:

"An object is an unordered set of name/value pairs"

Therefor you should never rely on the ordering of elements.

Sign up

Please use your PTC eSupport account.

Welcome to the PTC Community

Please use your PTC eSupport account.