FileHold 17.1 API Documentation
C#
    Show/Hide TOC

      GridFilterSqlGenerator Class

      Definition

      Namespace: FileHold.Common.Grid
      Assembly: FileHold.Common (in FileHold.Common.dll) Version: 17.1.0.0
      C#
      public abstract class GridFilterSqlGenerator
      Inheritance
      Object    GridFilterSqlGenerator
      Derived
      FileHold.DocumentRepository.ModelsStorageGroupsGridSqlGenerator
      FileHold.LibraryManager.GridAgreementsSqlGenerator
      FileHold.LibraryManager.GridAutoFilingGridGenerator
      FileHold.LibraryManager.GridBatchJobsSqlGenerator
      FileHold.LibraryManager.GridDropDownMenuGridSqlGenerator
      FileHold.LibraryManager.GridScriptsSqlGenerator
      FileHold.LibraryManager.GridWatermarkTemplatesSqlGenerator
      FileHold.UserRoleManagerExternalUsersSqlGenerator
      FileHold.UserRoleManager.GridUserListGridSqlGenerator
      FileHold.UserRoleManagerOptionsSqlGenerator
      More Less

      Constructors

      GridFilterSqlGeneratorInitializes a new instance of the GridFilterSqlGenerator class

      Properties

      FilterById 
      IdColumnName 
      IsSelectedColumnName 
      Parameters 
      Request 
      SortById 

      Methods

      AddParameter 
      GenerateWhereClause 
      GetBeforeQuery 
      GetCountSqlQuery 
      GetDefaultOrderBy 
      GetFormatedCTE 
      GetIsSelectedColumn 
      GetLeftJoinWithSelectedValues 
      GetMainQuery 
      GetOrderByClause 
      GetSelectClause 
      GetSelectedValuesCTE 
      GetSqlQuery 
      SelectCount 

      Fields

      EndRowParameter 
      MainCTEName 
      SelectedValuesCTEName 
      StartRowParameter 
      visibledColumns 
      whereClause 

      Extension Methods

      ConvertT
      (Defined by ObjectExtension)
      ToJson
      (Defined by ObjectExtension)

      See Also

      Reference

      FileHold.Common.Grid Namespace

      In This Article

      • Definition
      • Constructors
      • Properties
      • Methods
      • Fields
      • Extension Methods
      • See Also

      © FileHold Systems Inc.