Frequently Used Functions - DBP - Designer Manual

1. A Comprehensive Guide to the Digital Business Platform Designer
2. Technical Support
3. Legal Notices
4. Release Notes 14.0
- 4.1. New Features
- 4.2. Feature Improvements
- 4.3. Fixed Issues
5. BPMS System Requirements
- 5.1. BPMS Server Requirements
  - 5.1.1. 2.1.1 Install IIS with Required Modules
- 5.2. BPMS Designer Machine Requirements and Permissions
- 5.3. End User Browser Requirements and Permissions
6. Installing the System
- 6.1. Installing Modules
7. Frequently Used Functions
- 7.1. Data Manipulation
8. BPMS Designer General Features
- 8.1. Title Bar
- 8.2. Menu Bar
  - 8.2.1. Home Tab
  - 8.2.2. View Tab
- 8.3. Application Tree
- 8.4. Output
- 8.5. System Information
9. Code Items
10. Language Resources
11. Processes
- 11.1. Process Design
- 11.2. Human Activities
  - 11.2.1. Task Types
    - 11.2.1.1. Translation Management
    - 11.2.1.2. Task Type Properties
  - 11.2.2. Dynamic Task Types
- 11.3. Events
  - 11.3.1. Event Properties
12. Forms
- 12.1. List of Forms
  - 12.1.1. Form Properties
    - 12.1.1.1. Form Entity Properties
  - 12.1.2. Form Designer
    - 12.1.2.1. Designer Tab
    - 12.1.2.2. Form Entity Tab
- 12.2. Form Behavior
  - 12.2.1. Form Behavior Properties
- 12.3. Form Categories
  - 12.3.1. Form Category Properties
- 12.4. Form Control Actions
- 12.5. Form Dynamic Parameters
- 12.6. Dropdown Data Sources
  - 12.6.1. Query Editor
    - 12.6.1.1. Dynamic Tab
      - 12.6.1.1.1. Query Executor
    - 12.6.1.2. Static Tab
13. Business Logics
- 13.1. Rules
- 13.2. Actions
- 13.3. Guards
  - 13.3.1. Guard Properties
- 13.4. Code Messages
  - 13.4.1. Code Message Editor
14. Entities
- 14.1. Entity Designer
  - 14.1.1. Add New Entity
    - 14.1.1.1. Add New Attribute
      - 14.1.1.1.1. Data Type Per Form Control
  - 14.1.2. Entity-Relationship Diagram
- 14.2. Key Point Indicators (KPIs)
  - 14.2.1. KPI Properties
- 14.3. KPI BAM
15. Notification
- 15.1. Notification Templates
  - 15.1.1. Template Management
    - 15.1.1.1. Edit and Create Templates
    - 15.1.1.2. Notification Item Properties
- 15.2. Task Data Items
  - 15.2.1. Data Item Properties
    - 15.2.1.1. Template Logic
- 15.3. Info Templates
  - 15.3.1. Edit and define the logic of the template
16. Integration
- 16.1. 10.1 Resources
  - 16.1.1. 10.1.1 Reference
  - 16.1.2. 10.1.2 Web Reference
