Graphics

I understand that it is possible to reorder data via SQL Queries via this tutorial. - Using SQL Queries to Automatically Order External Data Dynamically

But is it possible to reorder JSON data dynamically in datalinq?

Do you know anyone who knows Python? They could make you a file that reoarders the json file. 

Alternatively I think you'd need to reorder once its inside XPression already. 

What are you try to do because you can do pretty decent searches on XML that I think would work on json such as;

team\player<<2>oncourt=Y>\stats 

I understand that it is possible to reorder data via SQL Queries via this tutorial. - Using SQL Queries to Automatically Order External Data Dynamically

But is it possible to reorder JSON data dynamically in datalinq?

In Version 10.5 and higher, You can use <max>, <max-1>, <max-2>, etc., to find the highest, second highest, third highest element, etc., in your array:

in DataLinq, when searching for data in a tree based DataLinq, the <index> field can now use the keyword "max" to return the element from the highest array index.  e.g. scoring\plays<max>\description will return the description from the highest play element.  <max-1> would return the second highest element, etc.

Do you know anyone who knows Python? They could make you a file that reoarders the json file. 

Alternatively I think you'd need to reorder once its inside XPression already. 

What are you try to do because you can do pretty decent searches on XML that I think would work on json such as;

team\player<<2>oncourt=Y>\stats 

I understand that it is possible to reorder data via SQL Queries via this tutorial. - Using SQL Queries to Automatically Order External Data Dynamically

But is it possible to reorder JSON data dynamically in datalinq?

In Version 10.5 and higher, You can use <max>, <max-1>, <max-2>, etc., to find the highest, second highest, third highest element, etc., in your array:

in DataLinq, when searching for data in a tree based DataLinq, the <index> field can now use the keyword "max" to return the element from the highest array index.  e.g. scoring\plays<max>\description will return the description from the highest play element.  <max-1> would return the second highest element, etc.

Do you know anyone who knows Python? They could make you a file that reoarders the json file. 

Alternatively I think you'd need to reorder once its inside XPression already. 

What are you try to do because you can do pretty decent searches on XML that I think would work on json such as;

team\player<<2>oncourt=Y>\stats 

I understand that it is possible to reorder data via SQL Queries via this tutorial. - Using SQL Queries to Automatically Order External Data Dynamically

But is it possible to reorder JSON data dynamically in datalinq?

This is great. Thank you for this. Can you also do the same for <min>, or is it exclusive to Max value? I tested it with <min>, and it didn't seem to work.

Do you have some document that lists all these functions for the <index> for future reference? 

In Version 10.5 and higher, You can use <max>, <max-1>, <max-2>, etc., to find the highest, second highest, third highest element, etc., in your array:

in DataLinq, when searching for data in a tree based DataLinq, the <index> field can now use the keyword "max" to return the element from the highest array index.  e.g. scoring\plays<max>\description will return the description from the highest play element.  <max-1> would return the second highest element, etc.

Do you know anyone who knows Python? They could make you a file that reoarders the json file. 

Alternatively I think you'd need to reorder once its inside XPression already. 

What are you try to do because you can do pretty decent searches on XML that I think would work on json such as;

team\player<<2>oncourt=Y>\stats 

I understand that it is possible to reorder data via SQL Queries via this tutorial. - Using SQL Queries to Automatically Order External Data Dynamically

But is it possible to reorder JSON data dynamically in datalinq?

Match Multiple Search Criteria

The XML/JSON datalinqs can now search multiple attributes or elements to return a node that matches all search criteria.  e.g. players<team=NY;jersey=10>

Look For Increments of an Index Value or Search Criteria

A DataLinq comparison key such as <club=ross> can now have an additional index parameter as well, like so <club=ross<2>>, which will retrieve the second item matching the key.

Search Through Child Elements and Attributes

The XML datalinq types can search for children elements/attributes in a level of the tree by using "childname.field=%key%".  e.g. player<info.jersey=%num%>\name

Find the Highest Index Value of an Element

The <index> field can now use the keyword "max" to return the element from the highest array index.  e.g. scoring\plays<max>\description will return the description from the highest play element.  <max-1> would return the second highest element, etc

This is great. Thank you for this. Can you also do the same for <min>, or is it exclusive to Max value? I tested it with <min>, and it didn't seem to work.

Do you have some document that lists all these functions for the <index> for future reference? 

In Version 10.5 and higher, You can use <max>, <max-1>, <max-2>, etc., to find the highest, second highest, third highest element, etc., in your array:

in DataLinq, when searching for data in a tree based DataLinq, the <index> field can now use the keyword "max" to return the element from the highest array index.  e.g. scoring\plays<max>\description will return the description from the highest play element.  <max-1> would return the second highest element, etc.

Do you know anyone who knows Python? They could make you a file that reoarders the json file. 

Alternatively I think you'd need to reorder once its inside XPression already. 

What are you try to do because you can do pretty decent searches on XML that I think would work on json such as;

team\player<<2>oncourt=Y>\stats 

I understand that it is possible to reorder data via SQL Queries via this tutorial. - Using SQL Queries to Automatically Order External Data Dynamically

But is it possible to reorder JSON data dynamically in datalinq?

Hi Jeff, 

I hope you are well. I am returning to this for another project but have little luck with it working. I believe I am doing everything correctly. Can you look at this screenshot and let me know what you think? 

Match Multiple Search Criteria

The XML/JSON datalinqs can now search multiple attributes or elements to return a node that matches all search criteria.  e.g. players<team=NY;jersey=10>

Look For Increments of an Index Value or Search Criteria

A DataLinq comparison key such as <club=ross> can now have an additional index parameter as well, like so <club=ross<2>>, which will retrieve the second item matching the key.

Search Through Child Elements and Attributes

The XML datalinq types can search for children elements/attributes in a level of the tree by using "childname.field=%key%".  e.g. player<info.jersey=%num%>\name

Find the Highest Index Value of an Element

The <index> field can now use the keyword "max" to return the element from the highest array index.  e.g. scoring\plays<max>\description will return the description from the highest play element.  <max-1> would return the second highest element, etc

This is great. Thank you for this. Can you also do the same for <min>, or is it exclusive to Max value? I tested it with <min>, and it didn't seem to work.

Do you have some document that lists all these functions for the <index> for future reference? 

In Version 10.5 and higher, You can use <max>, <max-1>, <max-2>, etc., to find the highest, second highest, third highest element, etc., in your array:

in DataLinq, when searching for data in a tree based DataLinq, the <index> field can now use the keyword "max" to return the element from the highest array index.  e.g. scoring\plays<max>\description will return the description from the highest play element.  <max-1> would return the second highest element, etc.

Do you know anyone who knows Python? They could make you a file that reoarders the json file. 

Alternatively I think you'd need to reorder once its inside XPression already. 

What are you try to do because you can do pretty decent searches on XML that I think would work on json such as;

team\player<<2>oncourt=Y>\stats 

I understand that it is possible to reorder data via SQL Queries via this tutorial. - Using SQL Queries to Automatically Order External Data Dynamically

But is it possible to reorder JSON data dynamically in datalinq?