This release of query field brings some great new features like Query Tag field type Query Autocomplete for Text field type. Check out the details below.

Lets first start off with the same great features in CB Code Field 2.1.0 are also now in CB Query Field 6.1.0. This includes Query Tag field type, Query Autocomplete for Text field type (including the new Strict mode), Additional Fields for Query Validation. Check out the details in the below CB Code Field 2.1.0 blog post.

https://www.joomlapolis.com/blog/kyle/18903-cb-code-field-2-1-0

For exclusive new features in CB Query Field 6.1.0 the substitution parsing for query column data has been significantly improved. Previously you had no means of accessing for example JSON data inside of a column. The substitution would simply just output the JSON string. Now you can actually access the JSON data directly. Lets use the below for example.

SELECT `options`
FROM `#__options_table`
WHERE `user` = 1234

With the above lets for example assume `options` would give us the below JSON result.

{"favorite_color":"Red","favorite_food":"BACON!"}

Now to access this you'd use the below column substitutions in your query display parameters.

[column_options_favorite_color]

[column_options_favorite_food]

It's that easy! It doesn't stop there. What if your JSON contains an array of data? You can substitution those in too! Simply add the array index to the substitution beginning with 0 and you can navigate through your data easily. Example as follows.

[column_options_0_favorite_color]

[column_options_0_favorite_food]

For a full change log please visit the below forge link.

https://forge.joomlapolis.com/projects/cb-cbqueryfield/issues?query_id=166