Join an array of strings in Apex

Using Apex, I want to split a string and then rejoin it with the 'AND' operator as the separator. I split the string successfully but having an issue in rejoining it. String [] ideaSearchText =...

Saving and retrieving CLOB data greater than 32K in Oracle Apex

My aim is to retrieve CLOB data from the database into a textarea in an Oracle Apex application and then to be able to save it into the database from the textarea itself on pressing a 'Save'...

Generate insert script for selected records?

I have a table with the following data: Pk_Id ProductName Fk_CompanyId Price ------------------------------------------------------ 1 AMX 1 ...

Report error: ORA-0000: normal, successful completion In Oracle APEX Tabular Form

Im getting Report error: ORA-0000: normal, successful completion Oracle Apex in a Tabular Form Report. I cant able to proceed with any operations in the Tabular Forms such as Add Rows and Delete...

How do I write a test class for Messaging.SingleEmailMessage apex class?

I have written the below Apex class that processes incoming email that are sent to an email service address and creates a new task from the incoming mail and then associates this new task with a...

Convert Unix time to Datetime in Apex Salesforce

I have requirement to to store the timestamp returned from the response to Salesforce DateTime. But the timestamp returned is in Unix format. How do I convert it to DateTime in Salesforce using apex?

Oracle Apex 5 interactive report blob image display

I am Having a apex application already available in Oracle APEX 4. Which is working fine. Now i am trying to migrate to the same apex application to APEX 5. After migrating some of the...

Read data from Excel file using Apex in Salesforce

I have a requirement where we need to parse the excel file and insert the data in one of the object using apex. This excel file contains multiple sheets. We need to read the data from multiple...

Referencing oracle apex APP_USER

I want to reference app_user in query (where username=(:APP_USER)) Now my query returns null values, I guess it's happening because my username col is varchar2. How to reference app_user in this...

404 Not Found The request could not be mapped to any database

Last few days I have been very tired to figure out this issue, and I also reinstalled ORDS few times, but I can't resolved this issue, can please help me to figure out. I am using apache tomcat...

Open modal dialog through JavaScript Oracle APEX

I am trying to open a modal dialog page through a JavaScript redirect URL. My code is like this: $('#Subnet tr').each(function (i, row){ var $row = $(row); var $hostname = ...

How to set a value to an application item in oracle apex 5

I have several tabs. There is a date picker on each tab. I need that date to be the same on all tabs no matter what. So, if the user changes the date on Tab 1, then goes to tab 2, the date on...

Oracle APEX - how to refresh Interactive Grid after save process executes

I have an interactive grid that is updated via custom javascript when the user clicks the custom toolbar button. Then the result is saves using grid's save button via a process. After the process...

How to filter for empty values with the Golang filter builder?

Carrying on from https://stackoverflow.com/questions/55898187/how-to-filter-on-null I am struggling to replicate the Go code to filter for null values of a particular column: import ( ...

ApexCharts Stacked Columns specific color for series

I Want to Display Data in Apex Charts Stacked Column , with specific color for each series (change the color to Red and Green, for Product A and Product B). Default Apex Charts choose the color. I...

VS Code Prettier format Apex classes

I've setup VS Code and I have Prettier working for everything except for Apex classes (*.cls). I've added the following snippet to my .prettierrc file, but I'm not seeing any changes. { "files":...

Oracle apex not working after installation http://localhost:8282/apex/apex_admin

This site can’t be reachedlocalhost refused to connect. Search Google for localhost 8282 apex admin ERR_CONNECTION_REFUSED I have installed oracle apex 19.2 v but after successful installation...

How do I set global options with chart JS?

Say I want some options to be global for all Apex charts. For colors it can be done with: Apex.colors = ['#F44336', '#E91E63', '#9C27B0']; Now what if I want all charts to be 300px high. What I...

Apex Charts custom tooltips - how do I get category name and color?

I want to create a custom tooltip in Apex Charts. Below is what is suggested in the official docs: tooltip: { custom: function({series, seriesIndex, dataPointIndex, w}) { return '<div...

Android AOSP build failing in build_image.py for android-10.0.0_r39

On Ubuntu 20.04 LTS. I have an AOSP tree checked out at android-10.0.0_r39. The tree builds fine for walleye - I can build an run on a device, no issues. I have no new files in the AOSP repo...

Dynamically adding of Series in Apex Chart

I had result that was pulled from the database, and each item in the result is a series in a single chart. I was able to update that chart but the last element of the result only shows in the...

apex select2 plugin not work well with oracle apex 20.1

Need to add a multi select item into my oracle apex form. Tried to use apex select2 plugin. But it didn't work well. When I add into the form it looks like in the below image, Then I tried to...

/apex/com.android.runtime/lib64/bionic/libc.so (abort+160), abort crash in Android 10 devices

I recently changed targedtSdk to 29 and made a release. And started getting this crash called abort. Below is the stack trace that I got from play console. All the crashes are happening only in...

Oracle Apex: How can I restrict a numeric field in a form to allow numbers only?

I have an item in a form which is a number field and I want to somehow make sure that only numbers are accepted in the field. If users enter letters I want the field to reject it. I already tried...

APEX 20.1 - Styling Column Group Heading of Interactive Grid

Does anyone have an example showing how column headings can be styled in an Interactive Grid? I would like the column headings in each of the 4 different Column Groups to have a different...

React Native Crashes - Samsung Android 10 only - apex/com.android.runtime/lib64/bionic/libc.so abort

We've seen this crash intermittent for the past few weeks, but only on Samsung Android 10 devices. So far we have been unable to replicate this locally, nor are we seeing this log into Sentry. It...

Apex Specialist Challenge 1

I cannot resolve this error. Closing a Maintenance Request of type 'Routine Maintenance' or 'Repair' did not create of a new Maintenance Request with the correct due date. The challenge is...

Abort crashes from "/apex/com.android.runtime/lib64/bionic/libc.so" on Android 11

I know there is a similar question for Android 10. I see occasional abort crashes on Android 11. The backtrackes of these crashes are not 100% identical, but very similar. Could anyone shed some...

How to define a custom tooltip in Apex chart in React?

I am defining four lines chart with Apex Chart. My data series: series: [ { name: "first", data: [28, 29, 33, 36, 32, 32, 33] }, { ...

How to pass Salesforce Flow variables into Apex Class with correct scope?

I'm trying to use a use a Flow in Salesforce to pass variables into an Apex Class that performs an HTTP Post to an external API. The Flow grabs an Opportunity, parses some of its fields, and...