server/config/seedDB/report/default.js

   1 'use strict';
   2
   3 module.exports = function(prefix) {
   4     return [{
   5         id: 1,
   6         name: 'Details',
   7         description: 'Detailed queues report',
   8         parent: prefix + '_voice_queues',
   9         table: 'report_queue',
  10         conditions: '{"group":{"operator":"AND","rules":[]}}'
  11     }, {
  12         id: 2,
  13         name: 'Calls Result',
  14         description: 'Simple queue calls overview',
  15         parent: prefix + '_voice_queues',
  16         table: 'report_queue',
  17         conditions: '{"group":{"operator":"AND","rules":[]}}'
  18     }, {
  19         id: 3,
  20         name: 'Details',
  21         description: 'Detailed report about answered queue calls',
  22         parent: prefix + '_voice_queues_answered',
  23         table: 'report_agent',
  24         conditions: '{"group":{"operator":"AND","rules":[{"condition":"=","field":"agentcomplete","value":"1","required":true}]}}'
  25     }, {
  26         id: 4,
  27         name: 'Calls by Agent',
  28         description: 'Agent calls timer Handle time= talk time + ACW time',
  29         parent: prefix + '_voice_queues_answered',
  30         table: 'report_agent',
  31         conditions: '{"group":{"operator":"AND","rules":[{"condition":"=","field":"agentcomplete","value":"1","required":true}]}}'
  32     }, {
  33         id: 5,
  34         name: 'Calls by Queue',
  35         description: 'Queue timer Handle Time= Talk Time + AVG TIme',
  36         parent: prefix + '_voice_queues_answered',
  37         table: 'report_agent',
  38         conditions: '{"group":{"operator":"AND","rules":[{"condition":"=","field":"agentcomplete","value":"1","required":true}]}}'
  39     }, {
  40         id: 6,
  41         name: 'Answer Time by Queue',
  42         description: 'Queues answer time performance',
  43         parent: prefix + '_voice_queues_answered',
  44         table: 'report_agent',
  45         conditions: '{"group":{"operator":"AND","rules":[{"condition":"=","field":"agentcomplete","value":"1","required":true}]}}'
  46     }, {
  47         id: 7,
  48         name: 'Disconnection Cause',
  49         description: 'Summary of the calls disconnection causes',
  50         parent: prefix + '_voice_queues_answered',
  51         table: 'report_agent',
  52         conditions: '{"group":{"operator":"AND","rules":[{"condition":"=","field":"agentcomplete","value":"1","required":true}]}}'
  53     }, {
  54         id: 8,
  55         name: 'Answer Time by Hour',
  56         description: 'Answer time  by hour',
  57         parent: prefix + '_voice_queues_answered',
  58         table: 'report_agent',
  59         conditions: '{"group":{"operator":"AND","rules":[{"condition":"=","field":"agentcomplete","value":"1","required":true}]}}'
  60     }, {
  61         id: 9,
  62         name: 'Details',
  63         description: 'Detailed report about the unanswered calls',
  64         parent: prefix + '_voice_queues_unanswered',
  65         table: 'report_queue',
  66         conditions: '{"group":{"operator":"AND","rules":[{"condition":"=","field":"queuecallercomplete","value":"0","required":true}]}}'
  67     }, {
  68         id: 10,
  69         name: 'Unanswered by Queue',
  70         description: 'Unanswered calls summary by queue',
  71         parent: prefix + '_voice_queues_unanswered',
  72         table: 'report_queue',
  73         conditions: '{"group":{"operator":"AND","rules":[{"condition":"=","field":"queuecallercomplete","value":"0","required":true}]}}'
  74     }, {
  75         id: 11,
  76         name: 'Unmanaged calls',
  77         description: 'Unmanaged calls summary',
  78         parent: prefix + '_voice_queues_unanswered',
  79         table: 'report_queue',
  80         conditions: '{"group":{"operator":"AND","rules":[{"condition":"=","field":"queuecallerexit","value":"1","required":true}]}}'
  81     }, {
  82         id: 12,
  83         name: 'Abandon Time by Queue',
  84         description: 'Abandon time performance by queue',
  85         parent: prefix + '_voice_queues_unanswered',
  86         table: 'report_queue',
  87         conditions: '{"group":{"operator":"AND","rules":[{"condition":"=","field":"queuecallerabandon","value":"1","required":true}]}}'
  88     }, {
  89         id: 13,
  90         name: 'Calls by Date',
  91         description: 'Queue calls summary by date',
  92         parent: prefix + '_voice_queues_distribution',
  93         table: 'report_queue',
  94         conditions: '{"group":{"operator":"AND","rules":[]}}'
  95     }, {
  96         id: 14,
  97         name: 'Calls by Hour',
  98         description: 'Calls distribution by hour',
  99         parent: prefix + '_voice_queues_distribution',
 100         table: 'report_queue',
 101         conditions: '{"group":{"operator":"AND","rules":[]}}'
 102     }, {
 103         id: 15,
 104         name: 'Calls by Day',
 105         description: 'Calls distribution by day of the month',
 106         parent: prefix + '_voice_queues_distribution',
 107         table: 'report_queue',
 108         conditions: '{"group":{"operator":"AND","rules":[]}}'
 109     }, {
 110         id: 16,
 111         name: 'Calls by Weekday',
 112         description: 'Calls distribution by day of the week',
 113         parent: prefix + '_voice_queues_distribution',
 114         table: 'report_queue',
 115         conditions: '{"group":{"operator":"AND","rules":[]}}'
 116     }, {
 117         id: 17,
 118         name: 'Summary',
 119         description: 'Calls distribution by queue',
 120         parent: prefix + '_voice_queues',
 121         table: 'report_queue',
 122         conditions: '{"group":{"operator":"AND","rules":[]}}'
 123     }, {
 124         id: 18,
 125         name: 'Details',
 126         description: 'Calls detail (cdr)',
 127         parent: prefix + '_voice_calls',
 128         table: 'report_call',
 129         conditions: '{"group":{"operator":"AND","rules":[]}}'
 130     }, {
 131         id: 19,
 132         name: 'Outbound',
 133         description: 'Manual outbound calls detailed report',
 134         parent: prefix + '_voice_calls',
 135         table: 'report_call',
 136         conditions: '{"group":{"operator":"AND","rules":[{"condition":"=","field":"type","value":"\'outbound\'","required":true}]}}'
 137     }, {
 138         id: 20,
 139         name: 'Calls by Type',
 140         description: 'Summary report of the calls type',
 141         parent: prefix + '_voice_calls',
 142         table: 'report_call',
 143         conditions: '{"group":{"operator":"AND","rules":[]}}'
 144     }, {
 145         id: 21,
 146         name: 'Outbound Calls Disposition',
 147         description: 'Outbound calls grouped by disposition',
 148         parent: prefix + '_voice_calls',
 149         table: 'report_call',
 150         conditions: '{"group":{"operator":"AND","rules":[{"condition":"=","field":"type","value":"\'outbound\'","required":true}]}}'
 151     }, {
 152         id: 22,
 153         name: 'Outbound Calls by Agent',
 154         description: 'Summary of outbound calls grouped by agent',
 155         parent: prefix + '_voice_calls',
 156         table: 'report_call',
 157         conditions: '{"group":{"operator":"AND","rules":[{"condition":"=","field":"type","value":"\'outbound\'","required":true}]}}'
 158     }, {
 159         id: 23,
 160         name: 'Outbound Calls by Date',
 161         description: 'Summary of outbound calls grouped by date',
 162         parent: prefix + '_voice_calls',
 163         table: 'report_call',
 164         conditions: '{"group":{"operator":"AND","rules":[{"condition":"=","field":"type","value":"\'outbound\'","required":true}]}}'
 165     }, {
 166         id: 24,
 167         name: 'Login Time',
 168         description: 'Agent\'s login time',
 169         parent: prefix + '_agents',
 170         table: 'report_member',
 171         conditions: '{"group":{"operator":"AND","rules":[{"condition":"=","field":"type","value":"\'LOGIN\'","required":true},{"condition":"=","field":"channel","value":"\'voice\'","required":true}]}}'
 172     }, {
 173         id: 25,
 174         name: 'Activities Summary',
 175         description: 'Agent\'s activities report',
 176         parent: prefix + '_voice_agents',
 177         table: 'report_member',
 178         conditions: '{"group":{"operator":"AND","rules":[{"condition":"=","field":"channel","value":"\'voice\'","required":true}]}}'
 179     }, {
 180         id: 26,
 181         name: 'Pause Details',
 182         description: 'Agents status details',
 183         parent: prefix + '_voice_agents',
 184         table: 'report_member',
 185         conditions: '{"group":{"operator":"AND","rules":[{"condition":"=","field":"channel","value":"\'voice\'","required":true},{"condition":"=","field":"type","value":"\'PAUSE\'","required":true}]}}'
 186     }, {
 187         id: 27,
 188         name: 'Details',
 189         description: 'Agent\'s status detail',
 190         parent: prefix + '_voice_agents',
 191         table: 'report_member',
 192         conditions: '{"group":{"operator":"AND","rules":[{"condition":"=","field":"channel","value":"\'voice\'","required":true}]}}'
 193     }, {
 194         id: 28,
 195         name: 'Pause Time',
 196         description: 'Agent\'s pause time',
 197         parent: prefix + '_voice_agents',
 198         table: 'report_member',
 199         conditions: '{"group":{"operator":"AND","rules":[{"condition":"=","field":"type","value":"\'PAUSE\'","required":true},{"condition":"=","field":"channel","value":"\'voice\'","required":true}]}}'
 200     }, {
 201         id: 29,
 202         name: 'Summary',
 203         description: 'CallySquare Summary',
 204         parent: prefix + '_voice_callysquare',
 205         table: 'report_square',
 206         conditions: '{"group":{"operator":"AND","rules":[]}}'
 207     }, {
 208         id: 30,
 209         name: 'Blocks',
 210         description: 'CallySquare Blocks Detail',
 211         parent: prefix + '_voice_callysquare',
 212         table: 'report_square_details',
 213         conditions: '{"group":{"operator":"AND","rules":[]}}'
 214     }, {
 215         id: 31,
 216         name: 'Rating by Agent',
 217         description: 'Records rating by agent',
 218         parent: prefix + '_voice_recordings',
 219         table: 'voice_recordings',
 220         conditions: '{"group":{"operator":"AND","rules":[{"condition":">","field":"rating","value":"0","required":true}]}}'
 221     }, {
 222         id: 32,
 223         name: 'Rating by Queue',
 224         description: 'Records rating by queue',
 225         parent: prefix + '_voice_recordings',
 226         table: 'voice_recordings',
 227         conditions: '{"group":{"operator":"AND","rules":[{"condition":"IS NOT NULL","field":"queue","value":"","required":false},{"condition":">","field":"rating","value":"0","required":true}]}}'
 228     }, {
 229         id: 33,
 230         name: 'Details',
 231         description: '',
 232         parent: prefix + '_bull_queue_campaigns',
 233         table: 'cm_hopper_final',
 234         conditions: '{"group":{"operator":"AND","rules":[{"condition":"=","field":"campaigntype","value":"\'queue\'"}]}}'
 235     }, {
 236         id: 34,
 237         name: 'Calls Summary',
 238         description: '',
 239         parent: prefix + '_bull_queue_campaigns',
 240         table: 'cm_hopper_history',
 241         conditions: '{"group":{"operator":"AND","rules":[{"condition":"=","field":"campaigntype","value":"\'queue\'"}]}}'
 242     }, {
 243         id: 35,
 244         name: 'Campaign Calls',
 245         description: '',
 246         parent: prefix + '_bull_queue_campaigns',
 247         table: 'cm_hopper_final',
 248         conditions: '{"group":{"operator":"AND","rules":[{"condition":"=","field":"campaigntype","value":"\'queue\'"}]}}'
 249     }, {
 250         id: 36,
 251         name: 'List Penetration Rate',
 252         description: '',
 253         parent: prefix + '_bull_queue_campaigns',
 254         table: 'cm_hopper_final',
 255         conditions: '{"group":{"operator":"AND","rules":[{"condition":"=","field":"campaigntype","value":"\'queue\'"}]}}'
 256     }, {
 257         id: 37,
 258         name: 'Agent Calls',
 259         description: '',
 260         parent: prefix + '_bull_queue_campaigns',
 261         table: 'cm_hopper_final',
 262         conditions: '{"group":{"operator":"AND","rules":[{"condition":"=","field":"campaigntype","value":"\'queue\'"},{"condition":"=","field":"state","value":"4"}]}}'
 263     }, {
 264         id: 38,
 265         name: 'Disposition Rate',
 266         description: '',
 267         parent: prefix + '_bull_queue_campaigns',
 268         table: 'cm_hopper_final',
 269         conditions: '{"group":{"operator":"AND","rules":[{"condition":"=","field":"campaigntype","value":"\'queue\'"},{"condition":"IS NOT NULL","field":"disposition","value":""},{"condition":"=","field":"state","value":"4"}]}}'
 270     }, {
 271         id: 39,
 272         name: 'Agent Disposition Rate',
 273         description: '',
 274         parent: prefix + '_bull_queue_campaigns',
 275         table: 'cm_hopper_final',
 276         conditions: '{"group":{"operator":"AND","rules":[{"condition":"=","field":"campaigntype","value":"\'queue\'"},{"condition":"IS NOT NULL","field":"disposition","value":""},{"condition":"=","field":"state","value":"4"}]}}'
 277     }, {
 278         id: 40,
 279         name: 'Details',
 280         description: '',
 281         parent: prefix + '_bull_ivr_campaigns',
 282         table: 'cm_hopper_final',
 283         conditions: '{"group":{"operator":"AND","rules":[{"condition":"=","field":"campaigntype","value":"\'ivr\'"}]}}'
 284     }, {
 285         id: 41,
 286         name: 'Calls Summary',
 287         description: '',
 288         parent: prefix + '_bull_ivr_campaigns',
 289         table: 'cm_hopper_history',
 290         conditions: '{"group":{"operator":"AND","rules":[{"condition":"=","field":"campaigntype","value":"\'ivr\'"}]}}'
 291     }, {
 292         id: 42,
 293         name: 'Campaign Calls',
 294         description: '',
 295         parent: prefix + '_bull_ivr_campaigns',
 296         table: 'cm_hopper_final',
 297         conditions: '{"group":{"operator":"AND","rules":[{"condition":"=","field":"campaigntype","value":"\'ivr\'"}]}}'
 298     }, {
 299         id: 43,
 300         name: 'List Penetration Rate',
 301         description: '',
 302         parent: prefix + '_bull_ivr_campaigns',
 303         table: 'cm_hopper_final',
 304         conditions: '{"group":{"operator":"AND","rules":[{"condition":"=","field":"campaigntype","value":"\'ivr\'"}]}}'
 305     }, {
 306         id: 44,
 307         name: 'Website Summary',
 308         description: 'Chat interactions by website',
 309         parent: prefix + '_chat',
 310         table: 'chat_interactions',
 311         joins: '[{"parentKey":"ChatWebsiteId","foreignTable":"chat_websites","foreignKey":"id","type":"join"}]'
 312     }, {
 313         id: 45,
 314         name: 'Website Times',
 315         description: 'Chat interaction times by website',
 316         parent: prefix + '_chat',
 317         table: 'chat_interactions',
 318         conditions: '{"group":{"operator":"AND","rules":[{"condition":"=","field":"chat_interactions.closed","value":"1"},{"group":{"operator":"OR","rules":[{"condition":"IS NULL","field":"chat_interactions.disposition","value":""},{"group":{"operator":"AND","rules":[{"condition":"!=","field":"chat_interactions.disposition","value":"\'abandoned\'"},{"condition":"!=","field":"chat_interactions.disposition","value":"\'unmanaged\'"}]}}]}}]}}',
 319         joins: '[{"parentKey":"ChatWebsiteId","foreignTable":"chat_websites","foreignKey":"id","type":"join"}]'
 320     }, {
 321         id: 46,
 322         name: 'Chat By Agent',
 323         description: 'Chat interactions by agent',
 324         parent: prefix + '_chat',
 325         table: 'chat_interactions',
 326         conditions: '{"group":{"operator":"AND","rules":[{"condition":"=","field":"chat_interactions.closed","value":"1"}]}}',
 327         joins: '[{"parentKey":"UserId","foreignTable":"users","foreignKey":"id","type":"join"}]'
 328     }, {
 329         id: 47,
 330         name: 'Chat By Date',
 331         description: 'Chat interactions by date',
 332         parent: prefix + '_chat',
 333         table: 'chat_interactions',
 334         conditions: '{"group":{"operator":"AND","rules":[{"condition":"=","field":"chat_interactions.closed","value":"1"}]}}'
 335     }, {
 336         id: 48,
 337         name: 'Chat By Queue',
 338         description: 'Chat interactions by queue',
 339         parent: prefix + '_chat',
 340         table: 'report_chat_queue',
 341         joins: '[{"parentKey":"ChatQueueId","foreignTable":"chat_queues","foreignKey":"id","type":"join"}]'
 342     }, {
 343         id: 49,
 344         name: 'Email Account Summary',
 345         description: 'Email interactions by account',
 346         parent: prefix + '_mail',
 347         table: 'mail_interactions',
 348         joins: '[{"parentKey":"MailAccountId","foreignTable":"mail_accounts","foreignKey":"id","type":"join"}]'
 349     }, {
 350         id: 50,
 351         name: 'Email Account Times',
 352         description: 'Email interaction times by account',
 353         parent: prefix + '_mail',
 354         table: 'mail_interactions',
 355         conditions: '{"group":{"operator":"AND","rules":[{"condition":"=","field":"mail_interactions.closed","value":"1"},{"group":{"operator":"OR","rules":[{"condition":"!=","field":"mail_interactions.disposition","value":"\'unmanaged\'"},{"condition":"IS NULL","field":"mail_interactions.disposition","value":""}]}}]}}',
 356         joins: '[{"parentKey":"MailAccountId","foreignTable":"mail_accounts","foreignKey":"id","type":"join"}]'
 357     }, {
 358         id: 51,
 359         name: 'Email By Agent',
 360         description: 'Email interactions by agent',
 361         parent: prefix + '_mail',
 362         table: 'mail_interactions',
 363         conditions: '{"group":{"operator":"AND","rules":[{"condition":"=","field":"mail_interactions.closed","value":"1"}]}}',
 364         joins: '[{"parentKey":"UserId","foreignTable":"users","foreignKey":"id","type":"join"}]'
 365     }, {
 366         id: 52,
 367         name: 'Email By Date',
 368         description: 'Email interactions by date',
 369         parent: prefix + '_mail',
 370         table: 'mail_interactions',
 371         conditions: '{"group":{"operator":"AND","rules":[{"condition":"=","field":"mail_interactions.closed","value":"1"}]}}'
 372     }, {
 373         id: 53,
 374         name: 'Email By Queue',
 375         description: 'Email interactions by queue',
 376         parent: prefix + '_mail',
 377         table: 'report_mail_queue',
 378         joins: '[{"parentKey":"MailQueueId","foreignTable":"mail_queues","foreignKey":"id","type":"join"}]'
 379     }, {
 380         id: 54,
 381         name: 'Openchannel Account Summary',
 382         description: 'Openchannel interactions by account',
 383         parent: prefix + '_openchannel',
 384         table: 'openchannel_interactions',
 385         joins: '[{"parentKey":"OpenchannelAccountId","foreignTable":"openchannel_accounts","foreignKey":"id","type":"join"}]'
 386     }, {
 387         id: 55,
 388         name: 'Openchannel Account Times',
 389         description: 'Openchannel interaction times by account',
 390         parent: prefix + '_openchannel',
 391         table: 'openchannel_interactions',
 392         conditions: '{"group":{"operator":"AND","rules":[{"condition":"=","field":"openchannel_interactions.closed","value":"1"},{"group":{"operator":"OR","rules":[{"condition":"!=","field":"openchannel_interactions.disposition","value":"\'unmanaged\'"},{"condition":"IS NULL","field":"openchannel_interactions.disposition","value":""}]}}]}}',
 393         joins: '[{"parentKey":"OpenchannelAccountId","foreignTable":"openchannel_accounts","foreignKey":"id","type":"join"}]'
 394     }, {
 395         id: 56,
 396         name: 'Openchannel By Agent',
 397         description: 'Openchannel interactions by agent',
 398         parent: prefix + '_openchannel',
 399         table: 'openchannel_interactions',
 400         conditions: '{"group":{"operator":"AND","rules":[{"condition":"=","field":"openchannel_interactions.closed","value":"1"}]}}',
 401         joins: '[{"parentKey":"UserId","foreignTable":"users","foreignKey":"id","type":"join"}]'
 402     }, {
 403         id: 57,
 404         name: 'Openchannel By Date',
 405         description: 'Openchannel interactions by date',
 406         parent: prefix + '_openchannel',
 407         table: 'openchannel_interactions',
 408         conditions: '{"group":{"operator":"AND","rules":[{"condition":"=","field":"openchannel_interactions.closed","value":"1"}]}}'
 409     }, {
 410         id: 58,
 411         name: 'Openchannel By Queue',
 412         description: 'Openchannel interactions by queue',
 413         parent: prefix + '_openchannel',
 414         table: 'report_openchannel_queue',
 415         joins: '[{"parentKey":"OpenchannelQueueId","foreignTable":"openchannel_queues","foreignKey":"id","type":"join"}]'
 416     }, {
 417         id: 59,
 418         name: 'Sms Account Summary',
 419         description: 'Sms interactions by account',
 420         parent: prefix + '_sms',
 421         table: 'sms_interactions',
 422         joins: '[{"parentKey":"SmsAccountId","foreignTable":"sms_accounts","foreignKey":"id","type":"join"}]'
 423     }, {
 424         id: 60,
 425         name: 'Sms Account Times',
 426         description: 'Sms interaction times by account',
 427         parent: prefix + '_sms',
 428         table: 'sms_interactions',
 429         conditions: '{"group":{"operator":"AND","rules":[{"condition":"=","field":"sms_interactions.closed","value":"1"},{"group":{"operator":"OR","rules":[{"condition":"!=","field":"sms_interactions.disposition","value":"\'unmanaged\'"},{"condition":"IS NULL","field":"sms_interactions.disposition","value":""}]}}]}}',
 430         joins: '[{"parentKey":"SmsAccountId","foreignTable":"sms_accounts","foreignKey":"id","type":"join"}]'
 431     }, {
 432         id: 61,
 433         name: 'Sms By Agent',
 434         description: 'Sms interactions by agent',
 435         parent: prefix + '_sms',
 436         table: 'sms_interactions',
 437         conditions: '{"group":{"operator":"AND","rules":[{"condition":"=","field":"sms_interactions.closed","value":"1"}]}}',
 438         joins: '[{"parentKey":"UserId","foreignTable":"users","foreignKey":"id","type":"join"}]'
 439     }, {
 440         id: 62,
 441         name: 'Sms By Date',
 442         description: 'Sms interactions by date',
 443         parent: prefix + '_sms',
 444         table: 'sms_interactions',
 445         conditions: '{"group":{"operator":"AND","rules":[{"condition":"=","field":"sms_interactions.closed","value":"1"}]}}'
 446     }, {
 447         id: 63,
 448         name: 'Sms By Queue',
 449         description: 'Sms interactions by queue',
 450         parent: prefix + '_sms',
 451         table: 'report_sms_queue',
 452         joins: '[{"parentKey":"SmsQueueId","foreignTable":"sms_queues","foreignKey":"id","type":"join"}]'
 453     }, {
 454         id: 64,
 455         name: 'Fax Account Summary',
 456         description: 'Fax interactions by account',
 457         parent: prefix + '_fax',
 458         table: 'fax_interactions',
 459         joins: '[{"parentKey":"FaxAccountId","foreignTable":"fax_accounts","foreignKey":"id","type":"join"}]'
 460     }, {
 461         id: 65,
 462         name: 'Fax Account Times',
 463         description: 'Fax interaction times by account',
 464         parent: prefix + '_fax',
 465         table: 'fax_interactions',
 466         conditions: '{"group":{"operator":"AND","rules":[{"condition":"=","field":"fax_interactions.closed","value":"1"},{"group":{"operator":"OR","rules":[{"condition":"!=","field":"fax_interactions.disposition","value":"\'unmanaged\'"},{"condition":"IS NULL","field":"fax_interactions.disposition","value":""}]}}]}}',
 467         joins: '[{"parentKey":"FaxAccountId","foreignTable":"fax_accounts","foreignKey":"id","type":"join"}]'
 468     }, {
 469         id: 66,
 470         name: 'Fax By Agent',
 471         description: 'Fax interactions by agent',
 472         parent: prefix + '_fax',
 473         table: 'fax_interactions',
 474         conditions: '{"group":{"operator":"AND","rules":[{"condition":"=","field":"fax_interactions.closed","value":"1"}]}}',
 475         joins: '[{"parentKey":"UserId","foreignTable":"users","foreignKey":"id","type":"join"}]'
 476     }, {
 477         id: 67,
 478         name: 'Fax By Date',
 479         description: 'Fax interactions by date',
 480         parent: prefix + '_fax',
 481         table: 'fax_interactions',
 482         conditions: '{"group":{"operator":"AND","rules":[{"condition":"=","field":"fax_interactions.closed","value":"1"}]}}'
 483     }, {
 484         id: 68,
 485         name: 'Fax By Queue',
 486         description: 'Fax interactions by queue',
 487         parent: prefix + '_fax',
 488         table: 'report_fax_queue',
 489         joins: '[{"parentKey":"FaxQueueId","foreignTable":"fax_queues","foreignKey":"id","type":"join"}]'
 490     }];
 491 };