Discussions
Categories
- 196.9K All Categories
- 2.2K Data
- 239 Big Data Appliance
- 1.9K Data Science
- 450.3K Databases
- 221.7K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 31 Multilingual Engine
- 550 MySQL Community Space
- 478 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3K ORDS, SODA & JSON in the Database
- 546 SQLcl
- 4K SQL Developer Data Modeler
- 187K SQL & PL/SQL
- 21.3K SQL Developer
- 295.9K Development
- 17 Developer Projects
- 138 Programming Languages
- 292.6K Development Tools
- 107 DevOps
- 3.1K QA/Testing
- 646K Java
- 28 Java Learning Subscription
- 37K Database Connectivity
- 155 Java Community Process
- 105 Java 25
- 22.1K Java APIs
- 138.1K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 18 Java Essentials
- 160 Java 8 Questions
- 86K Java Programming
- 80 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.3K Java SE
- 13.8K Java Security
- 204 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 442 LiveLabs
- 38 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.7K Other Languages
- 2.3K Chinese
- 171 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 232 Portuguese
Is it possible to edit reports, extracted from a table, that one can add additional line items/data

Hi,
I'm trying to manage and create a Case Management Data Base for users to manage specific customers.
Background: I have very limited knowledge on how to use APEX but have thus far been able to upload data from a CSV file, into a table.
This will be my reference or MASTER list that all new data is added.
What I would like to figure out is how do I go about creating a report that allows me to 'edit' if you will, or 'update' the table with additional fields.
Some have mentioned that I will need to learn how to create triggers, DML and indexes.
Here is made up sample of the Master List
Customer Name | Customer Contact Number | Info 1 | Product Request | Info 2 | Submission Date | Info 3 | Requested Date | Info 4 | Appointment Date | New Account # | 1st Invoice Date | Order Status | Rework Required? | Order Held? | Case Age | Call Back Date | Call Back Notes |
Sample 1 | 0100010000 | Product A | 1/01/2015 | 15/01/2015 | 20/01/2015 | ||||||||||||
Sample 2 | 0100010002 | Product B | 1/01/2015 | 15/01/2015 | 18/01/2015 | ||||||||||||
Sample 3 | 0100010003 | Product C | 1/01/2015 | 15/01/2015 | 17/01/2015 | ||||||||||||
Sample 4 | 0100010004 | Product A | 1/01/2015 | 15/01/2015 | 19/01/2015 | ||||||||||||
Sample 5 | 0100010005 | Product B | 1/01/2015 | 15/01/2015 | 20/01/2015 |
What I would like the report to do is allow me to retrieve the data, filter out the INFO 1, 2, 3, 4 as that's Data I do not need to present (but is part of the original file I upload via CSV) and for me to then update the table, or insert the data above into a new table, which I called AGENT TABLE. It contains additional columns or fields for me to enter data to.
To add to that, I would like a function to 'assign' it to a particular Case Management Agent - So each individual will have a Unique ID for Example.. A12345, A12346, A12347, A12348 and so forth.
Customer Name | Customer Contact Number | Product Request | Submission Date | Requested Date | Appointment Date | New Account # | 1st Invoice Date | Order Status | Rework Required? | Order Held? | Case Age | Call Back Date | Call Back Notes |
Sample 1 | 0100010000 | Product A | 1/01/2015 | 15/01/2015 | 20/01/2015 | ||||||||
Sample 2 | 0100010002 | Product B | 1/01/2015 | 15/01/2015 | 18/01/2015 | ||||||||
Sample 3 | 0100010003 | Product C | 1/01/2015 | 15/01/2015 | 17/01/2015 | ||||||||
Sample 4 | 0100010004 | Product A | 1/01/2015 | 15/01/2015 | 19/01/2015 | ||||||||
Sample 5 | 0100010005 | Product B | 1/01/2015 | 15/01/2015 | 20/01/2015 |
With PRODUCT and ORDER STATUS I would like it so I can select from a drop down list.
I hope that makes sense. Please contact or reply and i'll do the best I can to explain what I'm trying to achieve (I'm still relatively new to this)
Thank you all and hoe to hear from the community soon.