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
0
votes
1 answer

Make a Report that Can Edit another Report in APEX

I have multiple report pages. I am working on a system that stores a lot of data. Is it possible to have reports that are able to have column edited on two different reports? i.e. Not all the information may be relevant to the person entering data…
bbowen14
  • 37
  • 5
0
votes
1 answer

IG - how to register changes to cell being edited - eg. to action shortcut key (Oracle Apex Interactive Grid)

We have common functionality across multiple pages: Cancel/Save/Back/Next (buttons). I added shortcut keys via app-level static JavaScript file: Alt-C/S/B/N (using common CSS on the buttons & jQuery binds). Problem: when using shortcut key whilst…
Clark
  • 21
  • 3
0
votes
1 answer

Lines are shifted around when creating and saving records through Add rows Button in interactive grid oracle Apex

For Ex: I have 5 existing lines as line no "1,2,3,4,5" and now i am trying to add one more row as "6" and try to save then the rows are shifted around while saving records through "Add rows" Button as "4,3,5,6,1,2" in interactive grid oracle Apex,…
Abinnaya
  • 203
  • 4
  • 26
0
votes
1 answer

Oracle APEX - How to populate interactive grid using APEX collection

I am new to developing application using oracle apex. Please excuse me if this question seems very trivial in nature. In a nutshell, I am trying to invoke a REST service programmatically to populate an interactive grid on oracle apex page. Here's…
svijay.aug12
  • 531
  • 3
  • 13
  • 32
0
votes
1 answer

want an example/illustration use of JS aggregates function in Oracle Apex

i saw the documentation here: https://docs.oracle.com/en/database/oracle/application-express/21.2/aexjs/model.html#.FieldMeta and want to have an example of using "aggregates" function in IG / IR where it is possible and how to. please guide.
Ahmed Haroon
  • 69
  • 1
  • 12
0
votes
1 answer

Oracle Apex: how to exclude a selected PopUp LOV row from its Query and refresh it dynamiclly

i had an IG, it has a PopUp LOV column to select value, the LOV Query is in Shared Component. is it possible if user select '01-My First Row' from LOV this will not available in next row or disabled to select and similar for other selected values?…
Ahmed Haroon
  • 69
  • 1
  • 12
0
votes
1 answer

Oracle Apex: how to populate data manually in editable IG

we have a requirement to manually populate editable IG with data from another table when user press a button to fill rows. IG is based on a table and a where clause is used but initially when appear the grid is empty, user will press a button and…
Ahmed Haroon
  • 69
  • 1
  • 12
0
votes
2 answers

Oracle APEX - Interactive Grid - Sorting Select List column on return value

I have a Select List column in an Interactive Grid. It displays abbreviated days of the week (in Dutch): Ma - 1 Di - 2 Wo - 3 Do - 4 Vr - 5 Za - 6 Zo - 7 And so on... If we now sort on this column, it is sorted on its display value rather than the…
HotFix
  • 157
  • 1
  • 11
0
votes
1 answer

Set column value from Application Item by using JavaScript in Oracle APEX interactive grid

i want to set column value in IG when user press Save. i have 2 columns 'created_by' and 'updated_by', now when my primary key column :P8_ID is null then should set 'created_by' column value using application item :SESSION_USER_ID which was set at…
Ahmed Haroon
  • 69
  • 1
  • 12
0
votes
0 answers

Cannot pass a value of an IG column to LOV parameter

My problem is when trying to pass the value of an IG column to a parameter of LOV (based on Rest Data Source), the value did not passed. However, I am able to pass the value of a page item successfully or a static value, but not the value of the IG…
Mahmoud Ezz El-Din
  • 1
  • 1
0
votes
1 answer

Oracle APEX 20.2 Problem with the cascading LOV (built on Web Source) in an Interactive Grid

I have a master form and a detail interactive grid. And I have two LOV's on the interactive grid, both of them are built on Rest Web Source. First LOV is a master & the second one is the cascading LOV with a parameter from the master. The problem is…
Mahmoud Ezz El-Din
  • 1
  • 1
0
votes
1 answer

Interactive Grid shows no results when filtered or sorted

I am using Oracle Apex v21.1. I have an Interactive Grid on a Modal Dialog Page which gives me the logs of the modifications made on a certain item. Here's the scenario : Select the item on the list Step 1 The details page of the item opens Click…
ThomasT
  • 336
  • 4
  • 25
0
votes
1 answer

Oracle Apex Interactive Grid Disable a ROW based on a condition

I have a table called TABLE_A with fields ID, FIRST_NAME, LAST_NAME, AGE, STATUS. From this table i have an interactive grid in ORACLE APEX 20.2 and i want when the status is approved then the entire row of that record in the grid to be disabled…
Basudev Singh
  • 79
  • 2
  • 13
0
votes
2 answers

For an Editable Interactive Grid, the Page attribute 'Reload on Submit' must be set to 'Only for Success'

I am new to Oracle APEX, after upgraded APEX Version to 20.2 my Tabular form getting Deprecated, so i have changed tabular form into Editable Interactive Grid, after changing that i am getting below error, For an Editable Interactive Grid, the Page…
user3321757
  • 37
  • 1
  • 8
0
votes
1 answer

Interactive grid in modal dialog cannot be selected anymore via jQuery

Background Information: Our situation At work we have created multiple apps and a few of them make use of an interactive grid inside of a modal dialog page. Last week we upgraded from Oracle APEX 19.1 to Oracle APEX 21.1 . The problem described…
Philipp Lange
  • 851
  • 1
  • 6
  • 11
1 2
3
4