ServicePRO SDK Help

clsEnumeration..::..hsSqlStatementTwoParam Enumeration

Namespace:  HelpSTAR.PCL.Common
Assembly:  HelpSTAR.PCL.Common (in HelpSTAR.PCL.Common.dll)

Syntax


public enum hsSqlStatementTwoParam
Public Enumeration hsSqlStatementTwoParam

Members


Member nameDescription
hs_2None
hs_2GetChargeByDateAndRepId
hs_2InsertCCUser
hs_2GetCCUserCountByRequestId
hs_2FulltblOptionsForObjectTypeIdAndOptionId
hs_2GetGroupIdByCaptionAndHost
hs_2CheckFieldNoExists
hs_2GetBusinessHoursHolidays
hs_2RepQueueAssign
hs_2DeleteEventByStarwatch
hs_2DeleteForgotPassWord
hs_2DeleteEventPager_Email_History
hs_2DeleteEventForRequester
hs_2GetFollowUpEvent
hs_2FollowUpByUserAndSR
hs_2GetSessionByUserIdAndSessionId
hs_2DeleteOldSessions
hs_2DeleteSessionBySessionIdUserId
hs_2DeleteEventWaitingEndUser
hs_2GetADSFieldAssociationforObject
hs_2GetQueryGroupListByUser
hs_2GetQueryGroupList
hs_2GetNoGroupQueriesbyUserId
hs_2GetCategorysBySearchPhrase
hs_2GetQueueFolderBySearchPhrase
hs_2MetaDataFieldTypeSize
hs_2GetTableRelation
hs_2GetRelateTableAndField
hs_2GetRelatedTables
hs_2GetAssociatedAssetToAnyObject
hs_2GetAttachForRequest
hs_2GetAttachByObjIdAndObjType
hs_2GetAttachListByObjTypeAndObjId
hs_2GetAttachmentsByObjTypeAndObjId
hs_2GetObjectXObjectTypeObjectID
hs_2GetUpdateFolderPath
hs_2UpdateAttachmentDescription
hs_2GetTrusteeSessionKey
hs_2GetEncryptedSessionKey
hs_2AssignQueue
hs_2DeleteRepXQueue
hs_2DeleteFulltblCryptoByUserId
hs_2GetKeyWordByTextAndId
hs_2SetAttachmentVersion
hs_2GetSolutionByProblemType
hs_2GetSolutionByKeyWords
hs_2GetDeletedCategorysByNameAndParent
HS_2GetTemplatesByObjectAndObjectType
hs_2UpdateBusinessDays
hs_2UpdateBusinessHoursHolidays
hs_2InsertBusinessHoursHolidays
hs_2GetNewAlarmsByUserID
hs_2MemoByAuthorLessThanDate
hs_2MemoByAuthorGreaterThanDate
hs_2DeleteAlarmForRIDAndUserID
hs_2DeleteRepQueueREquest
hs_2PriorityObjectCount
hs_2DeletePriorityObject
hs_2GetPriorityXObjectID
hs_2PurchaseOrderViewClosed
hs_2GetFieldsByGroupAndObjectType
hs_2MemoAuthorForRequestIdAndMemoTime
hs_2PurchaseItemsReceived
hs_2PurchaseClosedPOs
hs_2UpdateAuditConfigInActive
hs_2UpdateAuditConfigInUse
hs_2GetViewByNameAndCreator
hs_2UpdateQueryGroup
hs_2DeleteObjectOnlyXObjectTypeObjectID
hs_2UpdateRuleGroup
hs_2UpdateAssociation
hs_2GetHelpStarADSImport
hs_2DeleteHelpStarADSAssociation
hs_2DeleteHelpStarADSImport
hs_2GetWorkStationWithMACAddress
hs_2DeleteEventByObjectID
hs_2UpdateWorkstationHiddenStatus
hs_2UpdateAssetAssociation
hs_2UpdateProductIDForProductAlias
hs_2UpdateProductAliasHiddenStatus
hs_2GetPrivateCustomReportsforUserIdBaseReport
hs_2FullCustomReportsForNameAndID
hs_2GetScheduledEventByObjectID
hs_2UpdateTrustee
hs_2MyReportListByReportType
hs_2MySearchAndPublic
hs_2UpdateMemoState
hs_2UpdateSortType
hs_2GetRelatedUDF
hs_2EnableDisableMailRule
hs_2InsertCategoryBySRTypeId
hs_2HikeLogTableEntry
hs_2UpdateDatabaseMainTable
hs_2UpdateProcessStatus
hs_2GetTemplatesForProcess
hs_2GetProcessXTemplate
hs_2WrkStatLicTblOption
hs_2UpdateWrkStatLicTblOption
hs_2UpdateRuleMailSendStatus
hs_2GetSchedule
hs_2DeleteSchedules
hs_2GetCompanyProduct
hs_2DeleteProcessHierarchyXTemplate
hs_2UpdateCategoryNameById
hs_2ChildAttachmentIdByName
hs_2GetUserViewByType
hs_2GetCustRptsGroupListByUser
hs_2GetCustRptsGroupList
hs_2UpdateCustRptForGroup
hs_2GetRequestsScheduledForToday
hs_2FulltblMemoUnameByRequestId_InlineAttachment
hs_2DeleteUserAdvtRecord
hs_2GetRuleWhereObjectUsed
hs_2GetUserMyViews
hs_2GetAuditComplete
hs_2GetAllProcessHierarchy
hs_2GetThreadNamesForRequest
hs_2DeleteRepXQueAssignHistory
hs_2GetUserLoggedOn
hs_2DeleteEvent
hS_2UpdateCategorySubPath
hs_2UpdateWorkStationName
hs_2UpdateAssetNameForWorkStation
hs_2UpdateAuditHistoryConfig
hs_2GetWorkstationByAllocation
hs_2UpdateUserPrivWithUDR
hs_2DeleteScheduledEventForObject
hs_2GetChargeRateByIdAndRole
hs_2DeleteChargeRate
hs_2DirectlyAssignedQueueToRepSpecDept
hs_2UpdateRecurrenceOnRequest
hs_2NextRunTimeOnSchedule
hs_2GetCustomReportXTemplate
hs_2DeleteCustomReportXTemplate
hs_2UpdateRecurrenceOnReport
hs_2AddAppointmentResource
hs_2UpdateMappingRequestId
hs_2UpdatePatternRecurrenceId
hs_2GetAppointmentByMeetingAndAttendeeId
hs_2AddAndUpdateGroupUser
hs_2DeleteGroupMember
hs_2GetCalendarGroupXuser
hs_2GetAppointmentByRequestId
hs_2GetAttendeesByRequestId
hs_2GetMeetingOrganizer
hs_2SetViewType
hs_2SetViewOverlay
hs_2UpdateMemoType
hs_2GetMeetingXAttendeeByMeetingAndUser
hs_2GetMeetingView
hs_2GetAppointmentView
hs_2GetEmailsForObject
hs_2DeleteMeetingAppointment
hs_2GetAppointmentByMemoUserId
hs_2IsAppointmentInRequest
hs_2IsMeetingInRequest
hs_2GetMeetingActionByMeetingIdAndUserId
hs_2IgnoreMeetingMessage
hs_2DeleteFollowupByMemo
hs_2GetExistingRecurrence
hs_2GetRecurrencePatternId
hs_2SetPatternRecurrenceId
hs_2UpdatePatternRecurrenceIdByMeetingId
hs_2SetScheduleActiveDate
hs_2UpdateRecurrenceId
hs_2DeleteQATItem
hs_2GetQATSettings
hs_2GetFormatTypeForTemplateParameterMemo
hs_2UpdateTemplateGroup
hs_2UpdateRelatedSolution
hs_2FulltblServicerequestHierarchy
hs_2DoesRequestExist
hs_2CurrentMemotblMemoUnameByMemoId
hs_2GetSuggestedSolutionsByReqIdandMemoId
hs_2SetOutlookEntryId
hs_2SetLastModificationTime
hs_2GetAppointmentByGlobalAppointmentId
hs_2GetAppointmentByRecurrenceIndex
hs_2ResetOutlookAction
hs_2GetOutlookAction
hs_2GetFoldersForSupportRep
hs_2GetFoldersForSupportTeam
hs_2MarkUserDirty
hs_2DeleteCurrentAssignments
hs_2InsertNewAssignments
hs_2GetUserEmailByRepIdandFolderId
hs_2GetUserEmailByUserIdandFolderId
hs_2SetOutlookMeetingId
hs_2UpdateRecurrenceOnMessage
hs_2UpdateTeamAssociation
hs_2GetNewAppointmentForStarwatch
hs_2GetOutlookAppointmentByUserId
hs_2GetDeclinedAppointmentByUserId
hs_2GetProposedAppointmentByUserId
hs_2GetOutlookDeletedAppointmentByUserId
hs_2UpdateProcessgroupID
hs_2UpdateDurationOnSchedule
hs_2GetUserEmailByDispatcherandFolderId
hs_2DeleteUDFRoles
hs_2GetRequestInFolderWithThisState
hs_2GetRequestInFolderWithThisStatus
hs_2GetUserTeamAssociation
hs_2TransferNonAdminPermissions
hs_2IsPrivilegedUser
hs_2IsPrivilegedUserTeam
hs_2GetFoldersTemplatesForUser
hs_2GetFoldersTemplatesForTeam
hs_2GetRolesForTreeByUserId
hs_2GetFoldersForTree
hs_2GetPeopleForGridTree
hs_2GetUDFRoles
hs_2CreateAttendeeInOutlook
hs_2GetActionByGlobalId
hs_2GetUserIdForRemovedMembers
hs_2InsertTeamMember
hs_2UpdateNonAdminRolesByFolderId
hs_2UpdateOUId
hs_2RemoveTeamMember
hs_2UpdateDefaultFolderforUser
hs_2UpdateDefaultFolderforUserOption
hs_2GetUserPrivileges
hs_2GetOUBySearchPhrase
hs_2GetNonLicensedOUBySearchPhrase
hs_2GetAllDispatchFoldersBySearchPhrase
hs_2GetDefaultSearchSettings
hs_2GetListItemforDisplay
hs_2DeleteDefaultSearchSettings
hs_2GetAllAssignedSubFolders
hs_2GetAllFoldersPlusAllDispatchesBySearchPhrase
hs_2UpdateClosedRequestWKFId
hs_2GetAllCategorysBySRTypeAndCategoryId
hs_2GetAllRequesterMemoAuthorReps
hs_2GetAssignedTeamAndRepByQueueIdUserId
hs_2SearchEngineMemo
hs_2GetSupportRepRoleAssignedbyUserTeamForSingleOU
hs_2QueueListwithSuppRepRoleByUserTeamForSingleOU
hs_2GetFolderRoleUserTemplatesForSingleOU
hs_2GetTeamAssignment
hs_2GetRepAssignment
hs_2GetUserIdForAddedMembers
hs_2UpdatePatternRecurrenceIdAppointmentId
hs_2CheckIfNoOccurrenceLeft
hs_2UpdateUsersForDeactivatedFolders
hs_2InsertTeamBySRTypeId
hs_2RemoveTeamMembers
hs_2AddTeamMembers
hs_2FulltblMemoUnameByRequestId_InlineAttachment_OffSite
hs_2GetAllAllowedFolderWithRepPrivInnerSect
hs_2GetAllAllowedFolderWithRepPrivTeamInnerSect
hs_2MemoAuthorForRequestIdAndEventTime
hs_2GetFURbySuppRepRoleForSingleOUbyUserTeam
hs_2GetQueueFoldersAndLicensedOUBySearchPhrase
hs_2GetFoldersAndLicensedOUForSupportTeam
hs_2GetFoldersAndLicensedOUForPrivX
hs_2GetSessionMessageByUserAndSessionID
hs_2DeleteOldSessionEntriesByUserIDIncludingWeb
hs_2DoesCategoryBelongToFolder
hs_2GetFollowUpByUserIdFolderID
hs_2GetQuickMessagesByUserIdFolderID
hs_2GetMeetingMessageByUserIdFolderID
hs_2GetAlarmsByRepIdFolderID
hs_2GetAlarmsByUserIdFolderID
hs_2GetMyWorkspaceEmailsByFolderID
hs_2GetMyWorkspaceDocumentsByFolderID
hs_2InsertFolderBySRTypeId
hs_2SetNewDefaultCategory
hs_2GetOUsForPrivilegeX
hs_2GetAllLicensedOUBySearchPhrase
hs_2GetAssignedUserForResponsibilityByQueueIdUserId
hs_2GetRepAssignmentForResponsibility
hs_2GetAllRepsInboxBySearchPhrase
hs_2GetNoRequestAppointmentByMemoUserId
hs_2GetObjectTypes
hs_2GetAllRecurrencePattern
hs_2UpdateAttachmentKeywords
hs_2GetAttachmentHistoryByVersion
hs_2GetAllMappedAppointmentOnlyForObject
hs_2GetAllMappedMeetingForObject
hs_2DeleteMemoByObject
hs_2HasActiveNotification
hs_2UpdateCategoryChangeOU
hs_2GetUsersWaitingForCheckOut
hs_2GetDocumentQuickMessagesByUserIdFolderID
hs_2GetMemoEmails
hs_2GetQuickMessageViewByObjectId
hs_2GetAllCategorysBySRType
hs_2UpdateRequestIdForAppointmentInMemoTable
hs_2UpdateSolutionChangeOU
hs_2GetCategoriesByNameOUId
hs_2GetAttachmentbyCheckoutLocation
hs_2GetAssetDocumentsByAssetId
hs_2GetThreeLatestAppointments
hs_2UpdateSolutionFolder
hs_2GetNoRequestMeetingLinkedToRequestMessageForUserByFolderId
hs_2GetAllUsersByUDRWithPrivX
hs_2CheckUDRHasPrivX
hs_2GetFoldersAndLicensedOUForInQueueViewRep
hs_2GetFoldersAndLicensedOUForInQueueViewTeam
hs_2AddAndDeleteGroupUser
hs_2AddBusinessHourXHoliday
hs_2DeleteBusinessHourXObject
hs_2GetBusinessHourIdByObjectTypeAndObjectId
hs_2IsHolidayOn
hs_2DeleteBusinessHourXHolidayByBusinessHourIdAndHolidayId
hs_2DeleteBusinessHoursHolidays
hs_2GetAllocationByCompanyId
hs_2GetAllocationByOUId
hs_2GetAllocationByUserId
hs_2GetAllocationByAssetId
hs_2GetInventoryAllocationByAssetId
hs_2GetSRSFolderItem
hs_2ChartForNameAndID
hs_2CheckIfUserHasPrivX
hs2_GetUserByLoginAndPassword
hs_2IsUserTeamMember
hs_2QueryGroupAndChildrenByType
hs_2GetProcessListByFolderId
hs_2GetNoGroupChartsbyUserId
hs_2GetPrivateChrtsGroupListByUser
hs_2GetChrtsGroupList
hs_1UpdateChartGroupID
hs_2GetAllTypesWithFieldsInSharedRelation
hs_2GetAllTypesWithFieldsInViewOnlyDBLookupRelation
hs_2GetAttachmentbyId
hs_2UpdateMeetingQueueStatusById
hs_2GetMeetingQueueByEventIdAndLastModifiedTime
hs_2UpdateLastWatermarkByUserId
hs_2GetSyncStateByCalendarFolderId
hs_2GetSyncStateByUserIdAndCalendarFolderId
hs_2GetMyWorkspaceDocumentsByFolderIDCount
hs_2GetAlarmsByRepIdInService
hs_2GetFollowUpByUserIdInService
hs_2GetQuickMessagesByUserIdInService
hs_2GetDocumentQuickMessagesByUserIdInService
hs_2GetMeetingMessageByUserIdInService
hs_2GetAlarmsByRepIdMyResponsibility
hs_2GetFollowUpByUserIdMyResponsibility
hs_2GetQuickMessagesByUserIdMyResponsibility
hs_2GetMeetingMessageByUserIdMyResponsibility
hs_2GetDocumentQuickMessagesByUserIdMyResponsibility
hs_2CheckMaxPickQuotaByQueueId
hs_2GetHelpTopicByGlanceItem
hs_2GetHelpTopicByGlanceItemAndObjectProp
hs_2GetInteractiveHelpKeyWordByTextAndId
hs_2GetInteractiveHelpCategoryByTextAndId
hs_2GetTrainingModuleByObjectType
hs_2GetProcessWhereFieldUsedForNumericTypeUDF
hs_2GetProcessWhereFieldUsedForTextTypeUDF
hs_2GetProcessWhereFieldUsedForDateTimeUDF
hs_2GetAllRequestsInQueueBeforeDate
hs_2GetVerifyAssignedRespUpdateRoleForQueue
hs_2GetProcessWhereFieldUsedForMemoTypeUDF
hs_2GetEndUserRecentRequestUpdates
hs_2GetSupportRepRecentRequestUpdates
hs_2GetAllDeletedQueueFoldersBySearchPhrase
hs_2GetAllAssociatedFolderPlusAllDispatchesWithPrivX
hs_2GetAllTeamsWithNoPrivOnItselfAndUserAndAlreadyAssociatedToTemplate
hs_2GetCategorysByAdvanceFilterCriteria
hs_2GetCustomChartXTemplate
hs_2DeleteCustomChartXTemplate
hs_2UpdateRecurrenceOnChart
hs_2GetCustomQueryXTemplate
hs_2DeleteCustomQueryXTemplate
hs_2UpdateRecurrenceOnQuery
hs_2GetAssociatedOUsOfTypeOrTemplate
hs_2GetAllocationByCompanyIdForCount
hs_2GetAllocationByOUIdForCount
hs_2GetAllocationByUserIdForCount
hs_2GetAllocationByAssetIdForCount
hs_2GetInventoryAllocationByAssetIdForCount
hs_2hsAllDispatchByServiceCenter
hs_2GetApprovalRating
hs_2GetChartsbyUserId
hs_2UpdateUserPasswoed
hs_2PrivUserExceptID
hs_2GetProcessWhereFieldUsedForBITTypeUDF
hs_2UpdateSolutionPublishRequestId
hs_2FullSolultionAndMemoBySID
hs_2GetSolutionRatingReviews
hs_2HasValidPrivilegeForQueue
hs_2FulltblServicerequestHierarchyIncludeLastPublicMemo