Discy Latest Questions

Aru
Aru

Aru

View Profile
  • 2
Contributor
Asked:
  • 2

Hi Experts, I have a Calendar in APEX, please help in achieving the below 1, Want to get the name of the month when pressing the previous/next button on the Top When I press next month, as per the above screenshot it will show August 2021, how to get that values (Month Name) for me to process a query outside the calendar 2, When clicking any of the date (eg: 06/07/2021) in the calendar with Create link, my requirement is to auto-populate the same date in my popup form... so in my new form date should be assigned as 06/07/2021 Please advise Regards Aru  

apexcalendar
Aleksandar
Aleksandar

Aleksandar

View Profile
  • 2
Contributor
Asked:
  • 2

Hello everyone. I'm having trouble translating alert messages in Oracle apex. Since my language (Bosnian) is not supported by apex, I'm trying to translate entire application manually. I've done 90% of work already, translating strings in Shared Components/Globalization/Text messages. I have found text message names and English text values on official oracle website on this link. Now my problem is to translate alert messages. For example when someone downloads a report, success messages is shown in English. Or when I try to add entry in table, if there is some problem,warning is shown in English. Does anyone know where to find those strings, or how to translate them? I'll be really grateful. Thanks in advance.

apexglobalizationlocalizationoracletranslate
Greg
Greg

Greg

View Profile
  • 2
Professional
Asked:
  • 2

I have an APEX 20.2 page region based on selecting rows from a table. This works fine, but if I want an administrator to see all records, I would have thought I could add the line: OR apex_acl.has_user_role(:APP_ID, :APP_USER, 'ADMINISTRATOR') An example would be: select ALBUM_TITLE,        YEAR_OF_RELEASE,        ALBUM_ID,        ARTIST_ID,        ALBUM_TYPE_ID,        COMMENTS,        COVER_ART_BLOB_CONTENT,        COVER_ART_MIME_TYPE   from MUSIC_ALBUMS   where 0=1 OR apex_acl.has_user_role(:APP_ID, :APP_USER, 'ADMINISTRATOR') But when I do this, the query returns the error ORA-20999: Failed to parse SQL query! <p>ORA-06550: line 10, column 66: ORA-00920: invalid relational operator</p> What am I doing wrong?  

apex
Hussain
Hussain

Hussain

View Profile
  • 2
Professional
Asked:
  • 2

Hi Vinish, If any validation which fire either it from database trigger or constrains check then how we can capture and show property message. As most of the database errors appear like ’033-ORA-NOT VALID CONDITION’ How to capture this error and make it proper so user can easily understand. Thanks.

oracle apex
Femi
Femi

Femi

View Profile
  • 2
Contributor
Asked:
  • 2

Good day I have a page with two region, one static, with an item to search and a submit button and the other one, a classic report. Every time I search and return to the page, the sql from the report executes with the previous search, hence delaying the loading of the page.  I tried adding a clear session state in a process before header and it clears the page but it fires every time I click submit and does not return any records. Please help

question