Expert Articles

Comprehensive resources for Oracle RightNow developers and consultants


Posted by Ben Johns on Friday, May 24, 2019 - 4:04pm
Ben Johns's picture

The 45 North team has joined forces with CPI!

We're excited to announce that after years of working with CPI to deliver some great solutions together, our consulting firm 45 North Solutions has officially been acquired by them. Our combined teams and their diverse skillsets are opening up some incredible opportunities for our clients and are allowing us to provide more valuable, high-quality services!

Getting list of site languages via ROQL

Posted by AW Rowse on Tuesday, February 26, 2019 - 5:59am
AW Rowse's picture

Quick Query tip. If you need to get a list of the supported languages on a site, try the following query:

Select Language.ID, Language.LookupName From SiteInterface GROUP BY Language.LookupName;

The query will provide the ISO Local/Language codes applicable to your site. Unfortunately, it does not give you the localized labels for these languages.

Get the Interface ID in Customer Portal and ROQL

Posted by Ben Johns on Friday, February 1, 2019 - 3:25pm
Ben Johns's picture

Sometimes you may need the current interface from within Customer Portal. For instance, you'll need to filter on the Interface ID to retrieve a list of all end-user visible Products. There are two ways to do this:

Within a ROQL query

You can use the curInterface() ROQL method right in your query: SELECT ID, LookupName FROM ServiceProduct WHERE EndUserVisibleInterfaces.ID = curInterface() ORDER BY DisplayOrder

Via the CP API


New CXDev Toolbox Tool: Account Migrator

Posted by AW Rowse on Tuesday, November 13, 2018 - 3:18pm
AW Rowse's picture

Do you ever move lots of Staff Accounts from one Profile to another? We do! If you use standard Oracle Service Cloud product features it takes a VERY long time. With the standard process you must individually open a Staff Account record, open the assigned Profile modal window, select the Profile, then save and close the record. Imagine if you had to move 20, or 50, or 100 Staff Accounts to a new Profile? That would take FOREVER!

ClickOnce and the CX Launcher

Posted by jack.whitehouse on Tuesday, November 6, 2018 - 12:42pm
jack.whitehouse's picture

Working on some yet to be released features for the CXDev Toolbox I have come across a lot of interesting details around the ClickOnce installer and the CX launcher. This article won’t be relevant to a large number of users, but for those few who are hacking around this is for you.


Zircon - This is a contributing Drupal Theme
Design by WeebPal.