GitHub user swaroopchenchu edited a discussion: DateTime value fetched as null from Apche hop
I see the data exists for a field in CreatedOn in database <img width="1279" height="594" alt="image" src="https://github.com/user-attachments/assets/56a648e4-8982-4f5b-812e-a1a460f814ca"; /> When i preview my query its picking null in those value <img width="1327" height="344" alt="image" src="https://github.com/user-attachments/assets/0c667703-84f6-451e-8e27-e3f16256d3db"; /> But my query is simple fetch from two views SELECT adj.rkn_AccountIdName, adj.rkn_subscriptionIdName, adj.rkn_name, adj.rkn_amount, adj.rkn_action, CASE WHEN adj.rkn_action IS NOT NULL AND adj.rkn_action = 'false' THEN 1.0 ELSE 0.0 END AS rkn_action_new, adj.rkn_approvedByIdName, adj.rkn_AdjustmentTypeId, adj.rkn_AdjustmentCategoryId, adj.CreatedByName, adj.ModifiedByName, adj.CreatedOn, adj.ModifiedOn, adj.rkn_adjustmentRequestId, 2 as inactiveState, 99 as draftState, ? as SPID, CASE WHEN rkn_transactionNumber IS NOT NULL AND rkn_transactionNumber <> '' THEN 'COMPLETED' ELSE 'PENDING_APPROVAL' END AS status FROM rkn_adjustmentrequest adj, Account acc WHERE acc.name = adj.rkn_AccountIdName AND adj.rkn_ServiceProviderId = ? AND acc.rkn_AccountStateCurrent NOT IN ('2', '99') AND rkn_AdjustmentTypeId is not null AND rkn_transactionNumber is not null Any insights are appreciated, thanks GitHub link: https://github.com/apache/hop/discussions/5519 ---- This is an automatically sent email for users@hop.apache.org. To unsubscribe, please send an email to: users-unsubscr...@hop.apache.org
