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 5.1.1 IG - how to set value of a hidden column

Marko GorickiApr 12 2017 — edited Oct 13 2017

Hi,

can anybody give me a clue how to set value of a hidden column in Interactive Grid.

I have a sample here.

There's a button "Set salary to 1000 of selected emp" on this page that executes the following JS code:

var g = apex.region('rgnEmp').widget().interactiveGrid('getViews','grid');
var r = g.getSelectedRecords()[0];
g.model.setValue(r, 'SAL', 1000);

https://apex.oracle.com/pls/apex/f?p=103570:4:Column SAL is defined as hidden and not protected.

The error that I see in console is:

Uncaught Error: Set value not allowed for field.

Tested on apex.oracle.com (version5.1.1.00.08).

Thanks in advance!

Br,

Marko

Comments

BalaGuddeti-Oracle

In the earlier post, you have set the Maximum recipients to 100, hence Email server control mechanism is activated to control spam emails. if you expect 500 emails, change the Maximum number of recipients to 500

Gianni Ceresa

4.3.2 The maximum number of concurrent server connections has exceeded a per-source limit, closing transmission channel
This is not an OBIEE/OAS error message, the issue is not here, you are looking in the wrong place....
This is a mail server error message.
You should speak to your mail server administrators giving them that error and explaining what you were (or what the tool was doing on your behalf) when the error appears in the logs.
Do not touch the maximum recipients number, leave it to 0 as Joel said in the other thread: 0 means unlimited. That setting is used more for other reasons, like when you want to avoid somebody setup an agent spamming your entire company sending an agent delivery to 1000+ people, it's a way to limit the freedom of people creating agents based on company's rules.
Your issue is that OBIEE/OAS is sending the emails in a way that is outside the limits of the mail server, not on the OBIEE/OAS side, but on the mail server side.
Speak your mail server administrators, also telling them you don't really have options to slow down the sending process on the OBIEE/OAS side.
Maybe they will ask you to send these emails in batches, and for that you will need some creativity (like using 2 agents running at separate times doing each half the list of emails).

1 - 2
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Nov 10 2017
Added on Apr 12 2017
#apex-discussions, #interactive-grid
11 comments
21,516 views