1. Tempo Avatar Tempo
  2. Prime
  3. servertimesheet
  4. Issues

Timesheet Holidays

Issue #889 closed
mgorokhova created an issue

Hello, Andriy!

I have several questions about holiday configuration:

  1. I introduced holidays in plugin configuration. Where can I find this information in database? I want use this information in sql-reports. Is information about amount of hours in month is stored in database?

  2. It would be great if field "Total" color on dashboard depended on holidays. Now if time spent in a week equal to 40 hours, color of total is black, independently of holidays.

Thank you!

Comments (23)

  1. Andriy Zhdanov

    Hi Mariya,

    I assume you're referring to http://www.jiratimesheet.com/wiki/Timesheet_Holidays.html

    1. Yes, information is stored in database, in table named like AO_04990F_HOLIDAY, but there are just date name of the holiday stored, and no any amount of hours. All ours are stored in JIRA Worklog table.

    2. There is only per day highlighting, and not for totals, but it might be possible to add, including taking holidays into account, will give a try.

    Thank you.

  2. mgorokhova reporter

    Thank you, Andriy for your answer, but unfortunately I can't find table AO_04990F_HOLIDAY in database. Is it correct name?

    1. It would be great. Thank you!
  3. Andriy Zhdanov

    Hi Mariya,

    The name is not exact, it just starts with AO_ and ends with _HOLIDAY, code in between is different.

    Thank you.

  6. mgorokhova reporter
    • changed status to open

    Hello, Andriy!

    After updating I have some problem - I can't see total hours (total.png). Should I change any settings?

    Thank you!

  8. Andriy Zhdanov

    Hi Maria,

    Sorry, I can't reproduce it. Can you see any error in jira.log? Or could it be related to worklog comment, like in issue#912? Or anything special about the holiday name or value of Highlight Hours option? I've tried 8 and 7.5 values.

    Thank you.

  9. mgorokhova reporter

    Hi, Andriy!

    In log I see this warning:

    /rest/timesheet-gadget/1.0/timesheet.json [com.atlass ian.velocity.DefaultVelocityManager] MethodInvocationException occurred getting message body from Velocity: com.atlassian.activeobjects.internal.ActiveObjectsSq lException: There was a SQL exception thrown by the Active Objects library: Database: - name:PostgreSQL - version:9.3.10 - minor version:3 - major version:9 Driver: - name:PostgreSQL Native Driver - version:PostgreSQL 9.0 JDBC4 (build 801)

    org.postgresql.util.PSQLException: ERROR: column "month" does not exist Position: 74 com.atlassian.activeobjects.internal.ActiveObjectsSqlException: There was a SQL exception thrown by the Active Objects library: Database: - name:PostgreSQL - version:9.3.10 - minor version:3 - major version:9 Driver: - name:PostgreSQL Native Driver - version:PostgreSQL 9.0 JDBC4 (build 801)

    org.postgresql.util.PSQLException: ERROR: column "month" does not exist Position: 74

    Full log in log.txt . I use settings in screenshots.

  11. Andriy Zhdanov

    Hi Mariya,

    Thank you for providing error details.

    I can not try it with Postgres at the moment, and figure out exact problem, so I've tried to workaround it.

    Would it be possible for you to install updated plugin version manually to try if it fixes the problem?

    If so, please download jira-timesheet-plugin-2.9.5.7.jar and install it in Administration - Add-ons - Manage add-ons. Click Upload add-on button on top right and select downloaded plugin jar.

    Thank you.

  12. mgorokhova reporter

    I installed plugin manually, but it didn't solve problem .

    And in mozilla I noticed error with timesheet gadget: if in gadget setting "Number of weeks/months:" is null will be error "in error occured whils rendering this message". Changing number of weeks from null to number solves problem. It's only for information. Maybe somebody will have this problem.

  13. Andriy Zhdanov

    Could you please check that updated version is actually installed? Click Details link in gadget and see version number in footer, it should be 2.9.5.7#1432...

  18. mgorokhova reporter

    Thank you, Andriy! After updating I see total in the gadget. I can test gadget in detail tomorrow.
    I'll write you.

  20. mgorokhova reporter

    Thank you!

    I tested gadget. Works great. It's very usefull feature!

    And last question: What table in database do you use for counting holidays?

    Thank you!

  21. Andriy Zhdanov

    Hi Maria,

    Great, thank you for confirmation.

    Regarding the table name, as I've said earlier, the name is not exact, it just starts with AO_ and ends with _HOLIDAY, code in between is different, so it looks like AO_04990F_HOLIDAY.

    Thank you.

  24. Log in to comment
Assignee
–
Type
task
Priority
minor
Status
closed
Component
Time Sheet report and gadget
Version
2.9
Votes
0
Watchers
1