Skip to Main Content

Java Development Tools

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

SelectBooleanCheckbox Curiosity

ChristianM0147Jan 25 2024 — edited Jan 25 2024

Hello fellow Developers.

Im currently working on JDEV Version 12.2.1.4.0

So i got a Entity Object and a corresponding ViewObject and created a Table with the DataControls with it.

I got one transient column AdisVorhanden2 (Boolean) that is based on a SQL Query that checks if i got some Data in a specific table (1/0).

SELECT
  CASE
    WHEN EXISTS (
    	select 
        	1
        from
            table
    )
    THEN 1
    ELSE 0
  END AS result
FROM DUAL

I want to show the data with a readOnly selectBooleanChechbox but somehow, the data gets inverted. I want 1 as checked and 0 as unchecked.

The Last column shows the right results (dropped as readOnly Column) , but if i drop the column as selectBooleanCheckbox (the column before last) the data gets inverted. I used those identifiers:

Does anybody got an idea what is wrong?

Comments
Post Details
Added on Jan 25 2024
2 comments
106 views