- 16.2. 10.2 Notification
- 16.3. 10.4 Connections
17. Application Programming Interface (API)
- 17.1. Define a Parameter (AddParameter)
- 17.2. Calling a Rule (CallRule)
- 17.3. Calling Schedule Service (StartJob)
- 17.4. 11.4 Stop Scheduling (StopJob)
- 17.5. 11.5 Sum of two numbers (Arithmetic.Add)
- 17.6. 11.6 Divide two numbers (Arithmetics.Division)
- 17.7. 11.7 Multiply two numbers (Arithmetics.Multiply)
- 17.8. 11.8 Subtract two numbers (Arithmetics.Subtract)
- 17.9. 11.9 Concatenate two Strings (Concat)
- 17.10. 11.10 Search Text (Contains)
- 17.11. 11.11 Add Date (AddDate)
- 17.12. 11.12 Insert current date (CurrentDate) of the DateTime type
- 17.13. 11.13 Add time to date (CurrentDate.Add)
- 17.14. 11.14 Add Day to Date (CurrentDate.AddDays)
- 17.15. 11.15 Add hours to date (CurrentDate.AddHours)
- 17.16. 11.16 Add milliseconds to date (CurrentDate.AddMilliseconds)
- 17.17. 11.17 Add Minute to Date (CurrentDate.AddMinutes)
- 17.18. 11.18 Add months to date (CurrentDate.AddMonths)
- 17.19. 11.19 Add seconds to date (CurrentDate.AddSeconds)
- 17.20. 11.20 Add tick to date (CurrentDate.AddTicks)
- 17.21. 11.21 Add year to date (CurrentDate.AddYears)
- 17.22. 11.22 Compare current date with date (CurrentDate.CompareTo)
- 17.23. 11.23 Take a Date From (CurrentDate.Date)
- 17.24. 11.24 Getting the day out of the date (CurrentDate.Day)
- 17.25. 11.25 Take a day of week (CurrentDate.DayOfWeek)
- 17.26. 11.26 Take a few days from the date (CurrentDate.DayOfYear)
- 17.27. 11.27 Getting the time out of the current date (CurrentDate.Hour)
- 17.28. 11.28 Insert current date (CurrentMiladiDate) in decimal format
- 17.29. 11.29 Insert Current Time (CurrentTime)
- 17.30. 11.30 Difference between two dates (DateDiffGregorian)
- 17.31. 11.31 Insert Day of the Week (DayOfWeek)
- 17.32. 11.32 Convert date decimal to datetime (GetDate)
- 17.33. 11.33 Day of the week (GetDayOfWeekByDate)
- 17.34. 11.34 The day of the week (GetDayOfWeekByNumeric)
- 17.35. 11.35 Sum of 2 times (TimeAdd)
- 17.36. 11.36 Subtraction of 2 time (TimeDiff)
- 17.37. 11.37 Receive Groups (GetAllGroups)
- 17.38. 11.38 Password Comparison (CheckPassword)
- 17.39. 11.39 Assignment to User (AssignStaffToUser)
- 17.40. 11.40 Delete User Assignment (DeleteUserAssignment)
- 17.41. 11.41 Update Unit (UpdateDepartment)
- 17.42. 11.42 Update Group (UpdateGroup)
- 17.43. 11.43 Update Staff (UpdateStaff)
- 17.44. 11.44 Update User (UpdateUser)
- 17.45. 11.45 Insert member in the Group (AddMemberToGroup)
- 17.46. 11.46 Remove member from the Group (RemoveMemberofGroup)
- 17.47. 11.47 Remove User from Group (RemoveMemberOfGroup)
- 17.48. 11.48 Create or Update User (SaveUser)
- 17.49. 11.49 Create or Update an Organizational Unit (saveDepartment)
- 17.50. 11.50 Create or Update Group (saveGroup)
- 17.51. 11.51 Create or Update a Staff (saveStaff)
- 17.52. 11.52 Update User (UpdateUserWithoutPassword)
- 17.53. 11.53 Get current Manager’s ID (ManagersIdOfCurrentStaff)
- 17.54. 11.54 Get a list of current Managers (GetManagersOfCurrentStaff)
- 17.55. 11.55 Get personally identifiable information (GetPrincipal)
- 17.56. 11.56 Get admin ID (GetManager)
- 17.57. 11.57 Get started User Information (MercuryService.StarterUser)
- 17.58. 11.58 Get current User information
- 17.59. 11.59 Get the header side manager information (MercuryService.ManagerOfStarterStaff)
- 17.60. 11.60 Get Started Information (MercuryService.StarterStaff)
- 17.61. 11.61 Getting Starter Side Manager Information (MercuryService.ManagerOfCurrentStaff)
- 17.62. 11.62 Get Current Staff Information (MercuryService.CurrentStaff)
- 17.63. 11.63 Get Managers for User Positions (MercuryService.GetUserManagerByUser)
- 17.64. 11.64 Get Users admin side (MercuryService.GetUserManagerByStaff)
- 17.65. 11.65 Get Group Members (MercuryService.GetUsersByGroupCode)
- 17.66. 11.66 Receive the Organizational Unit (MercuryService.GetDepartmentByStaff)
- 17.67. 11.67 Obtaining Organizational Units for a single User (MercuryService.GetDepartmentByUser)
- 17.68. 11.68 Get the User’s positions (MercuryService.GetUserStaffs)
- 17.69. 11.69 Get the position of the top Manager of one side (MercurySide.GetManagerOfBeforeCEODepartment)
- 17.70. 11.70 Get the post of a higher-level unit manager (MercuryService.GetManagerOfUpperDepartment)
- 17.71. 11.71 Get current User units (MercuryService.CurrentUserDepartment)
- 17.72. 11.72 Get current manager User list (MercuryService.CurrentUserManager)
- 17.73. 11.73 Get current User positions (MercuryService.CurrentUserStaffs)
- 17.74. 11.74 Get Current User (MercuryService.CurrentStaff)
- 17.75. 11.75 Receive admin-side admin ID (MercuryService.GetStaffMangerByStaff)
- 17.76. 11.76 Fetch information from the database (ExecuteQuery)
- 17.77. 11.77 Fetch information from the current database (ExecuteHqlQuery)
- 17.78. 11.78 Get Objects (GetAll)
- 17.79. 11.79 Get the complete object domain (GetDomainObject)
- 17.80. 11.80 Fetch Database Information (ExecuteSqlQuery)
- 17.81. 11.81 Get all database information (ExecuteSqlQueryFromDB)
- 17.82. 11.82 General code tracking system (GenerateTracking)
- 17.83. 11.83 Get Tracking Code (GetTrackingNumber)
- 17.84. 11.84 Send Notification to User (SendByNotification)
- 17.85. 11.85 Send notification to (SendByNotification)
- 17.86. 11.86 Send notification to recipient list (SendByNotification)
- 17.87. 11.87 Send notification to recipient email list (SendByNotification)
- 17.88. 11.88 Send notification to an email (SendByNotification)
- 17.89. 11.89 Create notifications and send to recipients (Send)
- 17.90. 11.90 Create notifications and send to receiver types (Send)
- 17.91. 11.91 Create notifications and send to recipients list (Send)
- 17.92. 11.92 Create a notification and send to recipient email list (Send)
- 17.93. 11.93 Create notification and send to recipient’s email (Send)
- 17.94. 11.94 Send Transaction Type Notice (SendCopy)
- 17.95. 11.95 Event call (RaiseEvent)
- 17.96. 11.96 Call event with specified user (RaiseEvent)
- 17.97. 11.97 Start the process (StartProcess)
- 17.98. 11.98 Start process with the user and the Starter (StartProcess)
- 17.99. 11.99 Start the process automatically (StartProcessOnPersistentObject)
- 17.100. 11.100 Get an object from an entity (GetDomainObject)
- 17.101. 11.101 Create an object from an entity (CreateDomainObject)
- 17.102. 11.102 Create an object from an entity with an identifier (CreateDomainObject)
- 17.103. 11.103 Delete an object from an entity (DeleteDomainObject)
- 17.104. 11.104 Save an object from an entity (SaveDomainObject)
- 17.105. 11.105 Save an object from an object (SaveObject)
- 17.106. 11.106 Get objects of an entity (GetAll)
- 17.107. 11.107 Get Parents Object (GetParentObject)
- 17.108. 11.108 Changing information in the database (CommitTransaction)
- 17.109. 11.109 Get the file from the attachment control (GetFileFromControl)
- 17.110. 11.110 Get the file from the attachment control (GetFile)
- 17.111. 11.111 Search the folder named (GetFolderDefaultForAttachment)
- 17.112. 11.112 Search the folder with the name and id (GetFolderByNameAndParentId)
- 17.113. 11.113 Create folder with name and id (CreateFolderSerialize)
- 17.114. 11.114 Create folder with name and id (CreateFolderSerialize)
- 17.115. 11.115 Get the children of a node (GetAllTreeNodeFromChildObject)
- 17.116. 11.116 Get the children of root (GetAllTreeNodeFromRootObject)
- 17.117. 11.117 Get Tree Roots (GetParentsNode)
- 17.118. 11.118 Get root tree with child object (GetRootObject)
- 17.119. 11.119 Read from excel (ReadOfExcel)
- 17.120. 11.120 Open File or Print (GetWordFormat)
- 17.121. 11.121 Call Web Service Connection (InvokeBPMSService)
- 17.122. 11.122 Calling the Web Service Connection with XMM (InvokeBPMSService)
- 17.123. 11.123 Calling the Web Service with the User and the User (InvokeBPMSService)
- 17.124. 11.124 Calling the Web service with the user and the XML (InvokeBPMSService)
- 17.125. 11.125 X-MEL split into distinct attributes (XmlToProperties)
- 17.126. 11.126 Convert Dictionary to XMM Format (PropertiesToXml)
- 17.127. 11.127 Code Environment
- 17.128. 11.128 Design Environment
18. Business Logic API
- 18.1. Reservation Word
- 18.2. HQL
- 18.3. SQL
- 18.4. User
- 18.5. Rule
- 18.6. Process
- 18.7. Domain
- 18.8. Task
- 18.9. TimeEvent
- 18.10. Notification
- 18.11. Tracking
- 18.12. Data Source
- 18.13. DateTime
- 18.14. Math
- 18.15. Text
- 18.16. Point
19. Attachments
- 19.1. 13.1 Microsoft IIS 6 SSL Compatibility Components
- 19.2. 13.2 Setting Permission For sharing BPMApp Folder.
- 19.3. 13.3 MSDTC Services
  - 19.3.1. 13.3.1 Introduction
  - 19.3.2. 13.3.2 Steps to Configure MSDTC Services
- 19.4. 13.4 Externalizing the web form
20. Troubleshooting
- 20.1. This configuration section cannot be used at this path
- 20.2. Access to the path ‘Rayvarz\BPMS\Temp’ is denied
- 20.3. Not able to access temp files by visual studio
- 20.4. Error in saving web form when there is an attachment
- 20.5. “Invalid Data” Error on deploy any BPM Application

6.1.6. BPMS Scheduler Service

7.1. Data Manipulation

Below are some of the most frequently used features of the program that users should be familiar with:

Data Manipulation

6.1.6. BPMS Scheduler Service

7.1. Data Manipulation

7. Frequently Used Functions