search

omar733 / company-time-sheet

Automatically exported from code.google.com/p/company-time-sheet
0 stars 0 forks source link

TS-TRIGGERS & CHECK CONSTRAINTS #84

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
WRITE TRIGGERS TO UPDATE OLD & NEW VALUE IN TICKLER HISTORY

CONFIGURATION,USERRIGHTS-DIV
REPRT,PROJECT DETAILS-RL

Original issue reported on code.google.com by dhivya.a...@ssomens.com on 5 Sep 2014 at 5:14

GoogleCodeExporter commented 9 years ago

Original comment by dhivya.a...@ssomens.com on 5 Sep 2014 at 5:23

GoogleCodeExporter commented 9 years ago 
started working on report dtls triggers

Original comment by RAJALAKS...@ssomens.com on 5 Sep 2014 at 6:10

GoogleCodeExporter commented 9 years ago 
as per comment no#1 

COMPLETED TRIGGERS TO UPDATE OLD & NEW VALUE IN TICKLER HISTORY FOR REPORT & 
PROJECT DTLS

DRIVE LINK : 
https://drive.google.com/a/ssomens.com/?tab=mo#folders/0B_f0d7mdbV_UZ3pXN24yOW1a
YVU

FILE NAME : TRG_TS_ADMIN_WEEKLY_REPORT_DETAILS_VER_0.1_84_1_05092014.SQL
FILE NAME : TRG_TS_EMPLOYEE_DETAILS_VER_0.1_84_1_05092014.SQL
FILE NAME : TRG_TS_ONDUTY_ENTRY_DETAILS_VER_0.1_84_1_05092014.SQL
FILE NAME : TRG_TS_PROJECT_DETAILS_VER_0.1_84_1_05092014.SQL
FILE NAME : TRG_TS_USER_ADMIN_REPORT_DETAILS_VER_0.1_84_1_05092014.SQL

Original comment by RAJALAKS...@ssomens.com on 5 Sep 2014 at 9:55

GoogleCodeExporter commented 9 years ago 
test the delivery in comment no#3

Original comment by RAJALAKS...@ssomens.com on 5 Sep 2014 at 9:56

GoogleCodeExporter commented 9 years ago 
REFER THIS SS
https://docs.google.com/a/ssomens.com/spreadsheets/d/1W_N9xD5E5ZEIt1Ab7A1V_saXrL
AzKVxkVMH2VKfjElM/edit#gid=1515465227

WRITE CHECK CONSTRAINTS TRIGGERS

1.FIRST PREPARE ERROR MESSAGES & INSERT THAT ERROR MSGS IN ERROR_MSG_CONFIG 
TABLE
2.INSIDE THE TRIGGER ALL ERROR MSGS SHOULD GET FROM ERROR_MSG_CONFIG TABLE

Original comment by dhivya.a...@ssomens.com on 6 Sep 2014 at 4:42

GoogleCodeExporter commented 9 years ago

Original comment by bhavani....@ssomens.com on 6 Sep 2014 at 4:52

GoogleCodeExporter commented 9 years ago 
COMPLETED USER RIGHTS TICKLER UPDATION TRIGGERS

DRIVE 
LINK:https://drive.google.com/a/ssomens.com/?tab=mo#folders/0B_f0d7mdbV_UYzN3Z2c
tYlRkR2M

FILE NAME:TRG_TS_BASIC_ROLE_PROFILE_UPDATE_VER0.1_84_1_06092014.SQL
FILE NAME:TRG_TS_BASIC_MENU_PROFILE_UPDATE_VER0.1_84_1_06092014.SQL
FILE NAME:TRG_TS_ROLE_CREATION_UPDATE_VER_0.1_84_1_05092014.SQL
FILE NAME:TRG_TS_USER_ACCESS_UPDATE_VER0.1_84_1_05092014.SQL
FILE NAME:TRG_TS_USER_MENU_DETAILS_UPDATE_VER0.1_84_1_05092014.SQL

Original comment by dhivya.a...@ssomens.com on 6 Sep 2014 at 6:17

GoogleCodeExporter commented 9 years ago

