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!

APEX 20.1 IG Columns not part of Source go null in DML

TMohammeJul 14 2020 — edited Aug 18 2020

Hi, We are facing a peculiar behaviour in APEX 20.1 Interactive Grid DML process. I have a Grid with SQL: select eno,enmae,mgr from emp;

In the grid, I added an extra column DISPLAY_COLUMN whose source value is SQL Expression set as (ENO||' - '||ENAME) . This Column is not part of Grid Source.

When we update DISPLAY_COLUMN and click on Save (IG Save), :DISPLAY_COLUMN is going as null in Interactive Grid - Automatic Row Processing

Interestingly correct value of DISPLAY_COLUMN is being passed to Interactive Grid validations.

This issue is not seen in v19.1, but only in v20.1 (Oracle APEX)

Could this be a bug? Or Am I doing something wrong?

Thanks in advance
This post has been answered by TMohamme on Aug 18 2020
Jump to Answer

Comments

Hamza Al-abbasi
Answer

Hello Ace1,
Can you give a screen shot?

Marked as Answer by Ace1 · Feb 15 2022
Ace1

Sure,

image.png

1 person found this helpful
Hamza Al-abbasi

What is the problem with zoom out ?

Ace1

Hamza,
Problem with a zoom out occurred with items but it was just a workaround. I'd like to have the IG with feature like I pasted above on the screenshot

Hamza Al-abbasi

IG Cookbook app have an example like that on my workspace :
Workspace: hamzasoft
Username/Password: demo/demo0000
Application 138659 - Page 5

Ace1

It's not a solution, I need to dynamically sum a column inside the IG, not as an item in another region.

Hamza Al-abbasi

This is not a built-in feature, it needs more JS, in this case it will work if your IG pagination is scroll with aggregate. I have an example on my workspace :
Workspace: hamzasoft
Username/Password: demo/demo0000
Application 62472 - Page 17

2 people found this helpful
Ace1

Hamza, thanks a lot! This is exactly what I needed

John Snyders-Oracle

For newer APEX releases take a look at
JSDoc: Interface: model (0 Bytes)properties aggregates.
For example EMP table SAL column add to JS init code:

function(options) {
    options.defaultGridColumnOptions = {
        aggregates: ["SUM"]
    };
    return options;
}

This is much less code than the old way!

4 people found this helpful
Ace1

@john-snyders-oracle thanks a lot! It's working great but I struggle with one thing, how to round values?
image.png

John Snyders-Oracle

I think all you need to do is give the column a format mask. I tried FML999G999G999G999G990D00. This is the declarative option Format Mask for a number column.
One other note for using aggregates option is that the IG must have a primary key defined.

Ace1

@john-snyders-oracle I tried with FML999G999G999G999G990D00 and it's still the same, I have a number column type and a primary key in my IG.

John Snyders-Oracle

Just give the column a format mask.

Mohamed Sameer

@hamza-alabbasi
Do you have a JS function to get a sum of multiple columns in IG

Hamza Al-abbasi

Hi md-sameer,
Please open a new thread and explain your issue.

User187849

hi ,
I have added the same logic in SUM column properties but I couldn't get the total value

function(options) {
    options.defaultGridColumnOptions = {
        aggregates: ["SUM"]
    };
    return options;
}
Robin Biju

Hi John Snyders-Oracle, can this value assign to any page item?
Thanks.

John Snyders-Oracle

@robin-biju When using model field option aggregates the aggregate value cannot be stored directly in an item. There are ways to data out of a model into an item but it can be trickier for aggregate rows. (Model method getAggregateRecord is not documented and not clear how useful it is.)
If you want to save the aggregate value to a page item you can use the method shown in the IG Cookbook page 5.

1 person found this helpful
1 - 18

Post Details

Added on Jul 14 2020
#apex-discussions, #interactive-grid, #oracle
1 comment
376 views