Cacher is the code snippet organizer for pro developers

begin;

set local creativesystems.logged_user to 'system';
set search_path to master;

update config set config_value='0' where config_name IN (
	'Device:CarryOver:DensoRfidChannels',
	'Device:ClickCollect:DensoRfidChannels',
	'Device:CustomerOrder:DensoRfidChannels',
	'Device:CycleCount:DensoRfidChannels',
	'Device:DamagedGoods:DensoRfidChannels',
	'Device:DroppedTag:DensoRfidChannels',
	'Device:InventoryCorrection:DensoRfidChannels',
	'Device:Item:DensoRfidChannels',
	'Device:PackageValidation:DensoRfidChannels',
	'Device:Receiving:DensoRfidChannels',
	'Device:Search:DensoRfidChannels',
	'Device:TransferOut:DensoRfidChannels',
	'Device:WriteOff:DensoRfidChannels'
);

commit;

select config_value 
from master.config 
where config_name IN (
	'Device:CarryOver:DensoRfidChannels',
	'Device:ClickCollect:DensoRfidChannels',
	'Device:CustomerOrder:DensoRfidChannels',
	'Device:CycleCount:DensoRfidChannels',
	'Device:DamagedGoods:DensoRfidChannels',
	'Device:DroppedTag:DensoRfidChannels',
	'Device:InventoryCorrection:DensoRfidChannels',
	'Device:Item:DensoRfidChannels',
	'Device:PackageValidation:DensoRfidChannels',
	'Device:Receiving:DensoRfidChannels',
	'Device:Search:DensoRfidChannels',
	'Device:TransferOut:DensoRfidChannels',
	'Device:WriteOff:DensoRfidChannels'
)
group by config_value;