This is a public Forum  publicRSS

Topic

    Walid Sarkis
    Using currencies with ROQL
    Topic posted August 2, 2016 by Walid SarkisJourneyer 
    46 Views, 2 Comments
    Title:
    Using currencies with ROQL
    Content:

    Is it possible to obtain all currencies from RightNow Desktop Agent while using a querry like Select * from Currency ?

    Answer

     

    • Scott Harwell

      You can query for the named ID MonetaryValue.Currency in the various APIs to get a list of the currencies.  I don't think that the list is directly exposed in ROQL, but you could try to group results from the purchased product object.

      SELECT Price.* FROM PurchasedProduct GROUP BY Currency
      
    • mosh

      Hi,
      Use below method from ConnectPHP

      $fieldVals = RNCPHP\ConnectAPI::getNamedValues("RightNow\\Connect\\v1_3\\AccountSalesSettings", "DefaultCurrency");

      Regards,
      Monish