Clarity Service Management

Expand all | Collapse all

Jasper Server - Date Items

Jump to Best Answer
  • 1.  Jasper Server - Date Items

    Posted 04-18-2017 03:24 AM
      |   view attached

    Hi,
    I created new domain (in Jasper Server) and I din't find any date items.
    is that right? 

    Thank you for your help



  • 2.  Re: Jasper Server - Date Items

    Posted 04-18-2017 04:34 AM

    Hi jan.pokorny

    I just found a way to date items in casd_cr table ,refer the below screenshot.

    See if this is what you are looking for?

     

     

    Thanks

    Junaid



  • 3.  Re: Jasper Server - Date Items

    Posted 04-18-2017 05:01 AM

    Hi Junaid,
    thank you for your reply.
    I need to create some report with date filter (e.g. open_date).

    I created "New Set". How shall you bring new items?

    Thank you for your help



  • 4.  Re: Jasper Server - Date Items

    Posted 04-20-2017 04:33 AM

    how do you got that Data Set?

    I'm with the same issue than jan.pokorny ...



  • 5.  Re: Jasper Server - Date Items

    Posted 08-15-2017 07:40 AM

    Junaid Bin Ghalib Alhazrami:

    Can You describe practice "How add "date items"?

    Thank you for your help



  • 6.  Re: Jasper Server - Date Items
    Best Answer

    Posted 08-15-2017 09:44 AM

    Hi All,

     

    I sent a private message to Jan on this as well.   If anyone is having this problem, here are the steps to resolve it:

     

    1. Locate the applicationContext-semanticLayer.xml, which should be in the following directory:
    {CABI 6.x Install Directory}\apache-tomcat\webapps\jasperserver-pro\WEB-INF

     

    2. Create a copy of the file and rename it to “backup_ applicationContext-semanticLayer.xml”

     

    3. Open the original file using a text editor, and locate the following section:

     

    <property name="codeToJdbcTypeMapping">
    <map>
    <!-- entry key="<code>" value="<field name>" -->
    <!-- -101 is TIMESTAMP WITH TIME ZONE in Oracle, mapped to TIMESTAMP -->
    <entry key="-101" value="TIMESTAMP"/>

     

    Update the section to add a line as shown here:

     

    <property name="codeToJdbcTypeMapping">
    <map>
    <!-- entry key="<code>" value="<field name>" -->
    <!-- -101 is TIMESTAMP WITH TIME ZONE in Oracle, mapped to TIMESTAMP -->
    <entry key="-101" value="TIMESTAMP"/>
    <entry key="11" value="TIMESTAMP"/>

     

    !!! IMPORTANT NOTE:!!! Steps 4 and 5 are database-specific and only ONE of those two steps needs to be followed. If your CA Service Desk Manager MDB database is running on MS SQL Server, then follow step 4, and skip step 5. If your CA Service Desk Manager MDB database is running on Oracle, then skip step 4, and follow step 5.

     

    4. (FOLLOW THIS ONLY IF YOUR MDB IS RUNNING ON MS SQL SERVER) Next, Locate the following section in the same file:

    <bean class="com.jaspersoft.commons.semantic.dsimpl.DBServerConfig">
    <property name="productName" value="Microsoft SQL Server"/>
    <property name="sqlGenerator" ref="sqlserverGenerator"/>
    </bean>

    Copy and Paste that same section right below it, then change the copied and pasted section as follows:
    <bean class="com.jaspersoft.commons.semantic.dsimpl.DBServerConfig">
    <property name="productName" value="OpenAccess"/>
    <property name="sqlGenerator" ref="sqlserverGenerator"/>
    </bean>

     

    5. (FOLLOW THIS ONLY IF YOUR MDB IS RUNNING ON ORACLE) Next, Locate the following section in the same file:

    <bean class="com.jaspersoft.commons.semantic.dsimpl.DBServerConfig">
    <property name="productName" value="oracle"/>
    <property name="sqlGenerator" ref="oracleSQLGenerator"/>
    </bean>

    Copy and Paste that same section right below it, then change the copied and pasted section as follows:

    <bean class="com.jaspersoft.commons.semantic.dsimpl.DBServerConfig">
    <property name="productName" value="OpenAccess"/>
    <property name="sqlGenerator" ref="oracleSQLGenerator"/>
    </bean>


    6. Save the applicationContext-semanticLayer.xml file

     

    7. Recycle Jasper Server

     

    NOTE:  CA Does NOT support this solution at this time.  You cannot open support cases regarding any issues with using a domain with Jasper for SDM currently.   We are actively working on a project to build a domain, and will announce it here as soon as its officially rolled out.

     

    Thanks,

    Jon I.



  • 7.  Re: Jasper Server - Date Items

    Posted 09-06-2018 11:09 AM

    And to put a Service Desk DURATION field, do you know what is the procedure?



  • 8.  Re: Jasper Server - Date Items

    Posted 11-23-2018 03:45 PM

    I have the same question - how to add field "time_spent" from "alg" table in to report?