Original comment by dhivya.a...@ssomens.com on 6 Sep 2014 at 6:17

GoogleCodeExporter commented 9 years ago 
CHECK CONSTRAINTS onhold working on issue 345 comment no#754

Original comment by bhavani....@ssomens.com on 8 Sep 2014 at 9:49

GoogleCodeExporter commented 9 years ago 
AS PER COMMENT #5 BHAVANI WORKING ON TICKLER SP CHECK CONSTRAINTS TRIGGER TASK 
TRANSFER TO RAJA

Original comment by dhivya.a...@ssomens.com on 15 Sep 2014 at 10:48

GoogleCodeExporter commented 9 years ago

Original comment by raja.gun...@ssomens.com on 16 Sep 2014 at 12:40

GoogleCodeExporter commented 9 years ago

Original comment by raja.gun...@ssomens.com on 16 Sep 2014 at 1:30

GoogleCodeExporter commented 9 years ago 
AS PER COMMENT 9 STARTED CHECK CONSTRAINTS FOR USER ADMIN REPORT DETAILS.

Original comment by bhavani....@ssomens.com on 17 Sep 2014 at 5:05

GoogleCodeExporter commented 9 years ago 
AS PER COMMENT NO 10 FINISHED THE CHECK CONSTRAINTS SP TRIGGER FOR EMPLOYEE 
DETAILS AND PROJECT DETAILS

FILE NAME:
SP_TS_TRG_EMPLOYEE_DETAILS_VALIDATION_VER_0.1_84_10_16092014
SP_TS_TRG_PROJECT_DETAILS_VALIDATION_VER_0.1_84_10_17092014
TS_TRG_EMPLOYEE_DETAILS_INSERT_VALIDATION_VER_0.1_84_10_16092014
TS_TRG_EMPLOYEE_DETAILS_UPDATE_VALIDATION_VER_0.1_84_10_16092014
TS_TRG_PROJECT_DETAILS_INSERT_VALIDATION_VER_0.1_84_10_17092014
TS_TRG_PROJECT_DETAILS_UPDATE_VALIDATION_VER_0.1_84_10_17092014

DRIVE LINK:
https://drive.google.com/a/ssomens.com/#folders/0B_f0d7mdbV_UZ3pXN24yOW1aYVU

Original comment by raja.gun...@ssomens.com on 17 Sep 2014 at 7:45

GoogleCodeExporter commented 9 years ago

Original comment by dhivya.a...@ssomens.com on 17 Sep 2014 at 8:52

GoogleCodeExporter commented 9 years ago 
AS PER COMMENT 5 COMPLETED TRIGGER SP FOR USER_ADMIN_REPORT_DETAILS TABLE 
VALIDATION BY REFERING THE FOLLOWING SPREAD SHEET.

SS NAME: CHECK_CONSTRAINTS

SS LINK : 
https://docs.google.com/a/ssomens.com/spreadsheets/d/1W_N9xD5E5ZEIt1Ab7A1V_saXrL
AzKVxkVMH2VKfjElM/edit#gid=1515465227

FOLDER NAME : TS - REPORT PROJECT

DRIVE LINK : 
https://drive.google.com/a/ssomens.com/?tab=mo#folders/0B_f0d7mdbV_UZ3pXN24yOW1a
YVU

FILE NAME : 
1.SP_TS_TRG_USER_ADMIN_REPORT_DETAILS_VALIDATION_VER_0.1_84_5_18092014.SQL
2. TRG_TS_USER_ADMIN_REPORT_DETAILS_INSERT_VALIDATION_VER_0.1_84_5_18092014.SQL
3. TRG_TS_USER_ADMIN_REPORT_DETAILS_UPDATE_VALIDATION_VER_0.1_84_5_18092014.SQL

Original comment by bhavani....@ssomens.com on 18 Sep 2014 at 9:09

GoogleCodeExporter commented 9 years ago

Original comment by dhivya.a...@ssomens.com on 18 Sep 2014 at 9:12

GoogleCodeExporter commented 9 years ago 
CHANGE N REDELIVER THE employee_details updation trigger

