Grid Control – Range Validation - DBP - Designer Manual

1. A Comprehensive Guide to the Digital Business Platform Designer
2. Technical Support
3. Legal Notices
4. Release Notes 14.1
- 4.1. New Features
- 4.2. Feature Improvements
- 4.3. Fixed Issues
  - 4.3.1. Task Handling – Task Name Used When No Title is Provided
- 4.4. Known Limitations
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
- 6.2. Setting Up BPMS Environment
7. Frequently Used Functions
- 7.1. Data Manipulation
- 7.2. Digital Signature Configuration
  - 7.2.1. Step-by-Step Guide for Digital Signatures
  - 7.2.2. Digital Signatures in the Web
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.3.1. Application Tree Context Menu
- 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.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.1.2. Sample Queries
    - 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. Notification Item Properties
- 15.2. Task Data Items
  - 15.2.1. Data Item Properties
- 15.3. Info Templates
  - 15.3.1. Info Template Properties
16. Integration
- 16.1. Resources
  - 16.1.1. Add Reference
  - 16.1.2. Add Web Reference
- 16.2. WebService Connectors
  - 16.2.1. WebService Connector
- 16.3. Connections
  - 16.3.1. Connect to Database
- 16.4. References
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
- 20.6. Application Tree Not Visible
- 20.7. Application Icons Not Visible in Web
- 20.8. Form Access Blocked
- 20.9. Visual Studio – Error When Building Solution

4.2.7.2. Control Caption – Option to Keep Reserved Space

4.2.7.4. Tab Control – Reflect Web Appearance in Designer

Users can now add range validation to date columns in the grid control of the Form Designer.

By selecting a minimum and maximum date value from the date picker, users can ensure that the date values in the column fall within the specified range.

4.2.7.2. Control Caption – Option to Keep Reserved Space

4.2.7.4. Tab Control – Reflect Web Appearance in Designer

4.2.7.3. Grid Control – Range Validation