Activity

From 03/15/2025 to 04/13/2025

04:44 PM Bug #1593: UAT 04042025: DECLARE @REQ_ID VARCHAR(15)
SELECT @REQ_ID = REQ_ID FROM TR_REQUEST_DOC WHERE REQ_CODE = 'PUR/2024/002916'
INSERT d... Luc Tran Van
03:29 PM Bug #1593: UAT 04042025: WITH RankedTrades AS (
SELECT
B.YEAR,
B.DEPT_ID,
B.BRANCH_ID,
DP.DEP_COD... Luc Tran Van
03:15 PM Bug #1593: UAT 04042025: UPDATE dbo.PL_TRADEDETAIL
SET PLAN_ID = 'X' + LEFT(PLAN_ID, LEN(PLAN_ID) - 14)
WHERE LEN(PLAN_ID) > 14 AND PLAN_ID ... Luc Tran Van
02:29 PM Bug #1593: UAT 04042025: DECLARE @REQ_ID VARCHAR(50)
SELECT TOP 1 @REQ_ID = IMP_LOG_CODE FROM dbo.PL_IMPORT_LOG ORDER BY IMP_LOG_ID DESC
SEL... Luc Tran Van
08:55 AM Bug #1593: UAT 04042025: WITH RankedTrades AS (
SELECT
B.YEAR,
B.DEPT_ID,
B.BRANCH_ID,
DP.DEP_COD... Luc Tran Van
08:55 AM Bug #1593 (New): UAT 04042025: Luc Tran Van
08:50 AM Bug #1590: UAT.25.03.2025: SELECT B.YEAR, A.*
FROM dbo.PL_TRADEDETAIL A
INNER JOIN dbo.PL_MASTER B ON B.PLAN_ID = A.PLAN_ID
WHERE TRADE_ID I... Luc Tran Van

01:59 PM Bug #1590: UAT.25.03.2025: SET QUOTED_IDENTIFIER ON
SET ANSI_NULLS ON
GO
ALTER PROCEDURE [dbo].[rpt_PL_REQUEST_FUND_Template]
@p_TR_REQU... Luc Tran Van
11:15 AM Bug #1590: UAT.25.03.2025: WITH NumberedLogs AS (
SELECT
t.TEMPLATE_REQUEST_ID,
t.GROUP_APPROVE,
ROW_NUMBER() O... Luc Tran Van
09:49 AM Feature #1591: SUPPORT EOFFICE 26.03.2025: UPDATE TR_REQ_ADVANCE_PAYMENT SET CREATE_DT_KT ='2025-03-25 8:15:00',APPROVE_DT_KT ='2025-03-25 8:30:00'
WHERE REQ_P... Luc Tran Van
09:47 AM Feature #1591 (New): SUPPORT EOFFICE 26.03.2025: Luc Tran Van

04:34 PM Bug #1590: UAT.25.03.2025: ;WITH LatestSteps AS (
SELECT
REQ_ID,
MAX(STEP_LEVEL) AS MaxStepLevel,
STUFF((
... Luc Tran Van
03:06 PM Bug #1590: UAT.25.03.2025: USE [gAMSPro_BVB_v3_FINAL1]
GO
/****** Object: StoredProcedure [dbo].[CM_REQUEST_TEMPLATE_Search] Script Date: ... Luc Tran Van
01:30 PM Bug #1590: UAT.25.03.2025: DECLARE @REQ_ID NVARCHAR(50)
DECLARE @DistinctSteps INT
DECLARE @TotalRows INT
DECLARE @StepSequence NVARCHAR(MAX)... Luc Tran Van
11:54 AM Bug #1590: UAT.25.03.2025: WITH LatestRecords AS (
SELECT *
FROM [dbo].[CM_APPROVE_GROUP] a
WHERE CREATE_DT = (
SELECT M... Luc Tran Van
11:43 AM Bug #1590: UAT.25.03.2025: -- Bước 1: Lấy các bản ghi có CREATE_DT mới nhất cho mỗi REQ_ID
WITH LatestRecords AS (
SELECT *
FROM [dbo... Luc Tran Van
11:33 AM Bug #1590: UAT.25.03.2025: -- Bước 1: Lấy các bản ghi có CREATE_DT mới nhất cho mỗi REQ_ID
WITH LatestRecords AS (
SELECT *
FROM [dbo... Luc Tran Van
11:31 AM Bug #1590 (New): UAT.25.03.2025: Luc Tran Van
11:00 AM Bug #1586: Support App Mobile: -- Bước 1: Lấy các bản ghi có CREATE_DT mới nhất cho mỗi REQ_ID
WITH LatestRecords AS (
SELECT *
FROM [dbo... Luc Tran Van
10:47 AM Bug #1586: Support App Mobile: WITH StepCheck AS (
SELECT
REQ_ID,
COUNT(*) AS StepCount,
MIN(STEP_LEVEL) AS MinStep... Luc Tran Van

04:37 PM Bug #1586: Support App Mobile: https://testflight.apple.com/join/qEIw6wvh Luc Tran Van

Also available in: Atom

EOFFICE - GD4