refer ss : 
https://docs.google.com/a/ssomens.com/spreadsheets/d/1W_N9xD5E5ZEIt1Ab7A1V_saXrL
AzKVxkVMH2VKfjElM/edit#gid=1571590187

Original comment by RAJALAKS...@ssomens.com on 25 Sep 2014 at 11:59

GoogleCodeExporter commented 9 years ago 
started working as per comment no#18

Original comment by RAJALAKS...@ssomens.com on 25 Sep 2014 at 11:59

GoogleCodeExporter commented 9 years ago 
AS PER COMMENT NO#18 CHANGED THE EMPLOYEE_DETAILS UPDATION TRIGGER

DRIVE LINK : 
https://drive.google.com/a/ssomens.com/?tab=mo#folders/0B_f0d7mdbV_UZ3pXN24yOW1a
YVU

file name : TRG_TS_EMPLOYEE_DETAILS_UPDATE_VER_0.2_84_18_25092014.SQL

Original comment by RAJALAKS...@ssomens.com on 25 Sep 2014 at 12:25

GoogleCodeExporter commented 9 years ago 
test the delivery in comment no#20

Original comment by RAJALAKS...@ssomens.com on 25 Sep 2014 at 12:25

GoogleCodeExporter commented 9 years ago 
WRITE TRIGGERS TO UPDATE OLD & NEW VALUE IN TICKLER HISTORY FOR PROJECT_STATUS 
TABLE

Original comment by RAJALAKS...@ssomens.com on 25 Sep 2014 at 12:28

GoogleCodeExporter commented 9 years ago 
STARTED WORKING AS PER COMMENT NO#22

Original comment by RAJALAKS...@ssomens.com on 25 Sep 2014 at 12:28

GoogleCodeExporter commented 9 years ago 
AS PER COMMENT NO#22 COMPLETED PROJECT_STATUS TABLE TICKLER UPDATION TRIGGERS

DRIVE LINK : 
https://drive.google.com/a/ssomens.com/?tab=mo#folders/0B_f0d7mdbV_UZ3pXN24yOW1a
YVU

FILE NAME : TRG_TS_PROJECT_STATUS_UPDATE_VER_0.1_84_22_25092014.SQL

Original comment by RAJALAKS...@ssomens.com on 26 Sep 2014 at 4:59

GoogleCodeExporter commented 9 years ago

Original comment by dhivya.a...@ssomens.com on 27 Sep 2014 at 6:48

GoogleCodeExporter commented 9 years ago 
UPDATE ABSENT_FLAG IN USER-ADMIN_REPORT_DETAILS TABLE TICKLER UPDATION TRIGGER

Original comment by dhivya.a...@ssomens.com on 27 Sep 2014 at 6:49

GoogleCodeExporter commented 9 years ago 
in USER ADMIN REPORT DETAILS  check , while enter project id, check the project 
start date,(report date> project start date) check in check contraints.

Original comment by SAFIYULL...@ssomens.com on 27 Sep 2014 at 6:56

GoogleCodeExporter commented 9 years ago 
STARTED WORKING AS PER COMMENT NO#26

Original comment by RAJALAKS...@ssomens.com on 27 Sep 2014 at 7:03

GoogleCodeExporter commented 9 years ago 
AS PER COMMENT NO#26 ADDED ABSENT_FLAG IN USER-ADMIN_REPORT_DETAILS TABLE 
TICKLER UPDATION TRIGGER 

DRIVE LINK : 
https://drive.google.com/a/ssomens.com/?tab=oo#folders/0B_f0d7mdbV_UZ3pXN24yOW1a
YVU

FILE NAME : TRG_TS_USER_ADMIN_REPORT_DETAILS_UPDATE_VER_0.2_84_26_27092014.SQL

Original comment by RAJALAKS...@ssomens.com on 27 Sep 2014 at 7:18

GoogleCodeExporter commented 9 years ago 
TEST THE DELIVERY IN COMMENT NO#29

Original comment by RAJALAKS...@ssomens.com on 27 Sep 2014 at 7:20

GoogleCodeExporter commented 9 years ago 
IMPLEMENT CHECK CONSTRAINTS IN USER_ADMIN_REPORT_DETAILS
BW cant be greater thn 1000 MB

