select attributeID,name from tclassextendattributes where
ExtendSetID in(
'#listgetat(arguments.data.extendSetID,s)#',
)
and type != 'File'
delete from #arguments.dataTable#
where baseID=
and attributeID =
insert into #arguments.dataTable# (baseID,attributeID,siteID,attributeValue)
values (
,
,
,
null
)
select attributeID,name from tclassextendattributes where
ExtendSetID in(
'#listgetat(arguments.data.extendSetID,s)#',
)
and type = 'File'
delete from #arguments.dataTable#
where baseID=
and attributeID =
insert into #arguments.dataTable# (baseID,attributeID,siteID,attributeValue)
values (
,
,
,
)
select #arguments.dataTable#.* from #arguments.dataTable#
inner join tclassextendattributes on ( #arguments.dataTable#.attributeID=tclassextendattributes.attributeID)
where
baseID=
and tclassextendattributes.extendSetID not in (
'#listgetat(arguments.data.extendSetID,s)#',
)
insert into #arguments.dataTable# (baseID,attributeID,siteID,attributeValue)
values (
,
,
,
null
)
select #arguments.dataTable#.*, tclassextendattributes.name from #arguments.dataTable#
inner join tclassextendattributes on ( #arguments.dataTable#.attributeID=tclassextendattributes.attributeID)
where
baseID=
and tclassextendattributes.extendSetID in (
'#listgetat(arguments.data.extendSetID,s)#',
)
and type!='File'
insert into #arguments.dataTable# (baseID,attributeID,siteID,attributeValue)
values (
,
,
,
null
)
select #arguments.dataTable#.*, tclassextendattributes.name from #arguments.dataTable#
inner join tclassextendattributes on ( #arguments.dataTable#.attributeID=tclassextendattributes.attributeID)
where
baseID=
and tclassextendattributes.extendSetID in (
'#listgetat(arguments.data.extendSetID,s)#',
)
and type='File'
insert into #arguments.dataTable# (baseID,attributeID,siteID,attributeValue)
values (
,
,
,
null
)
select * from tclassextend
where
siteid=
order by type,subtype
select * from tclassextend
where
siteid=
and type=
order by type,subtype
update tclassextendattributes
set orderno=#a#
where
attributeID=
update tclassextendsets
set orderno=#s#
where
extendSetID=
select #arguments.dataTable#.attributeValue,tclassextendattributes.defaultValue,#arguments.dataTable#.attributeID from tclassextendattributes
left join #arguments.dataTable# ON (tclassextendattributes.attributeID=#arguments.dataTable#.attributeID)
where
#arguments.dataTable#.baseID=
and (
tclassextendattributes.attributeID=
or
tclassextendattributes.name=)
select attributeValue from #arguments.dataTable#
inner join tclassextendattributes on (#arguments.dataTable#.attributeID=tclassextendattributes.attributeID)
where
tclassextendattributes.type='File'
and #arguments.dataTable#.baseid =
and #arguments.dataTable#.attributeValue is not null
delete from #arguments.dataTable# where
baseid =