Datafilesql.ts
Wed Nov 22 2023 11:29:24 GMT+0000 (Coordinated Universal Time)
Saved by
@thanuj
export const deletedLinesSql = (alias: string) => {
return `
(SELECT COUNT(*) AS DELETED_COUNT
FROM SALES_LINE_ITEM
WHERE DELETED = 1 AND DATA_FILE_SID = ${alias}.DATA_FILE_SID
GROUP BY DATA_FILE_SID)
`;
};
//customer sid and data file sid must be sent as arguments, what is alias here?, i think orm framework manages the execution
content_copyCOPY
Comments