mySobek Home   |   Help
Skip Navigation Links.
Expand <a href='https://sobekrepository.org/sobekcm' title='Sobek home page'>Project Home</a>Project Home
Expand <a href='https://sobekrepository.org/help' title='Online user help'>User Help</a>User Help
Expand <a href='https://sobekrepository.org/sobekcm/technical' title='Sobek home page'>Technical Help</a>Technical Help
Expand <a href='https://sobekrepository.org/software' title='Center for downloading all SobekCM-related software'>Download Center</a>Download Center
Training Videos
Collapse <a href='https://sobekrepository.org/codehelp' title='Details on each of the different classes, interfaces, properties, etc..'>Code Details</a>Code Details
Expand <a href='https://sobekrepository.org/codehelp/engineagnosticlayerdbaccess' title='EngineAgnosticLayerDbAccess'>EngineAgnosticLayerDbAccess Namespace</a>EngineAgnosticLayerDbAccess Namespace
Expand <a href='https://sobekrepository.org/codehelp/builder_library' title='SobekCM.Builder_Library'>Builder_Library Namespace</a>Builder_Library Namespace
Expand <a href='https://sobekrepository.org/codehelp/core' title='SobekCM.Core'>Core Namespace</a>Core Namespace
Expand <a href='https://sobekrepository.org/codehelp/engine_library' title='SobekCM.Engine_Library'>Engine_Library Namespace</a>Engine_Library Namespace
Collapse <a href='https://sobekrepository.org/codehelp/library' title='SobekCM.Library'>Library Namespace</a>Library Namespace
Expand <a href='https://sobekrepository.org/codehelp/library/adminviewer' title='SobekCM.Library.AdminViewer'>AdminViewer Sub-Namespace</a>AdminViewer Sub-Namespace
Expand <a href='https://sobekrepository.org/codehelp/library/aggregationviewer' title='SobekCM.Library.AggregationViewer'>AggregationViewer Sub-Namespace</a>AggregationViewer Sub-Namespace
Expand <a href='https://sobekrepository.org/codehelp/library/ckeditor' title='SobekCM.Library.CKEditor'>CKEditor Sub-Namespace</a>CKEditor Sub-Namespace
Expand <a href='https://sobekrepository.org/codehelp/library/citation' title='SobekCM.Library.Citation'>Citation Sub-Namespace</a>Citation Sub-Namespace
Collapse <a href='https://sobekrepository.org/codehelp/library/database' title='SobekCM.Library.Database'>Database Sub-Namespace</a>Database Sub-Namespace
Collapse <a href='https://sobekrepository.org/codehelp/library/database/sobekcm_database' title='SobekCM_Database Class'>SobekCM_Database</a>SobekCM_Database
Constructor
Collapse <span Title='SobekCM_Database Methods' class='SobekSiteMapNoLink' >Methods</span>Methods
Add_Description_Tag
Add_Item_To_User_Folder
Add_Minimum_Builder_Information
Add_Project_Aggregation_Link
Add_Project_DefaultMetadata_Link
Add_Project_Item_Link
Add_Project_Template_Link
Add_User_BibID_Link
Add_User_Item_Link
Admin_Update_Cached_Aggregation_Metadata_Links
Builder_Add_Log_Entry
Builder_Clear_Item_Error_Log
Builder_Expire_Log_Entries
Builder_Get_Error_Logs
Change_Password
Delete_Aggregation_Alias
Delete_Default_Metadata
Delete_Description_Tag
Delete_Icon
Delete_IP_Range
Delete_Item_Aggregation
Delete_Item_From_User_Folder
Delete_Item_From_User_Folders
Delete_Project_Aggregation_Link
Delete_Project_DefaultMetadata_Link
Delete_Project_Item_Link
Delete_Project_Template_Link
Delete_Setting
Delete_Single_IP
Delete_SobekCM_Item
Delete_URL_Portal
Delete_User_Folder
Delete_User_Group
Delete_User_Search
Delete_Web_Skin
Edit_IP_Range
Edit_Single_IP
Edit_URL_Portal
Edit_User_Folder
Expand <a href='https://sobekrepository.org/codehelp/library/database/sobekcm_database/overloads/fda_report_save' title='FDA_Report_Save Method'>FDA_Report_Save Method</a>FDA_Report_Save Method
Get_Aggregation_Build_Log
Get_Aggregation_Change_Log
Get_Aggregation_Statistics_History
Get_Aggregation_User_Permissions
Get_AggregationCode_From_CID
Get_Aggregations_By_ProjectID
Get_All_Groups_First_VID
Get_All_Items_By_AggregationID
Get_All_Users
Get_BibID_VID_From_Identifier
Get_Codes_Item_Aggregations
Get_CollectionList_ReadyToBuild
Get_Folder_Search_Information
Get_Global_User_Permissions
Get_Global_User_Permissions_Aggregations_Links
Get_Global_User_Permissions_Linked_Aggregations
Get_Global_User_Permissions_Submission_Rights
Get_GroupID_From_BibID
Get_IP_Restriction_Range_Details
Get_IP_Restriction_Ranges
Collapse <a href='https://sobekrepository.org/codehelp/library/database/sobekcm_database/overloads/get_item_aggregation_count' title='Get_Item_Aggregation_Count Method'>Get_Item_Aggregation_Count Method</a>Get_Item_Aggregation_Count Method
Get_Item_Aggregation_Count (Int32, Custom_Tracer)
Get_Item_Aggregation_Count (DateTime, Int32, Custom_Tracer)
Get_Item_Aggregation_Count_DateRange
Get_Item_Aggregation_Milestone
Get_Item_List
Get_Item_Restrictions
Get_Item_Statistics_History
Get_ItemID_From_Bib_VID
Get_Metadata_Fields
Get_Metadata_Name_From_MetadataTypeID
Get_Multiple_Volumes
Get_OAI_Data
Get_OAI_Record
Get_OAI_Sets
Get_Page_Item_Count_History
Get_Public_User_Folder
Get_Settings
Get_User_Group
Get_User_Searches
Link_User_To_User_Group
Lookup_Item_By_ItemID
Online_Archived_Space
Reset_User_Password
Save_Aggregation_Alias
Save_Default_Metadata
Expand <a href='https://sobekrepository.org/codehelp/library/database/sobekcm_database/overloads/save_icon' title='Save_Icon Method'>Save_Icon Method</a>Save_Icon Method
Save_Item_Aggregation_Milestone
Save_Project
Save_Serial_Hierarchy
Save_Template
Save_User
Save_User_Group
Save_User_Search
Save_Web_Skin
Set_Aggregation_NewItem_Flag
Set_Item_Main_Thumbnail
Set_Setting
Set_User_Receive_Stats_Email
Set_User_Setting
Statistics_Aggregation_Titles
Statistics_By_Date_Range
Expand <a href='https://sobekrepository.org/codehelp/library/database/sobekcm_database/overloads/test_connection' title='Test_Connection Method'>Test_Connection Method</a>Test_Connection Method
Tivoli_Add_File_Archive_Log
Tivoli_Archive_Complete
Tivoli_Complete_File_Request
Tivoli_Get_Archived_Files
Tivoli_Outstanding_File_Requests
Tivoli_Request_File
Tracking_Delete_Workflow
Tracking_Digital_Acquisition_Complete
Tracking_Get_Aggregation_Private_Items
Tracking_Get_All_Entries_By_User
Tracking_Get_History_Archives
Tracking_Get_Item_Aggregation_Browse
Tracking_Get_Item_Info_from_ItemID
Tracking_Get_Milestone_Report
Tracking_Get_Open_Workflows
Tracking_Get_Scanners_List
Tracking_Get_Users_Scanning_Processing
Tracking_Image_Processing_Complete
Tracking_Items_By_ALEPH_Number
Tracking_Items_By_OCLC_Number
Tracking_Load_Metadata_Update_Complete
Tracking_Load_New_Complete
Tracking_Load_Replacement_Complete
Tracking_Metadata_Exact_Search
Expand <a href='https://sobekrepository.org/codehelp/library/database/sobekcm_database/overloads/tracking_metadata_search' title='Tracking_Metadata_Search Method'>Tracking_Metadata_Search Method</a>Tracking_Metadata_Search Method
Tracking_Multiple_Volumes
Tracking_Online_Submit_Complete
Tracking_Save_New_Workflow
Tracking_Update_List
Tracking_Update_Workflow
Update_Additional_Work_Needed_Flag
Update_Item_Aggregation
Update_SobekCM_User
Update_SobekCM_User_Aggregations
Update_SobekCM_User_DefaultMetadata
Update_SobekCM_User_Group_Aggregations
Update_SobekCM_User_Group_DefaultMetadata
Update_SobekCM_User_Group_Templates
Update_SobekCM_User_Templates
User_Set_Aggregation_Home_Page_Flag
UserName_Exists
View_Tags_By_Aggregation
View_Tags_By_User
Expand <span Title='SobekCM_Database Properties' class='SobekSiteMapNoLink' >Properties</span>Properties
Expand <a href='https://sobekrepository.org/codehelp/library/email' title='SobekCM.Library.Email'>Email Sub-Namespace</a>Email Sub-Namespace
Expand <a href='https://sobekrepository.org/codehelp/library/html' title='SobekCM.Library.HTML'>HTML Sub-Namespace</a>HTML Sub-Namespace
Expand <a href='https://sobekrepository.org/codehelp/library/itemviewer' title='SobekCM.Library.ItemViewer'>ItemViewer Sub-Namespace</a>ItemViewer Sub-Namespace
Expand <a href='https://sobekrepository.org/codehelp/library/localization' title='SobekCM.Library.Localization'>Localization Sub-Namespace</a>Localization Sub-Namespace
Expand <a href='https://sobekrepository.org/codehelp/library/mainwriters' title='SobekCM.Library.MainWriters'>MainWriters Sub-Namespace</a>MainWriters Sub-Namespace
Expand <a href='https://sobekrepository.org/codehelp/library/mysobekviewer' title='SobekCM.Library.MySobekViewer'>MySobekViewer Sub-Namespace</a>MySobekViewer Sub-Namespace
Expand <a href='https://sobekrepository.org/codehelp/library/resultsviewer' title='SobekCM.Library.ResultsViewer'>ResultsViewer Sub-Namespace</a>ResultsViewer Sub-Namespace
Expand <a href='https://sobekrepository.org/codehelp/library/ui' title='SobekCM.Library.UI'>UI Sub-Namespace</a>UI Sub-Namespace
Expand <a href='https://sobekrepository.org/codehelp/library/uploadifive' title='SobekCM.Library.UploadiFive'>UploadiFive Sub-Namespace</a>UploadiFive Sub-Namespace
Expand <a href='https://sobekrepository.org/codehelp/library/webcontentviewer' title='SobekCM.Library.WebContentViewer'>WebContentViewer Sub-Namespace</a>WebContentViewer Sub-Namespace
Expand <a href='https://sobekrepository.org/codehelp/library/aggregationviewbag' title='AggregationViewBag Class'>AggregationViewBag</a>AggregationViewBag
Expand <a href='https://sobekrepository.org/codehelp/library/requestcache' title='RequestCache Class'>RequestCache</a>RequestCache
Expand <a href='https://sobekrepository.org/codehelp/library/resource_web_config_writer' title='Resource_Web_Config_Writer Class'>Resource_Web_Config_Writer</a>Resource_Web_Config_Writer
Expand <a href='https://sobekrepository.org/codehelp/library/sobekcm_assistant' title='SobekCM_Assistant Class'>SobekCM_Assistant</a>SobekCM_Assistant
Expand <a href='https://sobekrepository.org/codehelp/library/static_pages_builder' title='Static_Pages_Builder Class'>Static_Pages_Builder</a>Static_Pages_Builder
Expand <a href='https://sobekrepository.org/codehelp/library/text_search_term_highlighter' title='Text_Search_Term_Highlighter Class'>Text_Search_Term_Highlighter</a>Text_Search_Term_Highlighter
Expand <a href='https://sobekrepository.org/codehelp/resource_object' title='SobekCM.Resource_Object'>Resource_Object Namespace</a>Resource_Object Namespace
Expand <a href='https://sobekrepository.org/codehelp/tools' title='SobekCM.Tools'>Tools Namespace</a>Tools Namespace
MISSING BANNER
Code Details >> Library >> Database >> SobekCM_Database >> Get_Item_Aggregation_Count Method >> Get_Item_Aggregation_Count (DateTime, Int32, Custom_Tracer)

SobekCM_Database.Get_Item_Aggregation_Count Method (DateTime, Int32, Custom_Tracer)



Gets the title, item, and page count for each item aggregation currently and at some previous point of time


Namespace: SobekCM.Library.Database
Assembly: SobekCM_Library (in SobekCM_Library.dll) Version: 4.10.0.0 (4.10.0.0)

Syntax

C#
public static DataTable Get_Item_Aggregation_Count(
	DateTime Date1,
	int Option,
	Custom_Tracer Tracer
)

Parameters

Date1
Type: System..::..DateTime
Date from which to additionally include item count
Option
Type: System..::..Int32
Option tells which items to include ( 0 = completed, 1 = entered with files, 2 = all entered items )
Tracer
Type: SobekCM.Tools..::..Custom_Tracer
Trace object keeps a list of each method executed and important milestones in rendering

Return Value

Type: DataTable
Datatable with all the title, item, and page count for each item aggregation currently and at some previous point of time

Remarks

This calls the 'SobekCM_Item_Count_By_Collection_By_Dates' stored procedure

This is used by the Internal_HtmlSubwriter class

See Also



Version 4.10.0 ( last generated Monday, March 7, 2016 )