Skip to Main Content
Forums

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Text in fields disappeared/became invisible when page item in focus/clicked on.

BigalOct 12 2021 — edited Oct 12 2021

APEX vesion 20.2
Chrome version 94.0.4606.81
Using Universal Theme - 42
This issue only happened a week or so ago and only on Modal windows. Upon clicking on a field (e.g. text field or select list), the text becomes invisible. For text fields, you cannot see what you are typing but upon losing focus of the field, the text becomes visible.
This is not happened in Normal Windows, only Modal.
This seems to happen after upgrading to Chrome v94 but cannot be sure if that is the cause.
It is also not happening on all machines with the same version of Chrome. Also, it does not happen on Firefox and IE/MS Edge.
Have anyone encountered this?
This post has been answered by Bigal on Oct 14 2021
Jump to Answer

Comments

fac586 
Nicholas_R wrote:
Hi, I need to set condition for the result of SQL select in APEX.
with report_3 as ( 
 -- First query 
 SELECT r3.codart, SUM(r3.valnet) AS Sum_v1
 FROM mgmv r3
 WHERE (r3.codcma IN ('X ','Y','Z', 'A', 'B') AND r3.codart NOT IN ('110085', '500015','500016') AND r3.codart NOT LIKE 'FOR%' AND r3.codart NOT LIKE 'DEN%' AND r3.datare BETWEEN '01-gen-2018' AND '31-dic-2018')
 OR(r3.codcma IN ('A') AND r3.codcma NOT IN ('B') AND r3.codart NOT IN ('110085', '500015','500016') AND r3.codart LIKE 'FOR%' AND r3.codart LIKE 'DEN%' AND r3.datare BETWEEN '01-gen-2018' AND '31-dic-2018')
 GROUP BY r3.codart
) 
 , report_4 as ( 
 -- Second query
 SELECT r4.codart, SUM(r4.qtamov) AS Sum_qt
 FROM mgmv r4
 WHERE (r4.codcma IN ('X ','Y','Z', 'A', 'B') AND r4.codart NOT IN ('110085', '500015','500016') AND r4.codart NOT LIKE 'FOR%' AND r4.codart NOT LIKE 'DEN%' AND r4.datare BETWEEN '01-gen-2018' AND '31-dic-2018' AND r4.caumov NOT IN ('T', '9'))
 OR(r4.codcma IN ('A') AND r4.codcma NOT IN ('B') AND r4.codart NOT IN ('110085', '500015','500016') AND r4.codart LIKE 'FOR%' AND r4.codart LIKE 'DEN%' AND r4.datare BETWEEN '01-gen-2018' AND '31-dic-2018' AND r4.caumov NOT IN ('T', '9'))
 GROUP BY r4.codart
)
SELECT DISTINCT
 r3.codart
 , Sum_qt
 , Sum_v1
 , TRUNC(case when Sum_qt <> 0 then Sum_v1/Sum_qt+0 end, 5) as Cs_md
 
FROM 
 report_3 r3 
 LEFT OUTER JOIN report_4 r4 ON r3.codart = r4.codart
I need to result FOR1 [...] and DEN1 [...] when they are in A but not in B. But I have the products, with other codes, in A e in B.

Unclear. Please expand and clarify the requirements.

Nicholas_R

with report_3 as (

-- First query

SELECT r3.codart, SUM(r3.valnet) AS Sum_v1

FROM mgmv r3

WHERE (r3.codcma IN ('X ','Y','Z', 'A', 'B') AND r3.codart NOT IN ('110085', '500015','500016') AND r3.codart NOT LIKE 'FOR%' AND r3.codart NOT LIKE 'DEN%' AND r3.datare BETWEEN '01-gen-2018' AND '31-dic-2018')

OR(r3.codcma IN ('A') AND r3.codcma NOT IN ('B') AND r3.codart NOT IN ('110085', '500015','500016') AND r3.codart LIKE 'FOR%' AND r3.codart LIKE 'DEN%' AND r3.datare BETWEEN '01-gen-2018' AND '31-dic-2018')

GROUP BY r3.codart

)

, report_4 as (

-- Second query

SELECT r4.codart, SUM(r4.qtamov) AS Sum_qt

FROM mgmv r4

WHERE (r4.codcma IN ('X ','Y','Z', 'A', 'B') AND r4.codart NOT IN ('110085', '500015','500016') AND r4.codart NOT LIKE 'FOR%' AND r4.codart NOT LIKE 'DEN%' AND r4.datare BETWEEN '01-gen-2018' AND '31-dic-2018' AND r4.caumov NOT IN ('T', '9'))

OR(r4.codcma IN ('A') AND r4.codcma NOT IN ('B') AND r4.codart NOT IN ('110085', '500015','500016') AND r4.codart LIKE 'FOR%' AND r4.codart LIKE 'DEN%' AND r4.datare BETWEEN '01-gen-2018' AND '31-dic-2018' AND r4.caumov NOT IN ('T', '9'))

GROUP BY r4.codart

)

SELECT DISTINCT

r3.codart

, Sum_qt

, Sum_v1

, TRUNC(case when Sum_qt <> 0 then Sum_v1/Sum_qt+0 end, 5) as Cs_md

FROM

report_3 r3

LEFT OUTER JOIN report_4 r4 ON r3.codart = r4.codart

Jorgelina1

Hi...

I do not think that what is clear, is are you expecting to get from your queries.

I think that a possible "resulset" from your 1st query, and 2nd query... and what would you like to achieve as the end result would be a lot better so we understand what the requirement is...

Regards.

1 - 3

Post Details

Added on Oct 12 2021
#apex, #apex-discussions, #apex20-2
45 comments
12,892 views
4 mentions