Array
(
    [sql] => 
    SELECT t1.*, 
    ROUND((val_presence*0.5) + (val_upfreq*0.25) + (val_machine_readable*0.25), 2) as c_index
    FROM (
        SELECT t0.main_category, t0.subcategory, t0.country, t0.country_name, t0.id_main_category, t0.sub_sort_ord,
                COALESCE(dr.n_indicators,0) n_indicators , 
                COALESCE(dr.presence, 0) presence,  
                COALESCE(dr.val_presence, 0) val_presence,
                COALESCE(dr.val_upfreq, 0) val_upfreq,
                COALESCE(dr.val_machine_readable, 0) val_machine_readable
            FROM (
                SELECT dgm.main_category, dgm.subcategory, dgm.country, cn.country_name, id_main_category,  dgm.sub_sort_ord
                FROM dgm
                INNER JOIN country cn ON cn.abbr = dgm.country
                WHERE dgm.rev_last = 1
                AND visible_subcategory = 1
                GROUP BY id_main_category, main_category, subcategory, country
                ORDER BY id_main_category, main_category, subcategory, country)
                t0 
            LEFT JOIN data_rank dr 
                ON dr.main_category = t0.main_category
                AND dr.subcategory = t0.subcategory
                AND dr.country = t0.country
                AND year=?
        ) t1 
    ORDER BY id_main_category, sub_sort_ord, main_category, subcategory, country_name
               
    [params] => Array
        (
            [0] => 2020
        )

    [errno] => SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #6 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'dguptake.dgm.sub_sort_ord' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
)
<br />
<b>Deprecated</b>:  Creation of dynamic property DataCountryTopic::$vmsql is deprecated in <b>/var/www/vhosts/dgmonitor/classes/src/DataCountryTopic.php</b> on line <b>35</b><br />
Array
(
    [sql] => SELECT DISTINCT id_indicator 
                FROM dgm 
                WHERE main_category=?
                 AND id_subcategory = ?
                ORDER BY id_subcategory, id_indicator
                
    [params] => Array
        (
            [0] => messaging
            [1] => 3020
        )

    [errno] => SQLSTATE[HY000]: General error: 3065 Expression #1 of ORDER BY clause is not in SELECT list, references column 'dguptake.dgm.id_subcategory' which is not in SELECT list; this is incompatible with DISTINCT
)
Array
(
    [sql] => SELECT DISTINCT id_indicator 
                FROM dgm 
                WHERE main_category=?
                 AND id_subcategory = ?
                ORDER BY id_subcategory, id_indicator
                
    [params] => Array
        (
            [0] => messaging
            [1] => 3030
        )

    [errno] => SQLSTATE[HY000]: General error: 3065 Expression #1 of ORDER BY clause is not in SELECT list, references column 'dguptake.dgm.id_subcategory' which is not in SELECT list; this is incompatible with DISTINCT
)
Array
(
    [sql] => SELECT DISTINCT id_indicator 
                FROM dgm 
                WHERE main_category=?
                 AND id_subcategory = ?
                ORDER BY id_subcategory, id_indicator
                
    [params] => Array
        (
            [0] => messaging
            [1] => 3010
        )

    [errno] => SQLSTATE[HY000]: General error: 3065 Expression #1 of ORDER BY clause is not in SELECT list, references column 'dguptake.dgm.id_subcategory' which is not in SELECT list; this is incompatible with DISTINCT
)
Array
(
    [sql] => SELECT DISTINCT id_indicator 
                FROM dgm 
                WHERE main_category=?
                 AND id_subcategory = ?
                ORDER BY id_subcategory, id_indicator
                
    [params] => Array
        (
            [0] => messaging
            [1] => 3040
        )

    [errno] => SQLSTATE[HY000]: General error: 3065 Expression #1 of ORDER BY clause is not in SELECT list, references column 'dguptake.dgm.id_subcategory' which is not in SELECT list; this is incompatible with DISTINCT
)
<br />
<b>Warning</b>:  Cannot modify header information - headers already sent by (output started at /var/www/vhosts/dgmonitor/classes/src/DbException.php:28) in <b>/var/www/vhosts/dgmonitor/classes/src/Rpc.php</b> on line <b>18</b><br />
{"main_category":{"id_main_category":3000,"main_category":"Messaging","visible":1,"sort_order":3,"summary":"Indicators for this topic focus on mapping the use of the national system for sending digital messages from government organisations to citizens and businesses.\nMessaging is measured by assessing the yearly numbers of cumulative registered users for both digital mail and SMS, downloaded and installed mobile applications, cumulative adhered public organisations and digital mails sent to both citizens and businesses."},"country":{"abbr":"DK","country_name":"Denmark","summary":"<p><strong>eID <\/strong><a href=\"https:\/\/www.nemid.nu\/dk-en\/about_nemid\/about_this_website\/\">NemID<\/a> is Denmark&rsquo;s national electronic identification system, which is used in both the public and private sector. A NemID is always a personal account. It can be used to <a href=\"https:\/\/digst.dk\/it-loesninger\/nemlog-in\/om-loesningen\/initiativer\/\">perform business transactions<\/a> if the person has been authorised to act on behalf of a company. NemID users also have the possibility to authorise another person to temporarily act on their behalf in digital self-service solutions (<a href=\"https:\/\/en.digst.dk\/digitisation\/digital-fuldmagt\/\">digital proxy<\/a>).<\/p>\n<p><strong>ePayment <\/strong>While there is a system for public authorities to realise e-payments to citizens and businesses, called NemKonto, the Danish government doesn't have a dedicated system for receiving e-payments from citizens and businesses.&nbsp;<\/p>\n<p><strong>Messaging <\/strong><a href=\"https:\/\/en.digst.dk\/digitisation\/next-generation-of-digital-post\/\">Digital Post<\/a> is the public authorities' shared mandatory IT solution that makes it possible to communicate securely with citizens, companies, and other governmental institutions. Additionally, <a href=\"https:\/\/www.borger.dk\/Om-borger-dk\/Saadan-bruger-du-borgerdk\/nemsms\">NemSMS<\/a> is a Danish public message service that government and municipal authorities use to send service text messages to the citizens and businesses, who are registered with the service.&nbsp;<\/p>\n<p><strong>Transparency <\/strong><a href=\"https:\/\/en.digst.dk\/digitisation\/national-citizen-portal\/\">My Overview<\/a> is the citizens&rsquo; personal page on the national citizen portal borger.dk. Here, citizens can log in using their NemID and see some of the information on them held by the public authorities.<\/p>\n<p><strong>General Digital Services <\/strong>The annual report on IT use among the Danish population includes the measurement of several user satisfaction indicators as well as statistics on the use of digital forms.<\/p>\n<p>For Denmark, the <em>Digital Government MetaMonitor<\/em> shows a high level of completeness of data on the uptake of NemID, NemSMS, user satisfaction and digital form submission. Improvements can be made on machine readability, especially with regards to data related to NemID and general digital services. Data on organisations offering insight in personal ongoing affairs through the central government portal are currently not available.&nbsp;<\/p>"},"subc":[{"id_subcategory":3020,"subcategory":"Overall uptake"},{"id_subcategory":3030,"subcategory":"Personal uptake"},{"id_subcategory":3010,"subcategory":"Business uptake"},{"id_subcategory":3040,"subcategory":"Public sector uptake"}],"timestamp":"2025-07-01T09:32:04+00:00"}