geninsert SELECT * FROM t_die_templatefolder where FLongNumber LIKE '%eas!001%' --组别
geninsert SELECT * FROM t_die_template where FParentFolderID in (SELECT fid FROM t_die_templatefolder where FLongNumber LIKE '%eas!001%' )
geninsert SELECT * FROM t_die_templatefieldentry where FPARENTID in (SELECT fid FROM t_die_template where FParentFolderID in (SELECT fid FROM t_die_templatefolder where FLongNumber LIKE '%eas!001%' ) )
update t_die_templatefieldentry set FIsAutoMapping=1 where FPARENTID='jRQAAAAEEy5HdV6z' ---拍租
update t_die_templatefieldentry set FIsAutoMapping=1 where FPARENTID='jRQAAAAF66JHdV6z' ---招商
EAS引入引出模板导出语句
于 2022-01-19 14:55:38 首次发布