Stack Overflow
Stack Overflow

Questions tagged [roql]

The RightNow Object Query Language (ROQL) facility enables you to make queries against the RightNow Cx database (ORACLE).

6 questions
3
votes
2 answers

ROQL Group By Combine Fields

I'm using Oracle RightNow which uses MySQL but can't have nested queries and only a select (pun!) number of commands at my disposal:…
pee2pee
  • 3,619
  • 7
  • 52
  • 133
1
vote
3 answers

Displaying one table data with respect to other table

I'm stuck with this problem. I have 2 tables, Invoice and Invoice_Lines. I want to display my table in such a fashion that Invoice lines should be displayed below their respective Invoices. Here is my code: $queryString = "SELECT * FROM Invoice"; …
hemanth kumar
  • 529
  • 1
  • 6
  • 25
0
votes
0 answers

In operator with one or More negative values not working with API Version 1.4 for Oracle Service Cloud

We have upgraded our application to use API version 1.4 and we observed the following error when ROQL query contains “in operator” with one or more negative values in the “in clause”. If all the values in the in clause are positive then this error…
Venkatesh
  • 1
  • 1
0
votes
1 answer

OSC-CREST-00025 [Bad Request] Bad Request: near "and": syntax error

I try to query Oracle Service Cloud v1.3. When using ROQL with a single WHERE condition it works. But when adding another condition (separated with AND) it complains with: OSC-CREST-00025 [Bad Request] Bad Request: near "and": syntax error URL:…
Slawa
  • 1,141
  • 15
  • 21
0
votes
1 answer

Concat in ROQL Query

I am trying to do a concat in ROQL oracle query. Have tried single pipe, double pipe, +, and concat function. Nothing seems to work. Any help would be much appreciated.
charsi
  • 399
  • 1
  • 5
  • 13
0
votes
1 answer

Query Support (ROQL tabular queries, Query parameters, ROQL tabular queries) not work in oraacle rightnow REST API

I am working on mobile application which is integrate with Oracle RightNow. I am refere latest document of rightnow REST API. Document of rightnow REST API It is work fine in normal request using REST API. But when I am using Query Support. It is…
Kels
  • 674
  • 1
  • 5
  • 21