Stack Overflow
Stack Overflow

Questions tagged [interactive-grid]

Use this tag for questions related with Oracle APEX Interactive Grid

An interactive grid presents users a set of data in a searchable, customizable report. In an editable interactive grid, users can also add to, modify, and delete the data set directly on the page.

49 questions
3
votes
1 answer

Remove actions from the Interactive Grid "Row Action" button - Oracle Apex v21.1

I would like to remove the Single Row View action on the "Row Actions" button on the Interactive Grid : Also, I would like to remove these following actions on the row actions menu aswell, because these have no translations available based on the…
ThomasT
  • 336
  • 4
  • 25
2
votes
3 answers

Oracle Apex Reports causing performance issue

I'm creating an Interactive Grid report. I've a very complex sql query. It has 3 portions of SQL query and the syntax is like below. WITH QUERY1 AS -- QUER1 -- QUERY2 AS -- QUER1 -- QUERY3 AS -- QUER1 -- SELECT -- COLUMNS…
Anand Jagtap
  • 113
  • 1
  • 9
1
vote
1 answer

Refresh the page item after saving the Interactive grid

After saving the Interactive grid, I need to Refresh the page item (Display only). How to achieve this
shajin
  • 29
  • 4
1
vote
1 answer

Oracle Apex Column fix and Column Header sortable at the same time

I have the following problem: my requirement is that a column in Oracle APEX Interactive Grid should be fixed (i.e. the user must not be able to move it) but at the same time the sorting function must be available in the header column. I've…
Veli
  • 11
  • 1
1
vote
0 answers

Oracle Apex - Non Selected Row

I need help to how can i make action process on oracle apex interactive grid on non selected row. I need 2 action if row selected then do process . If row not selected then do another process .
user20983281
  • 11
  • 2
1
vote
1 answer

How to link a button to select specific rows from the table in Apex

I have the following table with checkbox in my page: Region type: Interactive grid Checkbox generated by row selector ColumnA ColumnB ColumnC 1 Hello 123 2 Position 1234 3 Accept 567 4 Position 778 5 Accept 321 I have created…
Itsme mylife
  • 11
  • 4
1
vote
1 answer

Interactive Grid in oracle apex

How can I handle insert update in Oracle Apex interactive grid with more than one table which is attached with inner join. If anyone have solution please reply.
Lucky Tune
  • 21
  • 3
1
vote
1 answer

How to get column values dynamically in Oracle Apex Interactive Grid

I want to concatenate a static sql statement with a dynamic string represent for some of dynamic column which have defined by another sql statement like this select column1, column2, '|| v_select ||' from my_table. v_select have example value like…
Thuan Le
  • 11
  • 6
1
vote
1 answer

Enable disable records for each row in Interactive report oracle

I have a interactive grid and one item p11_active_yn , based on the item value i want to check this condition for each row , in one grid we may have so many records, the enable disable should check and do for each row in interactive grid,, how to…
Abinnaya
  • 203
  • 4
  • 26
1
vote
1 answer

Apex 21.2: anybody faced this type of problem and resolved?

I created a page using editable IG where i have a dummy column of Type: Diaplay Only using it as a HTML Button to open a Modal Dialog (Master-Detail Form) which contains some data for DML operation. I am passing a page item as parameter to Update…
Ahmed Haroon
  • 69
  • 1
  • 12
1
vote
1 answer

Interactive Grid column with "Function body returning PL/SQL" gives errors referencing columns (bug?)

Lets suppose I have a table with 2 columns (A and B). One of these columns (A) will define the LOV of the other (B). I have an IG with column B set to "Popup LOV" and the list of values being "Function body returning PL/SQL". I have put this demo…
Gerard Otín
  • 21
  • 3
1
vote
1 answer

Oracle Apex Select List LOV conditional query

I have an Editable Interactive Grid (for product_sale table) with a Select List (to select a product) in Oracle Apex 20.2 app. Currently I'm using below query to populate this list of values. SELECT productName,productId FROM product WHERE…
Bishan
  • 15,211
  • 52
  • 164
  • 258
0
votes
0 answers

Oracle APEX - ORA-01722: invalid number when saving Interactive report/Interactive grid

While trying to create new Interactive Grids or Interactive Reports in APEX applications, everything works as expected until the SAVE button is clicked and the following error message is displayed: ORA-01722: invalid number The problem appears to be…
Filip
  • 1
  • 1
0
votes
0 answers

pass data from oracle apex popup interactive grid to main page lines section

I am working an app, which has header and lines section. I have built header region with a create button. After i enter data into the header region and click on create the lines section appear. To add data to the lines i have added another button…
vr_oracle
  • 11
  • 3
0
votes
1 answer

How to call groupBy actions on Interactive Grid/Interactive Reports with JavaScript Dynamic Action in Oracle APEX?

I am using Oracle APEX 23.1.0, and I have an interactive grid/interactive report region. I want to make a button that groups the data by some predetermined columns COL1 and COL2, and count the number of rows in each group. The problem is that I want…
The Bosco
  • 196
  • 12
1
2 3 4