Hi I need amount to display Right corner of screen for each transactions. Please help.
Discy Latest Questions
Hello everyone . I want to hide a column in my interactive grid based on page item value. Can any one help me.
Greg GContributor
I have a colleague that is using a collection in one of his pages. However, when he runs the query: Select * from apex_collections; No rows are returned. Any idea why no rows are found? Thanks.
bob_finlandersContributor
I have been struggling to find a way how to implement this task Below is the GUI I have designed I have 2 reports on my page Interactive grid report [ Name : Employees ] Interactive report [ Name : selected ] Whatever I select from first report should be shown on second report [ selected ] on checkbox is tick I have refer this blog but no luck : https://www.foxinfotech.in/2019/10/oracle-apex-interactive-grid-get-selected-rows-example.html Any solution or video demonstration is much appreciated
bob_finlandersContributor
I am running out of time because of this task, No where I am able to find appropriate answers for this task. I have a interactive grid report and in which I have enabled the editing option. <Interactive grid -> attributes -> editing -> enabled /> After enabling the editing option -> The checkbox became available for me like below When I select multiple checkbox their details should be inserted to table I posted same question on Stackoverflow but no solution Can you please check and provide your solution or input Stackoverflow question : https://stackoverflow.com/questions/73166100/iterate-through-selected-checkbox-oracle-apex?noredirect=1#comment129221060_73166100 Thanks & Regards, Bob finlanders
BheemProfessional
hi is anybody implemented push notification in oracle apex (Default functionality).
Hi I need to update the forecast date for below rows. based on forecast date change in previous rows. for example : in second row forecast date is : 23 -March-2022 , if i change this date to 24-March-2022 , then below rows forecast date should change according to 1 day extra. Thanks.
MacContributor
Hi all, I hope you can help. I have SQL which is the data source for an IG. The SQL aggregates hours spent working on specific tasks and gather info from other tables in sub-queries. The duration is stored in minutes but I want to display the duration in hh: mm format. I have done this successfully for the primary query, however, the sub-queries fail with "ORA-00921: unexpected end of SQL command". The query is below. If I remove the trim()... from the sub-query it works fine but the format of the duration is just in minutes rather than hh:mm. I would appreciate any help you might be able to offer. This code fails select c.week_starting, trim(to_char(trunc(sum(c.DUR_IN_MINS) / 60), '9')) || ':' || trim(to_char(trunc(mod(abs(sum(c.DUR_IN_MINS)), 60)), '09')) AS CLIENT_HHMM, ( select trim(to_char(trunc(sum(r.DUR_IN_MINS) / 60), '9')) || ':' || trim(to_char(trunc(mod(abs(sum(r.DUR_IN_MINS)), 60)) AS ACT_HHMM from FPO_CLIENT_REL_ACT r where c.week_starting = r.week_starting ) from FPO_SECT_A_PRO_PRAC c group by c.week_starting THIS WORKS FINE select c.week_starting, trim(to_char(trunc(sum(c.DUR_IN_MINS) / 60), '9')) || ':' || trim(to_char(trunc(mod(abs(sum(c.DUR_IN_MINS)), 60)), '09')) AS CLIENT_HHMM, (
MacContributor
Hi, I am trying to simply centre some text in a "blank with attributes"/"static content" region on a page using CSS class of "title-region" and also various other CSS classes. I have been able to centre the text using pure HTML in the static content but I reckon there is a more elegant way of going this using CSS. I have checked the Universal Theme at https://apex.oracle.com/pls/apex/apex_pm/r/ut/reference but nothing from the reference provided the required output. Any thoughts or ideas would be greatly appreciated. Brett
Hi, I'm building a page in APEX. In that page I have 2 items, "text field with autocomplete" Both of them are getting the LOV from the same table but different column. text_field_1 getting the id_1; text_field_2 getting the id_2 So If I input/select a value from text_field_1 I can set a value automatically to text_field_2 or vice versa. I can do one is to one relationship, like if I enter "bca" in text_field_2, I can set the correct value for text_field_1 which is "2" But I'm having a problem for the one is to many relationship. If I enter "1" in text_field_1, It will return 2 values which are "abc,cba" I'm trying to figure it out on how I list the abc and cba so that I can still choose what value I want from the two. Please someone help me with this?