Uilson Claudio Filho

Galera tenho essa query select * from ( SELECT ROW_NUMBER() OVER( ORDER BY i.id DESC ) as row_num, p.pkey || '-' || i.issuenum as Chave_Issue, i.ISSUENUM Num_Issue, i.CREATED as Issue_CREATED, i.SUMMARY, dbms_lob.substr(i.DESCRIPTION,4000,1) DESCRIPTION, i.PRIORITY, s.pname Status_Atual, s.SEQUENCE, i.UPDATED, i.DUEDATE, (SELECT RS.PNAME FROM RESOLUTION RS WHERE RS.ID = i.RESOLUTION) AS PNAME_RESOLUTION, i.RESOLUTIONDATE, i.TIMESPENT, i.WORKFLOW_ID, i.COMPONENT, p.PNAME, ci.GROUPID, CAST(ci.OLDSTRING as varchar(100)) status_antigo, CAST(ci.NEWSTRING AS varchar(100)) status_novo, cg.CREATED Data_Status, (SELECT iss.PNAME FROM issuetype iss WHERE iss.ID = i.issuetype) AS Issue_Type, cg.author, --cwd.user_name, --cwd.Display_name, --cwd.email_address, --CAST(te.TITLE as varchar(200)) title_team, (SELECT NUMBERVALUE FROM CUSTOMFIELDVALUE cfv WHERE CUSTOMFIELD in (select CF.id from customfield CF where CF.CFNAME = 'Size (PFS)') AND cfv.issue = I.ID) AS PFS --(SELECT round(sum(wl.timeworked) /60. /60.,2) FROM worklog wl WHERE wl.author = ui.USER_KEY) as Horas_Apontadas FROM changeitem ci inner join changegroup cg on ci.groupid = cg.id AND ci.FIELDTYPE='jira' AND ci.FIELD='status' inner join jiraissue i on cg.issueid = i.id and i.issuetype in (SELECT id FROM ISSUETYPE WHERE pname IN ('Defect','Epic','Improvement', 'New Feature','Non Functional','Story')) and i.RESOLUTIONDATE is not NULL inner join project p on i.project = p.id inner join issuestatus s on s.id = i.issuestatus inner JOIN APP_USER app ON app.user_key = cg.author WHERE i.CREATED >= to_date('2023-01-01', 'YYYY-MM-DD') ORDER BY i.ISSUENUM,cg.CREATED ) where row_num BETWEEN 1 and 1000 Porem quando coloco esse join a mais ele duplica os registros: inner JOIN AO_AEFED0_USER_INDEX ui ON ui.user_key = app.user_key Como posso resolver isso, pois preciso que esse join seja executado junto a query Obrigado

Galera tenho uma lista assim: Ação Valor investido Valor Ação Qtde Ações Valor pago ano Valor pago mês 0 TAEE11F 25000 35.82 697.934115 34 2.833333 1 AGRO3F 0 24.45 0.000000 98 8.166667 2 BBAS3F 25000 37.39 668.627975 78 6.500000 3 BBSE3F 25000 32.15 777.604977 78 6.500000 4 SANB11F 4500 25.82 174.283501 23 1.916667 Mas preciso transformar ela em um dicionário de dados, desse forma: exemplo = { 'Açao': TAEE11F 'Valor investido':25000 'Valor Ação':35.82 'Qtde Ações': 697.934115 'Valor pago ano': 34 'Valor pago mês': 2.833333 } Como posso fazer isso ? Obrigado

Galera preciso fazer esse layout em html com css: Como posso fazer isso ? Obrigado