For session api, default sort of -id works but when I sort but `id` it fails with an Database query error
This is my request - https://192.168.1.10/api/session?calculate_count=true&sort=id
Application log has the following
Script: /guest/apigility.php
Function: NwaDalLogAndObscure
Arguments: array (
'result' => array (
'error' => 1,
'message' => 'Modify query failed: ERROR: column "iacct_id" does not exist
LINE 1: ...NULL END, t.username)::citext WHERE TRUE ORDER BY "iacct_id"...
^
HINT: Perhaps you meant to reference the column "t.acct_id".
[SQLSTATE 42703]',
'sql' => 'DECLARE cursor_319e9621d97d5b53925f044d0a6bfcd0 NO SCROLL CURSOR FOR SELECT (CONCAT(t.acct_id, \'|\', calling_station_id)) AS "id",t.acct_id AS "acct_id",array_to_string(t.session_id, \',\') AS "acctsessionid",t.username AS "username",t.nad_ip AS "nasipaddress",extract(\'epoch\' from start_time) AS "acctstarttime",extract(\'epoch\' from end_time) AS "acctstoptime",duration AS "acctsessiontime",input_bytes AS "acctinputoctets",output_bytes AS "acctoutputoctets",(SELECT DISTINCT Array_to_string(roles, \', \') from auth WHERE session_id = ANY(t.session_id)) AS "tipsrole",t.aruba_user_role AS "arubauserrole",t.aruba_user_vlan AS "arubauservlan",(COALESCE(input_bytes,0) + COALESCE(output_bytes,0)) AS "total_traffic",updated_at AS "updated_at",calling_station_id AS "callingstationid",t.called_station_id AS "calledstationid",t.cppm_uuid AS "cppm_uuid",t.nas_port_id AS "nasportid",t.nas_port_type AS "nasporttype",nads.name AS "nas_name",termination_cause AS "acctterminatecause",framed_ip AS "framedipaddress",(SELECT string_agg(DISTINCT service, \',\') from auth a WHERE a.session_id = ANY(t.session_id)) AS "servicetype",(SELECT string_agg(DISTINCT ssid, \',\') from auth a WHERE a.session_id = ANY(t.session_id)) AS "ssid",ap_name AS "ap_name",calling_station_id AS "mac_address",guests.visitor_name AS "visitor_name",guests.visitor_company AS "visitor_company",guests.visitor_carrier AS "visitor_carrier",guests.visitor_phone AS "visitor_phone",guests.sponsor_name AS "sponsor_name",guests.sponsor_email AS "sponsor_email",guests.sponsor_profile_name AS "sponsor_profile_name",guests.role_name AS "role_name" FROM radius_acct t LEFT JOIN nads ON nads.ip = t.nad_ip LEFT JOIN guests ON guests.username = COALESCE(CASE WHEN t.username ~ E\'^(?:(?:[[:xdigit:]]{2}:[[:xdigit:]]{2}:[[:xdigit:]]{2}:[[:xdigit:]]{2}:[[:xdigit:]]{2}:[[:xdigit:]]{2})|(?:[[:xdigit:]]{2}-[[:xdigit:]]{2}-[[:xdigit:]]{2}-[[:xdigit:]]{2}-[[:xdigit:]]{2}-[[:xdigit:]]{2})|(?:[[:xdigit:]]{6}[:-]?[[:xdigit:]]{6})|(?:[[:xdigit:]]{4}\\.[[:xdigit:]]{4}\\.[[:xdigit:]]{4}))$\' THEN REPLACE(UPPER(CAST(CAST(t.username AS MACADDR) AS TEXT)), \':\', \'-\') ELSE NULL END, t.username)::citext WHERE TRUE ORDER BY "iacct_id","icalling_station_id" LIMIT 25 OFFSET 0;',
),-------------------------------------------