initCardActionHandler: function() {
                  this.callParent(arguments);
                  var propertyNames = [
                      "isClient"
                  ];
                  this.Terrasoft.each(propertyNames, function(propertyName) {
                      this.on("change:" + propertyName, function(model, value) {
                          this.sandbox.publish("CardChanged", {
                              key: propertyName,
                              value: value
                          }, [this.sandbox.id]);
                      }, this);
                  }, this);
              },

                   public virtual Stream GetReportFile(string key) {
                             var userConnection = (UserConnection)HttpContext.Current.Session["UserConnection"];
                             var reportObj = userConnection.SessionData[key];
                             userConnection.SessionData.Remove(key);
                             ReportData report = reportObj as ReportData;
                             if (report.Format == "pdf") {
                                      WebOperationContext.Current.OutgoingResponse.ContentType = "application/pdf";
                             } else {
                                      WebOperationContext.Current.OutgoingResponse.ContentType = "application/octet-stream";
                             }
                             var reportStream = new MemoryStream(report.Data);
                             WebOperationContext.Current.OutgoingResponse.ContentLength = reportStream.Length;
                             WebOperationContext.Current.OutgoingResponse.Headers.Add("Content-Disposition", "attachment; filename=\"" +

                                                               details: /**SCHEMA_DETAILS*/{
                                                                              EmailDetailV2: {
                                                                                              schemaName: "EmailDetailV2",
                                                                                              filter: {
                                                                                                              masterColumn: "Id",
                                                                                                              detailColumn: "Account"
                                                                                              },
                                                                                              filterMethod: "emailDetailFilter"
                                                                              }
…
 
                                                                              /**
                                                                              * Функция создания фильтров детали email
                                                                              * @protected
                                                                              * @returns {createFilterGroup}
                                                                              */
                                                                              emailDetailFilter: function() {
                                                                                              var recordId = this.get("Id");
                                                                                              var filterGroup = new this.Terrasoft.createFilterGroup();
                                                                                              filterGroup.add("AccountNotNull", this.Terrasoft.createColumnIsNotNullFilter("Account"));
                                                                                              filterGroup.add("AccountConnection", this.Terrasoft.createColumnFilterWithParameter(
                                                                                                                             this.Terrasoft.ComparisonType.EQUAL, "Account", recordId));
                                                                                              filterGroup.add("ActivityType", this.Terrasoft.createColumnFilterWithParameter(
                                                                                                                             this.Terrasoft.ComparisonType.EQUAL, "Type", ConfigurationConstants.Activity.Type.Email));
                                                                                              return filterGroup;
                                                                              },

                               rules: {
                                               "AddressType": {
                                                              "FiltrationAddressTypeByOwner": {
                                                                              ruleType: BusinessRuleModule.enums.RuleType.FILTRATION,
                                                                              autocomplete: true,
                                                                              baseAttributePatch: "ForContact",
                                                                              comparisonType: Terrasoft.ComparisonType.EQUAL,
                                                                              type: BusinessRuleModule.enums.ValueType.CONSTANT,
                                                                              value: true
                                                              }
                                               }
                               },
или NUI/ActivityPage

                                                              /**
                                                              * Подготовка параметров для открытия окна выбора из пользователей.
                                                              * @return {Object} Config настроек окна выбора из справочника.
                                                              */
                                                              prepareLookupConfig: function() {
                                                                              var filters = this.getLookupFilter();
                                                                              var config = {
                                                                                              entitySchemaName: "SysAdminUnit",
                                                                                              multiSelect: true,
                                                                                              columns: ["Contact", "Name"],
                                                                                              hideActions: true,
                                                                                              filters: filters
                                                                              };
                                                                              return config;
                                                              }
 
 
                                                              getLookupFilter: function(isDelegate) {
                                                                              var filters = this.Terrasoft.createFilterGroup();
                                                                              var parentFilter =  this.Terrasoft.createColumnFilterWithParameter(
                                                                                              this.Terrasoft.ComparisonType.EQUAL,
                                                                                              isDelegate ? "GrantorSysAdminUnit.Id" : "GranteeSysAdminUnit.Id",
                                                                                              this.get("MasterRecordId"));
                                                                              var sameIdFilter =  this.Terrasoft.createColumnFilterWithParameter(
                                                                                              this.Terrasoft.ComparisonType.NOT_EQUAL,
                                                                                              "Id",
                                                                                              this.get("MasterRecordId"));
...
                                                                              filters.addItem(sameIdFilter);
                                                                              return filters;
                                                              },

declare @vacancyId uniqueidentifier = '3984d4b1-de5d-405b-b7c6-320b03b0a8ec';
select distinct
	vc.UsrCandidatesId
from UsrVacancyCandidates vc
where
	vc.UsrCandidatesId not in(
		select vc.UsrCandidatesId from UsrVacancyCandidates vc 
		where vc.UsrVacanciesId = @vacancyId
	);

esq.isDistinct = true;
esq.addColumn("UsrCandidatesId");

                SELECT vc.UsrCandidatesId FROM UsrVacancyCandidates vc 
                WHERE vc.UsrVacanciesId = @vacancyId
        );
 
Реализуется через NOT_EQUAL
 
Пример NUI/InFolderDetail
 
var filterGroup = Terrasoft.createFilterGroup();
if (inFolders.length > 0) {
var notInFilter = Terrasoft.createColumnInFilterWithParameters('Id', inFolders);
notInFilter.comparisonType = Terrasoft.ComparisonType.NOT_EQUAL;
filterGroup.addItem(notInFilter);
}

LeadContactsInFolderDetailV2
 
                                                               /**
                                                               * Метод действия "Добавить группу контактов".
                                                               * @private
                                                               */
                                                               addContactFolder: function() {
                                                                              var masterColumnValue = this.get("MasterRecordId");
                                                                              var config = {
                                                                                              entitySchemaName: "ContactFolder",
                                                                                              multiSelect: true,
                                                                                              columns: ["FolderType", "Id"]
                                                                              };
                                                                              var existsFilterGroup = this.Terrasoft.createFilterGroup();
                                                                               existsFilterGroup.addItem(this.Terrasoft.createColumnFilterWithParameter(
                                                                                              this.Terrasoft.ComparisonType.EQUAL, "Contact", masterColumnValue));
                                                                              var existsFilter = this.Terrasoft.createNotExistsFilter("[ContactInFolder:Folder:Id].Contact",
                                                                                              existsFilterGroup);
                                                                              var filterGroup = this.Terrasoft.createFilterGroup();
                                                                              filterGroup.addItem(existsFilter);
                                                                              var folderFilter = this.Terrasoft.createColumnFilterWithParameter(
                                                                                              this.Terrasoft.ComparisonType.EQUAL, "FolderType", ConfigurationConstants.Folder.Type.General);
                                                                              filterGroup.addItem(folderFilter);
                                                                              config.filters = filterGroup;
                                                                              this.openLookup(config, this.addContactCallback, this);
                                                               },

attributes:
{
	"UsrCandidates":
	{
		dataValueType: Terrasoft.DataValueType.LOOKUP,
		lookupListConfig:
		{
			filter: function()
			{
				var vacancy = this.get("UsrVacancies");
				if (!this.Ext.isEmpty(vacancy))
				{
					var filterGroup1 = this.Terrasoft.createFilterGroup();
					var filter1 = this.Terrasoft.createColumnFilterWithParameter(
						this.Terrasoft.ComparisonType.EQUAL,
						"[UsrVacancyCandidates:UsrCandidates].UsrVacancies", vacancy
						.value);
					filterGroup1.addItem(filter1);
					var filterGroup2 = this.Terrasoft.createFilterGroup();
					var filter2 = this.Terrasoft.createNotExistsFilter(
						"[UsrCandidates:Id].Id", filterGroup1);
					filterGroup2.addItem(filter2);
					return filterGroup2;
				}
			}
		}
	},
},

var esqCand = this.Ext.create("Terrasoft.EntitySchemaQuery",
{
		rootSchemaName: "UsrVacancyCandidates"
});
esqCand.addAggregationSchemaColumn("UsrCandStat.Value", Terrasoft.AggregationType.MAX, "Value");

var select = Ext.create("Terrasoft.EntitySchemaQuery", {
                rootSchemaName: "Invoice"     
});
select.addAggregationSchemaColumn("Supplier.Name", Terrasoft.AggregationType.COUNT, "Count");
select.filters.add(select.createColumnFilterWithParameter(
                Terrasoft.ComparisonType.EQUAL, "Supplier.Name", "Test"));
select.getEntityCollection(function(result) {
                if (result.success) {
                               var collection = result.collection;
                               collection.each(function(item) {
                                               console.log(item.get("Count"));
                               }, this);
                }
}, this);