sql - Remove duplicate date in postgres -

-

my need unique value after concatenating 2 string values. below query. strings concatenated duplicated values coming. doing wrong?

select ievent.event_type_id evt_type_id,        ievent.event_value evt_value,        ievent.event_date evt_dt,        ievent.company,        ievent.entity_key,        row_number() on (order ievent.event_date desc) row_num (   select we.executive_id,          we.event_type_id,          sum(we.event_value) event_value,          array_to_string(array_agg(distinct (coalesce(mc.aka_co_name,mc.company_name))),',') company,          we.event_date,          null entity_key   wealth_event we,        master_company mc   mc.company_id = we.company_id     , mc.is_active = 'y'     , (we.event_value > 1 , we.event_value < 5000000000 , we.event_value not null , we.event_type_id in (1, 3, 4, 5))     , we.event_date <= trunc(current_date)     , we.event_date > trunc(current_date) - 180   group we.event_date,            we.executive_id,            we.event_type_id   union   select we.executive_id,          we.event_type_id,          sum(we.event_value) event_value,          array_to_string(array_agg(distinct mc.aka_co_name),',') company,          we.event_date,          we.entity_key   wealth_event we,        master_company mc   mc.company_id = we.company_id     , mc.is_active = 'y'     , (we.event_type_id in (6, 7, 8, 9, 10, 14, 16, 19, 20, 21, 24, 23))     , we.event_date <= trunc(current_date)     , we.event_date > trunc(current_date) - 180   group we.event_date,            we.executive_id,            we.event_type_id,            we.entity_key ) ievent,      executive exec ievent.executive_id = exec.executive_id   , exec.is_active = 'y'   , exec.executive_id = 73685 order row_num

main problem of query using aggregate functions (sum , array_agg) @ subquery without group .

maybe need :

select event_type_id , sum(we.event_value) event_value,   evt_dt, null entity_key,        array_to_string( distinct ( array_agg ( coalesce(mc.aka_co_name, mc.company_name)) ), ',' ) company wealth_event we, master_company mc        mc.company_id = we.company_id        , mc.is_active='y' group event_type_id ,  evt_dt

Comments

Post a Comment

Popular posts from this blog

Ansible - ERROR! the field 'hosts' is required but was not set -

-
i've error when launch playbook don't found why.... error! field 'hosts' required not set there main.yml : --- - hosts: hosts - vars: - elasticsearch_java_home: /usr/lib/jmv/jre-1.7.0 - elasticsearch_http_port: 8443 - tasks: - include: tasks/main.yml - handlers: - include: handlers/main.yml and /etc/ansible/hosts : [hosts] 10.23.108.182 10.23.108.183 10.23.108.184 10.23.108.185 when test ping, : [root@poste08-08-00 elasticsearch]# ansible hosts -m ping 10.23.108.183 | success => { "changed": false, "ping": "pong" } 10.23.108.182 | success => { "changed": false, "ping": "pong" } 10.23.108.185 | success => { "changed": false, "ping": "pong" } 10.23.108.184 | success => { "changed": false, "ping": "pong" } please, me :) regards, you have syntax error in playbook.
Read more

customize file_field button ruby on rails -

-
i'm trying rid of ugly button rails has default file upload. want add glyphicon <%= f.file_field :image_url, class:"glyphicon glyphicon-camera" %> this didn't work , have tried other things in different post saw on page, don't attach file. as suggested here bootstrap filestyle , can use bootstrap's filestyle style file upload buttons. step-1: add layout application.html.erb i have added bootstrap filestyle library cdn. should make sure have both jquery , boostrap loaded. <script type="text/javascript" src="https://cdn.jsdelivr.net/bootstrap.filestyle/1.1.0/js/bootstrap-filestyle.min.js"> </script> step-2: add corresponding js file: $(":file").filestyle({input: false}); step-3: image_url file field follows: <%= f.file_field :image_url,class: "filestyle", "data-input" => false %>
Read more

SoapUI on windows 10 - high DPI/4K scaling issue -

-
Image
soapui doesn't seem dpi-aware , displays small on high dpi screen (tiny text , buttons). other applications running fine (screen resolution 3840 x 2160). version : soapui 5.1.2 os : windows 10 i have tried: configure soapui run "disable display scaling on high dpi settings" - parts of soapui looking bigger , don't display (image) changing resolution changing font size (preferences > editor settings > select font...) therefore assume, soapui pretends dpi-aware, not scale itself. have same issue? this workaround until developers round making version dpi-aware. step 1: add registry key hkey_local_machine\software\microsoft\windows\currentversion\sidebyside\preferexternalmanifest (dword) 1 step 2: add manifest file 'soapui-5.2.1.exe.manifest' in same directory 'soapui-5.2.1.exe' content of manifest file: <?xml version="1.0" encoding="utf-8" standalone="yes"?> <assembly xml
Read more