4 Replies Latest reply on Feb 11, 2016 9:47 AM by rashedtalukder

    Is There a Custom Query Tool

    roguen

      We're moving from a locally hosted environment to Jive's cloud environment this year.  In our local environment we obviously have a bit more flexibility with the plugin customizations and have a query tool we use pretty often.  One example might be the following:

      select count(*) from jivequestion question

      where

      question.containerid in (2013, 2024, 2025, 2027, 2028, 2029, 2030, 2032, 2031, 2033)

      and question.resolutionstate = 0

      and TO_TIMESTAMP(question.creationdate/ 1000) > TO_TIMESTAMP(20130822000000::text, 'YYYYMMDDHH24MISS')

      Are there any capabilities to query like this in Jive cloud?

      I'm guessing not, but would love to hear some creative workarounds.

        • Re: Is There a Custom Query Tool
          jrlarson

          Hey Roguen Keller, what's up?

           

          To answer your question, there is no direct way to query the DB like you are showing. However, you could probably accomplish the goal through a combination of Jive API calls. You may have to post-process some of the API responses to narrow the results.

           

          The API queries do have some filterability built in that may help with narrowing the search to specific places and date ranges.

           

          I hope you are doing well.