Slack

Create one row in the collection (or in another collection) that holds the dates itself - you can use that as column headers. It is doable, but not so easy to explain. If you can’t get it to work (and you still really need it) you might think of hiring someone who has more APEX experience and has done something like this before.
25-Sep-2017 07:03:PM by: roelhartman
or do you mean to expand the submenu when the parent is hovered?
25-Sep-2017 07:02:PM by: maxime_tremblay
@roelhartman Collection will not working as how we can give dynamic columns names like for today date need to display as columns . In Collection how will capture those values with column date information
25-Sep-2017 06:58:PM by: lokeshsurana
Hey @jackie.mcilroy, great post (https://jackiemcilroy.blogspot.ca/2017/09/build-options-agile-development.html) about *Build Options & Agile Development*. This feature is pretty cool and still not that obvious for many developers :+1::skin-tone-2:
25-Sep-2017 03:37:PM by: trevis
Yes, you should load the data you want into a collection. Then build your form / report upon that collection. And finally create a process to read the contents of the collection and call the appropriate api’s.
25-Sep-2017 09:20:AM by: roelhartman
@roelhartman yes it’s on top of EBS It’s not like 7 day’s option will have selection for week and month Table structure is straight Projectid taskid hourtype totalhours timesheet date and empid Will Collection will help for this format?
25-Sep-2017 09:16:AM by: lokeshsurana
Anybody have idea about camunda with Oracle apex workflow
25-Sep-2017 09:15:AM by: mayurvaghasiya22
Just realize when you start doing something outside of the wizard, an deeper understanding of how things work really helps. I need to leave the office now, thanks much for your assistance!
25-Sep-2017 09:09:AM by: jolliffe
But I think I will need to be doing it via jquery later on, as I want to try to user checked/unchecked/indeterminate options for checkbox
25-Sep-2017 09:06:AM by: jolliffe
sure, let me check out how to do that. I got it working as a report for now anyway, using checkbox2/p_attributes as you suggested
25-Sep-2017 09:05:AM by: jolliffe
maybe you can create an example on apex.oracle.com so I can take a look?
25-Sep-2017 08:58:AM by: commi235
I can't guarantee that the same query will return data from same result set if run after it has been used to create the checkbox
25-Sep-2017 08:51:AM by: jolliffe
OK, I guess the bit I am struggling with is how to do this population accurately and efficiently
25-Sep-2017 08:49:AM by: jolliffe
that should be the APEX Process. Anyhow you just need to fill the page item with either 0 or 1 (or N,Y) and then set the page item to checkbox and give it an LOV using above values
25-Sep-2017 08:29:AM by: commi235
I guess I can do this as a report, was just that simple list of values, checkbox item seemed much simpler...
25-Sep-2017 08:17:AM by: jolliffe
the default?
25-Sep-2017 08:14:AM by: jolliffe
how to you fill the form data? PL/SQL Process or APEX Fetch Process?
25-Sep-2017 08:12:AM by: commi235
oh a form
25-Sep-2017 08:12:AM by: commi235
it is just a checkbox item within a form
25-Sep-2017 08:10:AM by: jolliffe
this shows the two options, either prepare checkbox using apex_item api or prepare a value and then setup the column as simple checkbox
25-Sep-2017 08:09:AM by: commi235
select empno , ename , apex_item.checkbox2( p_idx => 1 , p_value => empno , p_checked_values => case when comm is not null then empno else null end ) as chk_api , case when comm is not null then 1 else 0 end as chk_plain from emp ;
25-Sep-2017 08:08:AM by: commi235
OK, and maybe this is my confusion, but I have not defined it as a report
25-Sep-2017 08:08:AM by: jolliffe
remove the ticks around the sql
25-Sep-2017 08:07:AM by: commi235
ok, example on emp table: `select empno , ename , apex_item.checkbox2( p_idx => 1 , p_value => empno , p_checked_values => case when comm is not null then empno else null end ) as chk from emp ;` Then set the column chk to not escape any special characters.
25-Sep-2017 08:06:AM by: commi235
It's not exactly a LOV. I'm using standard Checkbox item, and then under the List of Values attribute for the checkbox, I select SQL QUery, and then define my query there...
25-Sep-2017 08:05:AM by: jolliffe
yes, that's pretty much it
25-Sep-2017 08:04:AM by: jolliffe
what are you trying to achieve exactly? I thought you had a report with applications and wanted to have a checkbox indicating whether the user has access or not
25-Sep-2017 08:03:AM by: commi235
so you are using the query in a LOV?
25-Sep-2017 08:02:AM by: commi235
Or should I just be defining this as dynamic PL/SQL block, and building up list myself using apex_item.checkbox2?
25-Sep-2017 07:58:AM by: jolliffe
or if i change number of columns for item, I get " ORA-00947: not enough values ORA-20987: APEX - Wrong number of columns selected in the LOV SQL query for P34_NEW_2. See examples for valid statements. - " when I run it...
25-Sep-2017 07:57:AM by: jolliffe
Note however then my code editor gives warning, "Wrong number of columns selected in the SQL query. See Help of attribute for details."
25-Sep-2017 07:56:AM by: jolliffe
OK so change query to "SELECT USERNAME, USERNAME, MOD(ROWNUM, 2) as checkbox_value FROM DBA_USERS", but still using standard apex Checkbox Item Type?
25-Sep-2017 07:54:AM by: jolliffe
in your case but another column into your query: `case when "user_has_access" then 1 else 0 end as checkbox_value` Then set up the checkbox on this column and use 1 for checked and 0 for unchecked
25-Sep-2017 07:49:AM by: commi235
How to Hierarchical Query, Parents, Children and Their Cycles http://apexfusion.blogspot.com/2017/09/how-to-hierarchical-query-parents.html
25-Sep-2017 07:48:AM by: m_yasir_ali
But I am starting to wonder if I should be defining the checkbox list somehow programmatically using a PL/SQL block, so I can use apex_item.checkbox2, will give me more control?
25-Sep-2017 07:47:AM by: jolliffe
Query is pretty generic, I am just using checkbox itemtype, and populating from this list, for 'applications' that a particular user has proxy access to...
25-Sep-2017 07:46:AM by: jolliffe
This is query I am using to build checkbox list "SELECT APPLICATION A1, APPLICATION A2 FROM UTL_SCHEMA_DATA.APPLICATION_SCHEMAS"
25-Sep-2017 07:45:AM by: jolliffe
@jolliffe Can you share the query? In general you can use the p_checked_values parameter of apex_item.checkbox2
25-Sep-2017 07:41:AM by: commi235
Going round in circles here. I'm using Checkbox item type based on a SQL query, but want to set the initial checked/unchecked state based on data too, any ideas?
25-Sep-2017 07:33:AM by: jolliffe
Hey guys,I am facing some issue while applying custom theme using theme roller in apex 5.1, When I create new theme and apply it as current theme it will just mess up my screen i.e white screen with misaligned components..Any idea?
25-Sep-2017 07:04:AM by: ashwinrao

APEX Forum

Here you find the 25 latest APEX Forum Threads updated every 5 Minutes
rdarlin
25-Sep-2017 20:53
Terminate network connection in DMZ
Link
1 replies - last reply: 25-Sep-2017 20:53- by: rdarlin
AnnelizeF
25-Sep-2017 16:54
JSON displayed on page calling web service via plsql
Link
1 replies - last reply: 25-Sep-2017 17:26- by: fac586
Steve.1234555
25-Sep-2017 16:52
APEX_MAIL - editing HTML templates?
Link
0 replies
Matthew Morri
25-Sep-2017 16:40
Universal Theme stops working
Link
4 replies - last reply: 25-Sep-2017 17:28- by: fac586
VANJ
25-Sep-2017 16:20
Checkbox - Prevent default
Link
1 replies - last reply: 25-Sep-2017 20:15- by: Mahmoud_Rabie
3517463
25-Sep-2017 14:23
APEX_IR.GET_REPORT With Basereport_ID
Link
0 replies
HerreraEdgard
25-Sep-2017 13:03
RESTful Web Service - APEX 5.1.2.00.09
Link
2 replies - last reply: 25-Sep-2017 14:00- by: Pavel_p
Diviya
25-Sep-2017 12:23
OWAPS Scan Vulnerabilities in Apex Application
Link
1 replies - last reply: 25-Sep-2017 20:36- by: Mahmoud_Rabie
Soukaina IDRI
25-Sep-2017 12:05
How to custom navigation menus and navigation bar in apex5.1
Link
0 replies
Youn
25-Sep-2017 11:48
How to check if the user has logout from application ?
Link
5 replies - last reply: 25-Sep-2017 18:01- by: fac586
Mirko Freuden
25-Sep-2017 11:10
How to use interactive grid with more than 100 columns
Link
1 replies - last reply: 25-Sep-2017 12:44- by: Mike Kutz
Amit_Apex
25-Sep-2017 10:36
Oracle Apex 5.1 - Customized/conditional Left Menu(Navigation Menu) based on Record #
Link
2 replies - last reply: 25-Sep-2017 11:53- by: fac586
ete
25-Sep-2017 09:22
Handling many images
Link
5 replies - last reply: 25-Sep-2017 14:11- by: Mike Kutz
Hanu M
25-Sep-2017 07:40
Problem with SQLERRM & SQLCODE..!
Link
6 replies - last reply: 25-Sep-2017 14:15- by: Hanu M
2933534
25-Sep-2017 04:11
oracle apex translate overrided menu bug?
Link
3 replies - last reply: 25-Sep-2017 12:03- by: Tom W.
Flammifer
24-Sep-2017 21:48
Calendar
Link
2 replies - last reply: 25-Sep-2017 20:56- by: Flammifer
Mahmoud_Rabie
24-Sep-2017 16:26
Certificate validation failure
Link
2 replies - last reply: 25-Sep-2017 20:12- by: Mahmoud_Rabie
Soukaina IDRI
21-Sep-2017 10:07
How to implement new template in ORACLE APEX5.1
Link
6 replies - last reply: 25-Sep-2017 13:30- by: Scott
Alfonso Vicen
20-Sep-2017 17:53
Dynamic action for any click in page
Link
5 replies - last reply: 25-Sep-2017 20:30- by: DanielB
MikeOBI
19-Sep-2017 09:23
Stacked bar chart totals, only partly working using 'stackLabel'
Link
2 replies - last reply: 25-Sep-2017 20:29- by: Oleh Tyshchenko
Sgodavar-Orac
18-Sep-2017 22:35
How to display a conditional color background for a column in IR/IG
Link
3 replies - last reply: 25-Sep-2017 14:19- by: John Snyders-Oracle
sect55
15-Sep-2017 12:33
Get an error when verifying/updating Universal Theme (Theme 42) in APEX 5.1
Link
1 replies - last reply: 25-Sep-2017 12:42- by: sect55
Mohini Jadhav
18-Aug-2017 10:10
Implementing Import Functionality
Link
3 replies - last reply: 25-Sep-2017 17:50- by: Mohini Jadhav
Ud_smith
03-Aug-2017 18:50
APEX_APPLICATION Loop Update
Link
2 replies - last reply: - by:
kgamble
03-Aug-2017 14:14
Existing application 5.0 to 5.1, problem with Detail View of Interactive Report
Link
2 replies - last reply: 25-Sep-2017 09:35- by: kgamble

News

X
    
 
ImageNewsFavoriteForward
Jackie McIlroy    
Build Options
Link
25-Sep-2017 12:32:00 by: Juergen Schuster
Dimitri Gielis  
Upgrades in Exadata Express Cloud
APEX 5.1, Cloud
Link
23-Sep-2017 17:09:23 by: Juergen Schuster
Learco Brizzi    Other
New Conference: APEX World, Netherlands, Rotterdam, 22-MAR-2018
Conferences
Link
21-Sep-2017 08:23:23 by: Juergen Schuster
Joel Kallman    
Docker for Test, Dev and Training
Docker
Link
21-Sep-2017 06:36:57 by: Juergen Schuster
Joel Kallman    
Where to get Help
Link
20-Sep-2017 22:19:58 by: Juergen Schuster
Dimitri Gielis    Other
Webinar: APEX Reporting, Sep. 22nd
Reports, Webinar
Link
20-Sep-2017 10:15:51 by: Juergen Schuster
Dimitri Gielis    Other
November 7th, APEX day in Belgium
Conferences
Link
19-Sep-2017 15:34:29 by: Juergen Schuster
Rodrigo Mesquita  
QuickSQL.oracle.com Introduction
Quick SQL
Link
19-Sep-2017 15:31:36 by: Juergen Schuster
Stefanie Maisel  
Align Button right next to Action Menu in Interactive Report
Interactive Report
Link
17-Sep-2017 07:12:47 by: Juergen Schuster
Joel Kallman    
From Low Code to High Control
Press
Link
16-Sep-2017 18:13:40 by: Juergen Schuster
Marc Sewtz    Other
apex.oracle.com has been upgraded to 5.1.3
APEX 5.1
Link
16-Sep-2017 18:11:54 by: Juergen Schuster
Jorge Rimblas  Other
Webinar: Integrate Knockout into APEX Sep. 21
Webinar
Link
15-Sep-2017 20:00:34 by: Juergen Schuster
Steven Feuerstein    Other
Recorded Class: Oracle Database for Beginners
Trainings
Link
15-Sep-2017 14:23:30 by: Juergen Schuster
Steven Feuerstein    Other
Free PL/SQL Course for Beginners
PL/SQL, Trainings
Link
15-Sep-2017 13:09:23 by: Juergen Schuster
Richard Dacre  
APEX and Accessibility Validation
Accessibility
Link
14-Sep-2017 22:10:39 by: Juergen Schuster
David Anderson    Other
New APEX Live Web-Trainings available
Trainings
Link
14-Sep-2017 22:08:29 by: Juergen Schuster
Joel Kallman    Other
APEX on Amazon RDS
Hosting
Link
14-Sep-2017 21:55:25 by: Juergen Schuster
Vincent Morneau  
JavaScript async/await in APEX
JavaScript
Link
13-Sep-2017 13:36:40 by: Juergen Schuster
Dick Dral  
ORA-00933 when editing a APEX report
Error, Reports
Link
13-Sep-2017 09:01:08 by: Juergen Schuster
Jorge Rimblas  
How to freeze Header and Columns in a Classic Report
Reports
Link
12-Sep-2017 13:10:16 by: Juergen Schuster
Juergen Schuster  Other
New Job Offer: Netherlands, Groningen, permanent
Jobs
Link
12-Sep-2017 11:53:18 by: Juergen Schuster
Amr Abdeen  
Show Alert, Success, Error Messages by JavaScript
JavaScript, Messages
Link
12-Sep-2017 10:11:51 by: Juergen Schuster
Steven Feuerstein  Other
Video: Unit and Regression Tests in PL/SQL
PL/SQL, Testing, Videos
Link
12-Sep-2017 10:07:29 by: Juergen Schuster
Jorge Rimblas    
New Plug-in: Freeze Column & Headers in Classic Reports
Plug-ins, Reports
Link
10-Sep-2017 14:42:13 by: Juergen Schuster
Maxime Tremblay  
APEX Items in Application Builder Style
User Interface
Link
09-Sep-2017 10:53:23 by: Juergen Schuster
Dimitri Gielis    
How to do an APEX App in 2017 Part 9
Link
06-Sep-2017 19:30:54 by: Juergen Schuster
yotti Alli Pierre  
Call Modal Dialog from JavaScript
JavaScript, Modal Page
Link
06-Sep-2017 12:25:17 by: Juergen Schuster
Dick Dral    
New Plug-in: Copy values with arrow keys in Tabular Forms
Plug-ins, Tabular Forms
Link
05-Sep-2017 14:08:18 by: Juergen Schuster
Carsten Czarski  
What you all can do in JavaScript with: apex.item
API, JavaScript
Link
05-Sep-2017 11:14:50 by: Juergen Schuster
Juergen Schuster  Other
New Job Offer: Switzerland, Geneve, permanent
Jobs
Link
05-Sep-2017 05:49:44 by: Juergen Schuster
Aljaz Mali  Other
Webinar: APEX Security
Security, Webinar
Link
04-Sep-2017 16:31:00 by: Juergen Schuster
Adrian Png  
APEX and REST without the pain
Node.js, REST
Link
04-Sep-2017 16:20:53 by: Juergen Schuster

Tweets by @orclapexworld

CSS for Home-Pages 1,10,20