Hi, in my table I have a column for a project which can have multiple project milestones (second column). Each of the milestone can have the value 'fullfilled' or 'pending' as current_status (third column). Now I want to aggregate the overall status of each project and assign it a final status (new virtual column) for better overview. The following rule should apply: If every milestone is fullfiled then the status of a project should change to 'Finished' If one or more milestones are pending then the status of project should be 'On-Hold' Meaning that I want to checklist every current status per project to get a final_status. Any idea how to do this with a case-when-clause or something similar? Thank you. Kind regards.
Discy Latest Questions
Hello, I am trying to create waterfall charts using Oracle Apex 20.1 with two series. One as a stack bar chart grouped by month and the second series for the increase resp. decrease of the values over the month. Please see the attached media for more details. In Oracle Apex 20.1 I didn't managed to combine the bar chart with a range bar. In the second series (i.e., range bar) the series isn't shown in the chart. Moreover, the increase resp. decrease should get its high from the previous sum value. Is there any possibility to do with a lag() function or something similar. The range bars don't have to be stacked(see picture 2) Any idea on how to get this done? Any help is appreciated. Thank you. Kind regards
Hi, on one of my page I a have a Interactive Grid which gets created by selecting a project from a Popup LOV. Based on the selection different data gets loaded in the IG. In this IG I have pre-filled two columns project_name and project_result. My goal is to when loading the data in the IG to save the changes into a second table (i.e. Interactive Grid). So that the first IG doesn't get changed with the pre-filled columns or overwritten, and the data with the rows gets loaded in the second table for further processing. I also have the problem that the pre-filled data from the IG doesn't get saved into the second table. Any ideas on how to achive this goal? I already tried it with removing the Interactive Grid Row Processing and custom PL/SQL but the data doesn't get saved or itt says no ROWID found. Thank you. Kind regards.
Hello, for the Interactive Grid I am trying to achieve the following: I have one item P16_PROJECT_NAME I want to have the same project name for every new row the user makes entries Currently when a new row is selected the value of the items get vanished I am using an IG for saving user entries with one item for the project name I tried it with different dynamic actions --> Row Initialization (IG) / Selection Change (IG) --> * A initial default value is not possible, since the user gives the project name individually Basically i want to copy the last entry from the project column to every added new row, so that I can reference them later and assign them. I hope you can help me with this problem. Kind regards. My Code: var widget = apex.region('grid').widget(); var grid = widget.interactiveGrid('getViews','grid'); var model = grid.model; var v_desc; v_desc = $v("P16_PROJECT_NAME");var myNewRecordId = model.insertNewRecord();var myNewRecord = model.getRecord(myNewRecordId); model.setValue(myNewRecord, 'PRO_PROZESS', v_desc); } Currently it inserts without a break after starting the page ...