1、例如:
需要在打印的时候展示单据附件名称,但是直接查询出来的结果在附件表的id自增是不能满足要求,如果按单据展示附件的序号,则需要查询出来附件后,为附件添加附件序号,方便用户查看、统计附件。
sql如下:
select
cast(( @i := @i + 1 ) AS CHAR ) AS 'key',
file.file_name AS file
FROM
fnd_file_doc fil
LEFT JOIN hzero_file.hfle_file file ON fil.uuid = file.attachment_uuid,
( SELECT @i := 0 ) AS i
WHERE
fil.id = {{ EXP_REPORT_HEADER_ID }} --传单据头id
AND fil.uuid != '$'
AND fil.table_name = 'EXP_REPORT_HEADER'
ORDER BY
fil.creation_date ASC