3 Replies Latest reply: Dec 12, 2012 7:12 AM by ryan sullivan2 RSS

    How to use the component Queries Resources in UCM.

    979378
      hi :
      In the component ,I need to use in the database query a value in HTML includes Resources.

      Example query.htm File
      <HTML>
      <HEAD>
      <META HTTP-EQUIV='Content-Type' content='text/html; charset=iso-8859-1'>
      <TITLE>Query Definition Resources</TITLE>
      </HEAD>
      <BODY>
      <@table QueryTable@>
      <table border=1><caption><strong>Query Definition Table</strong></caption>
      <tr>
      <td>name</td>
      <td>queryStr</td>
      <td>parameters</td>
      </tr>
      <tr>
      <td>QdocInfo</td>
      <td>select to_char(sysdate,'YYYY') as sd from dual</td>
      <td></td>
      </tr>
      </table>
      <@end@>
      </BODY>
      </HTML>


      How do I call this query to value?

      thanks.
        • 1. Re: How to use the component Queries Resources in UCM.
          ryan sullivan2
          Were did you get the info to build the html snippet? What steps have you taken to try and get past your block?

          Here's the documentation around the topic:

          http://docs.oracle.com/cd/E23943_01/doc.1111/e10807/c15_create_custom_comp.htm#BABJHJAJ

          Section 15.2.6 reviews how to build a query resource file

          section 15.2.7 shows a service example using a cached query type (CACHE_RESULT_TYPE = 5) . You should be able to follow that example to create the service definition.

          Also, the Bex book (http://tinyurl.com/aaleq57) is a key development resource. In addition to this, you can find the HowToComponents (http://tinyurl.com/c6yzjx5) and they include many simple examples of what you're after.

          -ryan
          • 2. Re: How to use the component Queries Resources in UCM.
            979378
            hi:
            thank you ! but, my question has not been answered yet.I'd like to call Queries resource the query results in HTML resource.
            • 3. Re: How to use the component Queries Resources in UCM.
              ryan sullivan2
              Barring any feedback from my initial set of questions, I'd say that simple answer could be that you use the standard method of executing services via idocscript: 'executeService'.

              As described in the reference material, query resource files are built into services. those services are then set as scriptable and then they are executable by any authorized user via idocscript.

              -ryan