Feature #265
openDocument User Permission
Added by Anil KV over 1 year ago. Updated 4 months ago.
70%
Files
| clipboard-202408271133-34doh.png (81.2 KB) clipboard-202408271133-34doh.png | Arathy PS, 08/27/2024 11:33 AM |
Subtasks
Related issues
Updated by Anil KV over 1 year ago
- Status changed from New to Open
- Assignee changed from travvise Admin to Amal Siby
- % Done changed from 0 to 10
-> Table: locking.tbl_doc_user_permission
Updated by Amal Siby over 1 year ago
- Status changed from Open to Coding Started
- Start date changed from 07/19/2023 to 10/26/2023
- % Done changed from 10 to 40
Updated by Amal Siby over 1 year ago
Coding Logic
-------------
1, Gui Change ==> Add ModifiedBy in Grid
2, Don't allow same range of period from And to date.
3, Keep Log while Deleting.
If the item has Deleted Then Show in the grid with red Color And Not Allow Edit and Delete
4, While updating the existing item ( delete it internally, at the same time Insert should be performed, update should not be performed.).
Updated by Amal Siby about 1 year ago
- Status changed from Coding Started to Particialy Coding Done
Log Section is Pending
Updated by Amal Siby about 1 year ago
- Status changed from Particialy Coding Done to Coding Done
- % Done changed from 40 to 60
Updated by unnikannan S about 1 year ago
- Status changed from Coding Done to Reopen Bugs
- % Done changed from 60 to 50
ISSUE FOUNDED
1.ERROR IN UNLOCK
P0001: jsnSqlRes: {"sinSqlCustomStatus" : 1, "strSqlCustomStatusCode" : "ERROR", "strSqlCustomMessage" : "Document User Permission Save Failed", "strSqlCustomErrorType" : "DATABASE_SYSTEM_ERROR", "strSqlCustomErrorCode" : null, "strSqlSysMessage" : "invalid transaction termination", "strSqlSysExceptionDetail" : "", "strSqlSysExceptionHint" : "PL/pgSQL function sp_insert_or_update_doc_user_permission_log(bigint) line 80 at ROLLBACK\nSQL statement \"CALL sp_insert_or_update_doc_user_permission_log(CAST(jsnDocUserPermission>>'binDocUserPermissionId' AS BIGINT)::BIGINT, jsnSqlRes)\"\nPL/pgSQL function sp_insert_or_update_doc_user_permission(jsonb) line 24 at CALL", "binSqlPk" : 9, "binSqlLogPk" : 0, "strSqlDocNo" : null, "dctSqlOtherData" : {"binDocUserPermissionId": "9"}}Add 2.SHOW VALID DOC DATE
Fixed 3.ERROR WHILE UNLOCK WITHOUT DOC NO ADDING (Error converting value {null} to type 'System.DateTime'. Path 'mdlDocUserPermission.dtmLocked', line 1, position 724.)
Updated by Amal Siby about 1 year ago
- Status changed from Reopen Bugs to Reopen Bugs Coding Done
- % Done changed from 50 to 70
Updated by unnikannan S 12 months ago
- Status changed from Reopen Bugs Coding Done to Reopen Bugs
- % Done changed from 70 to 50
- Tested By set to unnikannan S
UI CHANGE
Done 1.Column Items-(SlNo, DocAction, ActionDate&Time, ActionUser, Permission Period, Action Permitted, UpdateType, Remarks, Add
Done 2.NEW SELECT BOX-UPDATE LOCK TYPE (Change Locking Multi Selections)
*Document Update (Default)
*Posting Change Lock
3.User Permission No Log
Done 4.Doc Locking+Doc Lock Log+Doc User Permission Descending Order Data Sort BY Date Wise
Updated by Arathy PS 7 months ago
- File clipboard-202408271133-34doh.png clipboard-202408271133-34doh.png added
- Status changed from Reopen Bugs Coding Done to Reopen Bugs
- % Done changed from 70 to 50
ISSUE FOUND:
Issue in date in the document user permission history
Updated by Augustin Jose 6 months ago
- Status changed from Reopen Bugs to Reopen Bugs Coding Done
- % Done changed from 50 to 70
Not able to reproduce
Updated by Arathy PS 5 months ago
- Status changed from Reopen Bugs Coding Done to Reopen Bugs
- % Done changed from 70 to 50
ISSUE FOUND
----------------------------------------------
1. Full Data from document locking history is showing.
2. Document user permission history is not showing.
3. No translation for action permission, locked, grid title, unlock.
Updated by Arathy PS 4 months ago
- Status changed from Reopen Bugs Coding Done to Reopen Bugs
- % Done changed from 70 to 50
ISSUE FOUND
-------------------------------------------
1. Status not changing when document has given user permission and then locked then again loaded to document user permission.