Field Groups and dates

Sorry there! You are absolutely correct. My host uses PHP-version: 5.4.16 on the server that runs phpmyadmin - they are looking into the problem tomorrow - thank you!

But until then - would this Advanced filter be possible to use ?: WEEK(STR_TO_DATE(JSON_EXTRACT( `cb_teammoder`, '$[*].cb_teammode' ),'%Y-%m-%d')) = WEEK(CURRENT_TIMESTAMP)

Hmm.. this filter works:

JSON_EXTRACT( `cb_teammoder`, '$[0].cb_teammode') = '2020-11-09'

but this does not:

YEAR(UNIX_TIMESTAMP(STR_TO_DATE(JSON_EXTRACT( `cb_teammoder`, '$[0].cb_teammode'),'%Y-%m-%d'))) = YEAR(CURRENT_TIMESTAMP)

I do not get why ??

Ahhh got it now - this works:

WEEK(JSON_UNQUOTE(JSON_EXTRACT( `cb_teammoder`, '$[0].cb_teammode')),0) = WEEK(CURRENT_TIMESTAMP)

Now another question - in the template of the Field Groups - is it possible to get hold of the raw json data somehow in the template, so that I can create my own layout and maybe sort the dates from the JSON data ?

Now another question - in the template of the Field Groups - is it possible to get hold of the raw json data somehow in the template, so that I can create my own layout and maybe sort the dates from the JSON data ?

The JSON data needs to be processed and ran through field parsing behaviors. You shouldn't need to touch the raw JSON data at all. The template files are properly given an array of fields that you can then do whatever you like with. "display_row.php" is the field group row. "display_field.php" is the field group field in a row. "display.php" is the container for rows.

You can access the raw JSON just by accessing the field value from the $user object, but it's pointless as it's all just raw unprocessed data. I've already included a "list" and "table" template to show how you can sort and display the data in different ways. Sounds like the "table" template is more what you're wanting. Review the phpdoc at the top of the template files as you've access to a lot of the processed data there to do whatever you like with.