+1 vote

Dear fellow Efficy Developers,

The request Agenda: Self has been optimized in order to lower the response time when displaying the Agenda, but causes troubles when importing actions from the agenda (so not for tasks) in the Timesheet (it just doesn’t work anymore because one value is not gathered).

So we need to modify in the table SYSQUERIES the SQLTEXT value for the record KMASTER=35 and K_DETAIL=1, and put the following value :

[Select]
ACTIONS.K_ACTION
ACTIONS.DONE
ACTIONS.D_BEGIN
ACTIONS.D_END
ACTIONS.PLANNED hidden
ACTIONS.SUBJECT
ACTIONS.D_CHANGE
ACTIONS.MODE
ACTIONS.NATURE
ACTIONS.TRAVELBEFORE
ACTIONS.TRAVELAFTER
ACTIONS.TIMEZONE
ACTIONS.TIMEZONE [TZMODIFIED]
ACTIONS.LOCATION
ACTIONS.USERS
ACTIONS.ALLDAYEVENT
ACTIONS.P_D_BEGIN hidden
ACTIONS.P_D_END hidden
ACTI_PROJ.K_PROJECT
ACTI_PROJ.MAIN hidden

[From]
ACTIONS
ACTIONS ACTI_PROJ complete

[Where]
ACTIONS.P_D_END >= "1/1/2000"
ACTIONS.P_D_BEGIN < "2/1/2000"
<#USERLINK table="ACTIONS" usertable="ACTI_USER" key="K_ACTION" isactiveparam="true" actionstatus="true">
ACTIONS.PLANNED = 1 [fixed]
ACTI_PROJ.MAIN = 1 [fixed]

[Orderby]

[Columns]

Be aware that in the next release there will be changes in the import from the Timesheet, so the field ISCUSTOM=1 should be changed to ISCUSTOM=0 just before the next Database Upgrade.

Geoffrey

closed with the note: information only
asked in 2014 - r6100 (+ r6099) by (659 points)
closed by
1,165 questions
1,423 answers
1,713 comments
325 users