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

Set page item with value from interactive grid column when clicking on the grid region

I'm using apex 22.1. I'm trying to set a page field with a value from interactive grid column on the row I'm currently on, and it needs to change if I change the row I'm on. This is what I have tried. I have assigned static id to the grid "IG_GRID".…
Syd
  • 17
  • 1
  • 4
0
votes
0 answers

How to navigate rows in interactive grid using next and previous buttons

May I know how to navigate rows in interactive grid using next and previous buttons in oracle Apex. In my case I need to display always 1 row even there are multiple records fetch and allows to navigate next/previous row using buttons.
chk.buddi
  • 554
  • 1
  • 8
  • 29
0
votes
1 answer

How can i get the selected saved reports ID from an Interactive Grid? In Oracle APEX

So basically i would like to have a custom printing process from my IG, that prints data based on the selected Saved Report from the built in report list. (no, the built in printing method, does not cut it) So im using this built in process for…
APex newbie
  • 1
  • 2
0
votes
0 answers

Download large dataset using interactive grid oracle apex

I've created an interactive grid report using a complex sql query. This is a very fine-tuned SQL query. And loads Millions of data in 2-3 seconds on apex as well. But usually filtered record count will be between 150k - 300k. When it comes to…
Anand Jagtap
  • 113
  • 1
  • 9
0
votes
1 answer

Getting updating value from IG

I need to store the updated value from the IG in the P12_EMPNO page element. To do this, use this code in DA --- > Run Javascript code var changedValue = apex.item("N001").getValue(); apex.item("P12_EMPNO").setValue(changedValue); But the value is…
shajin
  • 29
  • 4
0
votes
1 answer

Oracle Apex - Dynamic Header in Interactive Grid

I need dynamic header in interactive grid, which should look like this: 01/2023, 02/2023, 03/2023, 04/2024, 05/2023, 06/2023 ... 01/2028 Display each month and year over five years. When the month is over (ex. 02/2023) it should be deleted from…
naninrtc
  • 1
  • 2
0
votes
0 answers

Oracle APEX converts file name to lowercase: how to preserve?

I have an item :p1_file_name Set a value on page load: :p1_file_name := 'FOO_BAR_'||to_char(sysdate, 'DDMMYYYY'); I'm referring this ITEM in Attributes/Filename section as &P5_FILE_NAME. And it works on interactive reports fine. However, if I'm…
Oguen
  • 505
  • 7
  • 21
0
votes
1 answer

Applying a column based condition in an interactive report on first page load in Oracle APEX

I have a requirement in Oracle Apex's Interactive report. At first load, only that data should appear whose Operation is not deleted. This should also reflect in the export of the report. However, they want to provide an option that is user should…
SQL_Learner
  • 19
  • 5
0
votes
0 answers

Oracle Apex Interactive Grid - Changing column size via JS not working in specific case

My enviroment: Apex 21.2 Oracle 19.3 Requirement: in a page i need to show 3 IG based on table and queries. first and third IG are in single record view mode (query returns just one row), second is in normal view mode (multi records). I need to…
Roberto
  • 1
  • 3
0
votes
0 answers

Oracle Apex Popup LOVs - Additional Outputs

I am using Oracle Apex 22.2 on Centos 7. I have a problem when using the Popup LOVs Additional Outputs. I use it to set the values in an order items Interactive Grid, except for the quantity column, which has to be set manually by the user. If you…
kimoturbo
  • 41
  • 1
  • 1
  • 8
0
votes
1 answer

Interactive Grid how to collaps all records

I have a IG with control break to collapse grouped records based on varchar column. The solution proposed in How run a control-broken IG as collapsed in the first place? by @akil_Ramesh is working fine for me but only when the report has few…
Roberto
  • 1
  • 3
0
votes
0 answers

How to write 'TOTAL' on the cell of interactive grid on a-GV-row.is-grandTotal row?

It used a function in interactive grid column aggregate sum function this help me to show grand total of column . function(options) { options.defaultGridColumnOptions = { aggregates: ["SUM"] }; return options; } after using that…
sohaib sonu
  • 41
  • 1
  • 3
0
votes
1 answer

Oracle APEX 21.2.6 Interactive Grid - double-click to edit popup LOV shifts data rows over. How to prevent this?

I have an IG display that looks like this without clicking anything else: Only Supervisor, and Direct Supervisor are editable, and they are both Popup LOV's. If I double-click the Supervisor data, and immediately type any letter for the Popup LOV…
cam_pdx
  • 197
  • 2
  • 8
0
votes
1 answer

APEX Interactive Grid Alternating Row Colors

I have an interactive grid in APEX and I am struggling with the actual formatting of the report itself. Is it possible to have an alternating fill for the rows in the report like Excel? Also wanted to know what the easiest way to have a standard…
bbowen14
  • 37
  • 5
0
votes
1 answer

Oracle Apex Interactive Grid Sum Row

I have a table with 2 columns(GAUGE_NAME, CALCULATED_VALUE) and table has values in Column screenshot. I create a page and add interactive grid. After that i followed these steps; Run page -> Action Menu(Interactive Grid) -> Data -> Aggregate ->…
kapramci
  • 1
  • 1
1
2
3 4