Timesheet Holidays
Hello, Andriy!
I have several questions about holiday configuration:
-
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?
-
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 (25)
-
-
reporter Thank you, Andriy for your answer, but unfortunately I can't find table AO_04990F_HOLIDAY in database. Is it correct name?
- It would be great. Thank you!
-
Hi Mariya,
The name is not exact, it just starts with AO_ and ends with _HOLIDAY, code in between is different.
Thank you.
-
reporter Thank you, Andriy!
-
- changed status to resolved
-
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!
-
reporter - attached Total.png
-
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.
-
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.
-
reporter - attached Holidays.png
- attached log.txt
- attached TS.png
-
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.
-
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.
-
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...
-
reporter - attached TS.png
Yes, it is 2.9.5.7, but build 1430 : Timesheet Reports and Gadgets Plugin (v2.9.5.7#1430:eb03cd83d5e2)
-
Could you please try jira-timesheet-plugin-2.9.5.7-patched.jar instead.
-
reporter Yes, I see same result: Timesheet Reports and Gadgets Plugin (v2.9.5.7#1430:eb03cd83d5e2)
-
Strange. Please try 2.9.5.8 release then.
-
reporter Thank you, Andriy! After updating I see total in the gadget. I can test gadget in detail tomorrow.
I'll write you. -
Great, have a nice evening :)
-
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!
-
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.
-
- changed status to resolved
-
reporter - changed status to closed
Thank you for answer! I thought that you maybe created table with amount of hours. :)
-
- removed version
Removing version: 2.9 (automated comment)
-
- removed component
Removing component: Time Sheet report and gadget (automated comment)
- Log in to comment
Hi Mariya,
I assume you're referring to http://www.jiratimesheet.com/wiki/Timesheet_Holidays.html
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.
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.