.. ==================================================
.. FOR YOUR INFORMATION
.. --------------------------------------------------
.. -*- coding: utf-8 -*- with BOM.

.. include:: ../../Includes.txt


.. _administrators_analysis:

Analysis
========

Which views are used?

.. code:: sql

  SELECT    COUNT(ExtractValue(pi_flexform,'/T3FlexForms/data/sheet[@index="sDEF"]/language/field[@index="viewsList"]/value')) AS qty,
            ExtractValue(pi_flexform,'/T3FlexForms/data/sheet[@index="sDEF"]/language/field[@index="viewsList"]/value') AS viewsList
  FROM      tt_content 
  WHERE     CType = 'list'
  AND       list_type LIKE 'browser%'
  GROUP BY  ExtractValue(pi_flexform,'/T3FlexForms/data/sheet[@index="sDEF"]/language/field[@index="viewsList"]/value')
  ORDER BY  viewsList;


Find all plugins with an empty view

.. code:: sql

  SELECT    pid,
            uid,
            ExtractValue(pi_flexform,'/T3FlexForms/data/sheet[@index="sDEF"]/language/field[@index="viewsList"]/value') AS viewsList,
            hidden AS chidden,
            deleted AS cdeleted
  FROM      tt_content 
  WHERE     CType = 'list'
  AND       list_type LIKE 'browser%'
  AND       ExtractValue(pi_flexform,'/T3FlexForms/data/sheet[@index="sDEF"]/language/field[@index="viewsList"]/value') = ''
  ORDER BY  pid,
            uid;


Find all plugins with a specific view

.. code:: sql

  SELECT    pid,
            uid,
            ExtractValue(pi_flexform,'/T3FlexForms/data/sheet[@index="sDEF"]/language/field[@index="viewsList"]/value') AS viewsList,
            hidden AS chidden,
            deleted AS cdeleted
  FROM      tt_content 
  WHERE     CType = 'list'
  AND       list_type LIKE 'browser%'
  AND       61826 IN (ExtractValue(pi_flexform,'/T3FlexForms/data/sheet[@index="sDEF"]/language/field[@index="viewsList"]/value'))
  ORDER BY  pid,
            uid;