SQL SERVER环境下修改默认过滤方案

以修改凭证查询的默认过滤方案为例，这里将默认过滤方案中的“科目名称”字段设为隐藏，同时设置“科目全名”字段为显示。其它修改设置可以参考做类似调整。
具体更新凭证查询默认过滤方案的SQL如下：

UPDATE T_BAS_FILTERSCHEME SET FSCHEME='<ListFilterSchemeEntity>
  <SelectEntitySetting>,FBILLHEAD,FENTITY,</SelectEntitySetting>
  <FilterSetting>[]</FilterSetting>
  <SortSetting>[
  {
    "FieldName": "FAccountBookID.FName",
    "SortType": 0
  },
  {
    "FieldName": "FYEAR",
    "SortType": 0
  },
  {
    "FieldName": "FPERIOD",
    "SortType": 0
  },
  {
    "FieldName": "FVOUCHERGROUPID.FName",
    "SortType": 0
  },
  {
    "FieldName": "FVOUCHERGROUPNO",
    "SortType": 0
  }
]</SortSetting>
  <BatchFilterSetting action="setnull" />
  <ColumnSetting>[
  {
    "F": "FAccountBookID_FName",
    "I": 1,
    "V": 0,
    "W": 90,
    "L": false
  },
  {
    "F": "FDATE",
    "I": 2,
    "V": 1,
    "W": 65,
    "L": false
  },
  {
    "F": "FYEAR",
    "I": 3,
    "V": 1,
    "W": 66,
    "L": false
  },
  {
    "F": "FPERIOD",
    "I": 4,
    "V": 1,
    "W": 40,
    "L": false
  },
  {
    "F": "FVOUCHERGROUPID_FName",
    "I": 5,
    "V": 1,
    "W": 56,
    "L": false
  },
  {
    "F": "FVOUCHERGROUPNO",
    "I": 6,
    "V": 1,
    "W": 56,
    "L": false
  },
  {
    "F": "FEXPLANATION",
    "I": 7,
    "V": 1,
    "W": 100,
    "L": false
  },
  {
    "F": "FACCOUNTID_FNumber",
    "I": 8,
    "V": 1,
    "W": 100,
    "L": false
  },
  {
    "F": "FACCOUNTNAME",
    "I": 9,
    "V": 0,
    "W": 66,
    "L": false
  },
  {
    "F": "FAcctFullName",
    "I": 10,
    "V": 1,
    "W": 80,
    "L": false
  },
  {
    "F": "FDETAILID",
    "I": 11,
    "V": 0,
    "W": 66,
    "L": false
  },
  {
    "F": "FCURRENCYID_FName",
    "I": 12,
    "V": 1,
    "W": 80,
    "L": false
  },
  {
    "F": "FEXCHANGERATETYPE_FName",
    "I": 13,
    "V": 0,
    "W": 66,
    "L": false
  },
  {
    "F": "FEXCHANGERATE",
    "I": 14,
    "V": 0,
    "W": 66,
    "L": false
  },
  {
    "F": "FUnitId_FName",
    "I": 15,
    "V": 0,
    "W": 100,
    "L": false
  },
  {
    "F": "FPRICE",
    "I": 16,
    "V": 0,
    "W": 100,
    "L": false
  },
  {
    "F": "FQTY",
    "I": 17,
    "V": 0,
    "W": 100,
    "L": false
  },
  {
    "F": "FAMOUNTFOR",
    "I": 18,
    "V": 1,
    "W": 90,
    "L": false
  },
  {
    "F": "FDEBIT",
    "I": 19,
    "V": 1,
    "W": 90,
    "L": false
  },
  {
    "F": "FCREDIT",
    "I": 20,
    "V": 1,
    "W": 90,
    "L": false
  },
  {
    "F": "FCreatorId_FName",
    "I": 21,
    "V": 0,
    "W": 80,
    "L": false
  },
  {
    "F": "FCHECKERID_FName",
    "I": 22,
    "V": 1,
    "W": 80,
    "L": false
  },
  {
    "F": "FPOSTERID_FName",
    "I": 23,
    "V": 1,
    "W": 80,
    "L": false
  },
  {
    "F": "FCASHIERID_FName",
    "I": 24,
    "V": 0,
    "W": 80,
    "L": false
  },
  {
    "F": "FATTACHMENTS",
    "I": 25,
    "V": 1,
    "W": 40,
    "L": false
  },
  {
    "F": "FBILLNO",
    "I": 26,
    "V": 0,
    "W": 100,
    "L": false
  },
  {
    "F": "FSystemID_FName",
    "I": 27,
    "V": 1,
    "W": 70,
    "L": false
  },
  {
    "F": "FSourceBillKey_FName",
    "I": 28,
    "V": 0,
    "W": 70,
    "L": false
  },
  {
    "F": "FDOCUMENTSTATUS",
    "I": 29,
    "V": 1,
    "W": 70,
    "L": false
  },
  {
    "F": "FINVALID",
    "I": 30,
    "V": 1,
    "W": 70,
    "L": false
  },
  {
    "F": "FISCASHFLOW",
    "I": 31,
    "V": 0,
    "W": 100,
    "L": false
  }
]</ColumnSetting>
  <CustomFilterSetting>&lt;?xml version="1.0" encoding="utf-16"?&gt;&lt;ORMGL_Vouche&gt;&lt;FRadioGroup&gt;2&lt;/FRadioGroup&gt;&lt;/ORMGL_Vouche&gt;</CustomFilterSetting>
  <StatusFilterSetting>[
  {
    "Key": "FPosted",
    "Value": "[all]"
  },
  {
    "Key": "FDOCUMENTSTATUS",
    "Value": "[all]"
  }
]</StatusFilterSetting>
</ListFilterSchemeEntity>'
WHERE FFORMID='GL_VOUCHER' AND FSCHEMENAME='DEFAULT SCHEME' AND FISDEFAULT='1';