Original comment by dhivya.a...@ssomens.com on 29 Sep 2014 at 4:22

GoogleCodeExporter commented 9 years ago

Original comment by dhivya.a...@ssomens.com on 29 Sep 2014 at 4:47

GoogleCodeExporter commented 9 years ago 
IMPLEMENTED CHECK CONSTRAINTS IN USER-ADMIN_REPORT_DETAILS AS PER CMT #31 & #27

DRIVE 
LINK:https://drive.google.com/a/ssomens.com/?tab=mo#folders/0B_f0d7mdbV_UZ3pXN24
yOW1aYVU

FILE 
NAME:SP_TS_TRG_USER_ADMIN_REPORT_DETAILS_VALIDATION_VER_0.2_84_27_31_29092014.SQ
L

Original comment by dhivya.a...@ssomens.com on 29 Sep 2014 at 7:26

GoogleCodeExporter commented 9 years ago 
TEST THE DELIVERY IN THE COMMENT #33

Original comment by dhivya.a...@ssomens.com on 29 Sep 2014 at 7:27

GoogleCodeExporter commented 9 years ago 
ISSUE FOUND WHILE INSERTING VALUES IN EMPLOYEE_DETAILS TABLE 

DESIGNATION DATATYPE VARCHAR(50) BUT IN CHECK CONSTRAINT SP PUT AS VARCHAR(20) 
SO WHILE INSERTING Data too long for column 'DESIGNATION' ERROR WILL CUM

TASK OWNER :RL

Original comment by RAJALAKS...@ssomens.com on 5 Nov 2014 at 11:10

GoogleCodeExporter commented 9 years ago 
STARTED WORKING AS PER COMMENT NO#35

Original comment by RAJALAKS...@ssomens.com on 5 Nov 2014 at 11:10

GoogleCodeExporter commented 9 years ago 
AS PER COMMENT NO#36 

ISSUE FIXED IN EMPLOYEE_DETAILS CHECK CONSTRAINT SP

DRIVE LINK : 
https://drive.google.com/a/ssomens.com/?tab=mo#folders/0Bwv4Rd7ZecjPTUloOXgwOVhO
dFU

FILE NAME : SP_TS_TRG_EMPLOYEE_DETAILS_VALIDATION_VER_0.2_84_35_05112014.SQL

Original comment by RAJALAKS...@ssomens.com on 5 Nov 2014 at 11:28

GoogleCodeExporter commented 9 years ago 
TEST THE DELIVERY IN COMMENT NO#37

Original comment by RAJALAKS...@ssomens.com on 5 Nov 2014 at 11:28

GoogleCodeExporter commented 9 years ago 
tested delivery in the comment #37 employee_details validation trigger working 
fine..

Original comment by dhivya.a...@ssomens.com on 14 Nov 2014 at 10:15

GoogleCodeExporter commented 9 years ago 
WRITE TRIGGERS TO UPDATE OLD & NEW VALUE IN TICKLER HISTORY FOR EMAIL TEMPLATE 
DETAILS TABLE

Original comment by RAJALAKS...@ssomens.com on 22 Nov 2014 at 6:15

GoogleCodeExporter commented 9 years ago 
STARTED WORKING AS PER COMMENT NO#40

Original comment by RAJALAKS...@ssomens.com on 22 Nov 2014 at 6:16

GoogleCodeExporter commented 9 years ago 
AS PER COMMENT NO#40 COMPLETED EMAIL_TEMPLATE_DTLS UPDATION TRIGGER

DRIVE LINK : 
https://drive.google.com/a/ssomens.com/?tab=mo#folders/0Bwv4Rd7ZecjPNzRpMFRfc2xj
OFk

FILE NAME : TRG_TS_EMAIL_TEMPLATE_DETAILS_UPDATE_VER_0.1_84_40_22112014.SQL

Original comment by RAJALAKS...@ssomens.com on 22 Nov 2014 at 6:34

GoogleCodeExporter commented 9 years ago 
TEST THE DELIVERY IN COMMENT NO#42

Original comment by RAJALAKS...@ssomens.com on 22 Nov 2014 at 6:34