Nama ERP Data ModelNama ERP Data Model
Modules
Search
Namasoft.com
Documentation
GitHub
Modules
Search
Namasoft.com
Documentation
GitHub
  • DashBoardWidgetWizard

DashBoardWidgetWizard

Arabic: أداة إنشاء عنصر لوحة English: Dashboard Widget Wizard

fields (DashBoardWidgetWizardFieldLine) , parameters (DashBoardWidgetWizardParameterLine) , securityConstraints (DashBoardWidgetWizardSecurityConstraints) , sortFields (DashBoardWidgetWizardSortFieldLine) , unionTables (DashBoardWidgetWizardUnionTablesLine) , userAliases (DashBoardWidgetWizardUserAliasesLine) , whereLines (DashBoardWidgetWizardWhereLine)

Fields

Property
Column
Arabic
English
Type
Foreign Table
analysisSet
analysisSet_id
المجموعة التحليلية
Analysis set

Reference

AnalysisSet

analysisSetId
analysisSet_id

ID

branch
branch_id
الفرع
Branch

Reference

Branch

branchId
branch_id
Branch ID
Branch ID

ID

code
code
الكود
Code

Text

colorCode
colorCode
كود اللون
Color Code

Color

commitedBefore
commitedBefore
تم الحفظ مسبقا
Commited Before

Boolean

createTransactionId
createTransactionId

Text

createdDashboardWidget
createdDashboardWidget_id
عنصر اللوحة المُنشأ
Created DashBoard Widget

Reference

DashBoardWidget

creationDate
creationDate
تاريخ الإنشاء
Creation Date

DateAndTime

currentApprovalCase
currentApprovalCase_id

ApprovalCase

currentVersion
currentVersion
النسخة الحالية
Current Version

Integer

customViewName
customViewName

Text

date1
date1
تـــاريخ 1
Date 1

Date

date2
date2
تـــاريخ 2
Date 2

Date

date3
date3
تاريخ 3
Date3

Date

date4
date4
تاريخ 4
Date4

Date

date5
date5
تاريخ 5
Date5

Date

department
department_id
الإدارة
Department

Reference

Department

departmentId
department_id

ID

description1
description1
الوصف 1
description1

Text

description2
description2
الوصف 2
description2

Text

description3
description3
الوصف 3
description3

Text

description4
description4
الوصف 4
description4

Text

description5
description5
الوصف 5
description5

Text

docCategory
docCategory_id
تصنيف سجل
Record Category

Reference

DocCategory

documentFileStatus
documentFileStatus
حالة المستند
Document File Status

DocumentFileStatus

draftCreated
draftCreated
تم إنشاء مسودة
Draft Created

Boolean

draftXML
draftXML

BigText

editedBy
editedBy_id
بواسطة
Edited By

Reference

NaMaUser

entitySystemEntryId
entitySystemEntry_id

ID

entityType
entityType
النوع
Entity Type

EntityType

finalStaticDeclareStatements
finalStaticDeclareStatements
Final Static Declare Statements
Final Static Declare Statements

BigText

finalStaticHavingCondition
finalStaticHavingCondition
Final Static Having Condition
Final Static Having Condition

BigText

finalStaticWhereCondition
finalStaticWhereCondition
Final Static Where Condition
Final Static Where Condition

BigText

firstAuthor
firstAuthor_id
منشئ السجل
First Author

Reference

NaMaUser

firstAuthorId
firstAuthor_id

ID

generatedByLine
generatedByLine
كود سطر الإنشاء
generated By Line

Text

generatedDocsCount
generatedDocsCount

Integer

generatedFrom
generatedFromActualCode, generatedFromCode, generatedFromEntityType, generatedFromId
تم إنشاؤه من
Generated From

Genericreference

generationType
generationType
نوع الإنشاء
Generation Type

GenerationType

group
group_id
المجموعة
Group

Reference

MasterGroup

htmlArabic
htmlArabic
HTML Arabic
HTML Arabic

BigText

htmlEnglish
htmlEnglish
HTML English
HTML English

BigText

id
id

ID

indexInParent
indexInParent

Integer

lastChangeVersion
lastChangeVersion

Integer

lastModifyTransactionId
LastModifyTransactionId

Text

lastUpdateDate
lastUpdateDate
تاريخ اخر تحديث
Last update Date

DateAndTime

legalEntity
legalEntity_id
الشركة
Legal Entity

Reference

LegalEntity

legalEntityId
legalEntity_id

ID

lockVersion
lockVersion

Integer

mainFile
mainFile_id

Binary

LargeData

mainTable
mainTable
الجدول الرئيسي
Main Table

FieldID

n1
n1
رقم 1
Number 1

Decimal

n2
n2
رقم 2
Number 2

Decimal

n3
n3
رقم 3
Number 3

Decimal

n4
n4
رقم 4
Number 4

Decimal

n5
n5
رقم 5
Number 5

Decimal

name1
name1
الاسم العربي
Name1

Text

name2
name2
الاسم الإنجليزي
Name2

Text

parentCode
parentCode

Text

pivotOpenByDefault
pivotOpenByDefault
فتح المحور افتراضياً
Pivot Open by Default

Boolean

preventUsage
preventUsage
منع الاستعمال
Prevent Usage

Boolean

printCount
printCount
عدد مرات الطباعة
Print Count

Integer

ref1
ref1ActualCode, ref1Code, ref1EntityType, ref1Id
مرجع 1
Reference 1

Genericreference

ref2
ref2ActualCode, ref2Code, ref2EntityType, ref2Id
مرجع 2
Reference 2

Genericreference

ref3
ref3ActualCode, ref3Code, ref3EntityType, ref3Id
مرجع 3
Reference 3

Genericreference

ref4
ref4ActualCode, ref4Code, ref4EntityType, ref4Id
مرجع 4
Reference 4

Genericreference

ref5
ref5ActualCode, ref5Code, ref5EntityType, ref5Id
مرجع 5
Reference 5

Genericreference

remarks
remark
ملاحظات
Description

BigText

reviseLevel
reviseLevel
مستوى المراجعة
Revise Level

ReviseLevel

revised
primitiveValue
تمت المراجعة
Revised

Boolean

revisedBy
revisedBy_id

Reference

NaMaUser

sector
sector_id
القطاع
Sector

Reference

Sector

sectorId
sector_id

ID

selectQueryPartPrefix
selectQueryPartPrefix
Select Query Part Prefix
Select Query Part Prefix

BigText

sqlQuery
sqlQuery
SQL Query
SQL Query

BigText

staticDeclareStatements
staticDeclareStatements
Static Declare Statements
Static Declare Statements

BigText

staticHavingCondition
staticHavingCondition
Static Having Condition
Static Having Condition

BigText

staticWhereCondition
staticWhereCondition
Static Where Condition
Static Where Condition

BigText

systemGeneratedCodePrefix
systemGeneratedCodePrefix
System Generated Code Prefix
System Generated Code Prefix

Text

tableType
tableType
Table Type
Table Type

TableType

type
type
النوع
Type

DashBoardElementType

updateCapability
updateCapability_id
صلاحية التعديل
Update Capability

Reference

SecurityCapability

updateCapabilityId
updateCapability_id

ID

usageCapability
usageCapability_id
صلاحية الاستخدام
Usage Capability

Reference

SecurityCapability

usageCapabilityId
usageCapability_id

ID

viewCapability
viewCapability_id
صلاحية المطالعة
View Capability

Reference

SecurityCapability

viewCapabilityId
viewCapability_id

ID

fields (الحقول - Fields)

Table Name: DashBoardWidgetWizardFieldLine, Join Column: dashBoardWidgetWizard_id

Property
Column
Arabic
English
Type
Foreign Table
fields.arabicTitle
arabicTitle
العنوان بالعربية
Arabic Title

Text

fields.barcodeType
barcodeType
نوع الباركود
Barcode Type

BarcodeType

fields.chartUsageType
chartUsageType
نوع الاستعمال في الرسم البياني
Chart Usage Type

ChartColumnUsage

fields.conditionalStyleGrid
conditionalStyleGrid
رقم جدول التنسيق الشرطي
Conditional Style Grid

Integer

fields.configuration
configuration
Configuration
Configuration

BigText

fields.currencyField
currencyField
حقل العملة
Currency Field

FieldID

fields.customHyperLinkExpression
customHyperLinkExpression
Custom Hyper Link Expression
Custom Hyper Link Expression

BigText

fields.customJasperExpression
customJasperExpression
Custom Jasper Expression
Custom Jasper Expression

BigText

fields.customPattern
customPattern
Custom Pattern
Custom Pattern

Text

fields.customSqlExpression
customSqlExpression
Custom SQL Expression
Custom SQL Expression

BigText

fields.displayAttachmentAsImage
displayAttachmentAsImage
إظهار المرفق كصورة في التقرير
Display Attachment As Image

Boolean

fields.displayFieldAs
displayFieldAs
إظهار الرقم كـ
Display Number As

DisplayNumberAs

fields.displayReferenceAs
displayReferenceAs
إظهار المرجع كـ
Display Reference As

DisplayReferenceAs

fields.doNotAddLinkToReferences
doNotAddLinkToReferences
عدم إضافة لينك للمرجع
Do Not Add Link To References

Boolean

fields.englishTitle
englishTitle
العنوان بالإنجليزية
English Title

Text

fields.fieldId
fieldId
الحقل
On Field

FieldID

fields.fieldMetadata
fieldMetadata

BigText

fields.fieldWidth
fieldWidth
العرض
Width

Decimal

fields.finalHyperLinkExpression
finalHyperLinkExpression
Final Hyper Link Expression
Final Hyper Link Expression

BigText

fields.finalJasperExpression
finalJasperExpression
Final Jasper Expression
Final Jasper Expression

BigText

fields.finalSqlExpression
finalSqlExpression
Final Sql Expression
Final Sql Expression

BigText

fields.hasTotalInSummary
hasTotalInSummary
تجميع في الإجماليات
Has Total In Summary

Boolean

fields.hidden
hidden
إخفاء
Hidden

Boolean

fields.id
id

ID

fields.lineNumber
lineNumber

Integer

fields.mainFieldId
mainFieldId
الحقل الرئيسي (في حالة حقل بديل لحقل)
Main Field Id (In Case Alternative Field)

Text

fields.mergedArabicTitle
mergedArabicTitle
Merged Arabic Title
Merged Arabic Title

Text

fields.mergedEnglishTitle
mergedEnglishTitle
Merged English Title
Merged English Title

Text

fields.namaFieldType
namaFieldType
Field Type
Field Type

Text

fields.namaId
namaId
Nama Id
Nama Id

Text

fields.paramName
paramName
اسم المُدخل
Parameter Name

Text

fields.patternField
patternField
Pattern Field
Pattern Field

FieldID

fields.patternType
patternType
Pattern Type
Pattern Type

PatternType

fields.pivotColumnType
pivotColumnType
نوع عمود المحور
Pivot Column Type

PivotColumnType

fields.referenceOrderBy
referenceOrderBy
ترتيب المرجع بـ
Reference Order By

ReferenceOrderBy

fields.showRunningTotalInsteadOfValue
showRunningTotalInsteadOfValue
إظهار الإجمالي الحالي في التفاصيل بدلا من القيمة
Show Running Total Instead Of Value

ShowRunningTotalInsteadOfValue

fields.showTotalInGroup1Section
showTotalInGroup1Section
Show Total In Group 1 Section
Show Total In Group 1 Section

GroupSection

fields.showTotalInGroup2Section
showTotalInGroup2Section
Show Total In Group 2 Section
Show Total In Group 2 Section

GroupSection

fields.showTotalInGroup3Section
showTotalInGroup3Section
Show Total In Group 3 Section
Show Total In Group 3 Section

GroupSection

fields.showTotalInGroup4Section
showTotalInGroup4Section
Show Total In Group 4 Section
Show Total In Group 4 Section

GroupSection

fields.showTotalInGroup5Section
showTotalInGroup5Section
Show Total In Group 5 Section
Show Total In Group 5 Section

GroupSection

fields.sqlAggregationType
sqlAggregationType
SQL Aggregation Type
SQL Aggregation Type

SqlAggregationType

fields.sqlColumns
sqlColumns

Text

fields.style
style_id
Style
Style

Reference

ReportStyle

fields.summaryConditionalStyleGrid
summaryConditionalStyleGrid
رقم جدول التنسيق الشرطي للإجماليات
Summary Conditional Style Grid

Integer

fields.summaryStyle
summaryStyle_id
Summary Style
Summary Style

Reference

ReportStyle

fields.totalPosition
totalPosition
Total Position
Total Position

TotalPosition

fields.type
type
النوع
Type

WizardFieldType

fields.unionHandling
unionHandling
Union Handling
Union Handling

BigText

fields.userAlias
userAlias
User Alias
User Alias

Text

fields.widthSize
widthSize
مقاس العرض
Width Size

GridSizeEnum

parameters (المدخلات - Parameters)

Table Name: DashBoardWidgetWizardParameterLine, Join Column: dashBoardWidgetWizard_id

Property
Column
Arabic
English
Type
Foreign Table
parameters.allowedValues
allowedValues
القيم المسموح بها
Allowed Values

BigText

parameters.allowedValuesAr
allowedValuesAr
Arabic Allowed Values
Arabic Allowed Values

BigText

parameters.allowedValuesEn
allowedValuesEn
English Allowed Values
English Allowed Values

BigText

parameters.arabicTitle
arabicTitle
العنوان بالعربية
Arabic Title

Text

parameters.barcodeType
barcodeType
نوع الباركود
Barcode Type

BarcodeType

parameters.conditionalStyleGrid
conditionalStyleGrid
رقم جدول التنسيق الشرطي
Conditional Style Grid

Integer

parameters.configuration
configuration
Configuration
Configuration

BigText

parameters.currencyField
currencyField
حقل العملة
Currency Field

FieldID

parameters.customHyperLinkExpression
customHyperLinkExpression
Custom Hyper Link Expression
Custom Hyper Link Expression

BigText

parameters.customJasperExpression
customJasperExpression
Custom Jasper Expression
Custom Jasper Expression

BigText

parameters.customPattern
customPattern
Custom Pattern
Custom Pattern

Text

parameters.customSqlExpression
customSqlExpression
Custom SQL Expression
Custom SQL Expression

BigText

parameters.defaultValue
defaultValue
القيمة الافتراضية
Default Value

Text

parameters.defaultValueDate
defaultValueDate
القيمة الافتراضية لحقل التاريخ
Date Default Value

Date

parameters.defaultValueDateTime
defaultValueDateTime
القيمة الافتراضية لحقل التاريخ والوقت
Date And Time Default Value

DateAndTime

parameters.defaultValueDateTimeWithBetween
defaultValueDateTimeWithBetween
القيمة الافتراضية لحقل التاريخ والوقت (تعمل مع Between)
Date And Time Default Value (works with Between)

DateAndTime

parameters.defaultValueDateWithBetween
defaultValueDateWithBetween
القيمة الافتراضية لحقل التاريخ (تعمل مع Between)
Date Default Value (works with Between)

Date

parameters.defaultValueTime
defaultValueTime
القيمة الافتراضية لحقل الوقت
Time Default Value

Time

parameters.defaultValueTimeWithBetween
defaultValueTimeWithBetween
القيمة الافتراضية لحقل الوقت (تعمل مع Between)
Time Default Value (works with Between)

Time

parameters.defaultValueWithBetween
defaultValueWithBetween
القيمة الافتراضية (تعمل مع Between)
Default Value (works with Between)

Text

parameters.displayAttachmentAsImage
displayAttachmentAsImage
إظهار المرفق كصورة في التقرير
Display Attachment As Image

Boolean

parameters.displayFieldAs
displayFieldAs
إظهار الرقم كـ
Display Number As

DisplayNumberAs

parameters.displayReferenceAs
displayReferenceAs
إظهار المرجع كـ
Display Reference As

DisplayReferenceAs

parameters.doNotAddLinkToReferences
doNotAddLinkToReferences
عدم إضافة لينك للمرجع
Do Not Add Link To References

Boolean

parameters.englishTitle
englishTitle
العنوان بالإنجليزية
English Title

Text

parameters.fieldId
fieldId
الحقل
On Field

FieldID

parameters.fieldWidth
fieldWidth
العرض
Width

Decimal

parameters.filter
filter
Filter
Filter

BigText

parameters.filterType
filterType
نوع الفلتر
Filter Type

FilterType

parameters.finalHyperLinkExpression
finalHyperLinkExpression
Final Hyper Link Expression
Final Hyper Link Expression

BigText

parameters.finalJasperExpression
finalJasperExpression
Final Jasper Expression
Final Jasper Expression

BigText

parameters.finalSqlExpression
finalSqlExpression
Final Sql Expression
Final Sql Expression

BigText

parameters.generatedParameterName
generatedParameterName
Generated Parameter Name
Generated Parameter Name

Text

parameters.hasTotalInSummary
hasTotalInSummary
تجميع في الإجماليات
Has Total In Summary

Boolean

parameters.hidden
hidden
إخفاء
Hidden

Boolean

parameters.id
id

ID

parameters.layout
layout
طريقة العرض
Layout

FieldLayout

parameters.lineNumber
lineNumber

Integer

parameters.listDisplayType
listDisplayType
نوع عرض القائمة
List Display Type

ListDisplayType

parameters.mainFieldId
mainFieldId
الحقل الرئيسي (في حالة حقل بديل لحقل)
Main Field Id (In Case Alternative Field)

Text

parameters.mergedArabicTitle
mergedArabicTitle
Merged Arabic Title
Merged Arabic Title

Text

parameters.mergedEnglishTitle
mergedEnglishTitle
Merged English Title
Merged English Title

Text

parameters.namaFieldType
namaFieldType
Field Type
Field Type

Text

parameters.namaId
namaId
Nama Id
Nama Id

Text

parameters.paramType
paramType
النوع
Param Type

ParamFieldType

parameters.parameterType
parameterType
نوع المدخل
Parameter Type

ParameterType

parameters.patternField
patternField
Pattern Field
Pattern Field

FieldID

parameters.patternType
patternType
Pattern Type
Pattern Type

PatternType

parameters.refDefaultValue
refDefaultValueActualCode, refDefaultValueCode, refDefaultValueEntityType, refDefaultValueId
القيمة الافتراضية لحقل المرجع
Reference Default Value

Genericreference

parameters.refDefaultValueWithBetween
refDefaultValueWithBetweenActualCode, refDefaultValueWithBetweenCode, refDefaultValueWithBetweenEntityType, refDefaultValueWithBetweenId
القيمة الافتراضية لحقل المرجع (تعمل مع Between)
Reference Default Value (works with Between)

Genericreference

parameters.refEntityType
refEntityType
نوع المرجع
Reference Entity Type

EntityType

parameters.referenceOrderBy
referenceOrderBy
ترتيب المرجع بـ
Reference Order By

ReferenceOrderBy

parameters.required
required
إجبارى
Required

Boolean

parameters.requiredGroup
requiredGroup
Required Group
Required Group

Text

parameters.showInsideReport
showInsideReport
إظهار بداخل التقرير
Show Inside Report

Boolean

parameters.showRunningTotalInsteadOfValue
showRunningTotalInsteadOfValue
إظهار الإجمالي الحالي في التفاصيل بدلا من القيمة
Show Running Total Instead Of Value

ShowRunningTotalInsteadOfValue

parameters.showTotalInGroup1Section
showTotalInGroup1Section
Show Total In Group 1 Section
Show Total In Group 1 Section

GroupSection

parameters.showTotalInGroup2Section
showTotalInGroup2Section
Show Total In Group 2 Section
Show Total In Group 2 Section

GroupSection

parameters.showTotalInGroup3Section
showTotalInGroup3Section
Show Total In Group 3 Section
Show Total In Group 3 Section

GroupSection

parameters.showTotalInGroup4Section
showTotalInGroup4Section
Show Total In Group 4 Section
Show Total In Group 4 Section

GroupSection

parameters.showTotalInGroup5Section
showTotalInGroup5Section
Show Total In Group 5 Section
Show Total In Group 5 Section

GroupSection

parameters.sourceParameter
sourceParameter
Source Parameter
Source Parameter

Text

parameters.sourceProperty
sourceProperty
Source Property
Source Property

FieldID

parameters.sqlAggregationType
sqlAggregationType
SQL Aggregation Type
SQL Aggregation Type

SqlAggregationType

parameters.sqlColumns
sqlColumns

Text

parameters.style
style_id
Style
Style

Reference

ReportStyle

parameters.summaryConditionalStyleGrid
summaryConditionalStyleGrid
رقم جدول التنسيق الشرطي للإجماليات
Summary Conditional Style Grid

Integer

parameters.summaryStyle
summaryStyle_id
Summary Style
Summary Style

Reference

ReportStyle

parameters.totalPosition
totalPosition
Total Position
Total Position

TotalPosition

parameters.type
type
النوع
Type

WizardFieldType

parameters.unionHandling
unionHandling
Union Handling
Union Handling

BigText

parameters.userAlias
userAlias
User Alias (In Case SQL Expression)
User Alias (In Case SQL Expression)

Text

parameters.widthSize
widthSize
مقاس العرض
Width Size

GridSizeEnum

securityConstraints (Security Constraints - Security Constraints)

Table Name: DashBoardWidgetWizardSecurityConstraints, Join Column: dashBoardWidgetWizard_id

Property
Column
Arabic
English
Type
Foreign Table
securityConstraints.fieldId
fieldId
الحقل
On Field

FieldID

securityConstraints.firstAuthor
firstAuthor
منشئ السجل
First Author

Boolean

securityConstraints.id
id

ID

securityConstraints.lineNumber
lineNumber

Integer

securityConstraints.loginAnalysisSet
loginAnalysisSet
المجموعة التحليلية للدخول
Login Analysis Set

Boolean

securityConstraints.loginBranch
loginBranch
فرع الدخول
Login Branch

Boolean

securityConstraints.loginDepartment
loginDepartment
قسم الدخول
Login Department

Boolean

securityConstraints.loginEmployee
loginEmployee
Login Employee
Login Employee

Boolean

securityConstraints.loginLegalEntity
loginLegalEntity
شركة الدخول
Login Legal Entity

Boolean

securityConstraints.loginSector
loginSector
قطاع الدخول
Login Sector

Boolean

securityConstraints.updateCapability
updateCapability
صلاحية التعديل
Update Capability

Boolean

securityConstraints.usageCapability
usageCapability
صلاحية الاستخدام
Usage Capability

Boolean

securityConstraints.viewCapability
viewCapability
صلاحية المطالعة
View Capability

Boolean

sortFields (حقول الترتيب - Sort Fields)

Table Name: DashBoardWidgetWizardSortFieldLine, Join Column: dashBoardWidgetWizard_id

Property
Column
Arabic
English
Type
Foreign Table
sortFields.arabicTitle
arabicTitle
العنوان بالعربية
Arabic Title

Text

sortFields.barcodeType
barcodeType
نوع الباركود
Barcode Type

BarcodeType

sortFields.conditionalStyleGrid
conditionalStyleGrid
رقم جدول التنسيق الشرطي
Conditional Style Grid

Integer

sortFields.configuration
configuration
Configuration
Configuration

BigText

sortFields.currencyField
currencyField
حقل العملة
Currency Field

FieldID

sortFields.customHyperLinkExpression
customHyperLinkExpression
Custom Hyper Link Expression
Custom Hyper Link Expression

BigText

sortFields.customJasperExpression
customJasperExpression
Custom Jasper Expression
Custom Jasper Expression

BigText

sortFields.customPattern
customPattern
Custom Pattern
Custom Pattern

Text

sortFields.customSqlExpression
customSqlExpression
Custom SQL Expression
Custom SQL Expression

BigText

sortFields.displayAttachmentAsImage
displayAttachmentAsImage
إظهار المرفق كصورة في التقرير
Display Attachment As Image

Boolean

sortFields.displayFieldAs
displayFieldAs
إظهار الرقم كـ
Display Number As

DisplayNumberAs

sortFields.displayReferenceAs
displayReferenceAs
إظهار المرجع كـ
Display Reference As

DisplayReferenceAs

sortFields.doNotAddLinkToReferences
doNotAddLinkToReferences
عدم إضافة لينك للمرجع
Do Not Add Link To References

Boolean

sortFields.englishTitle
englishTitle
العنوان بالإنجليزية
English Title

Text

sortFields.fieldId
fieldId
الحقل
On Field

FieldID

sortFields.fieldWidth
fieldWidth
العرض
Width

Decimal

sortFields.finalHyperLinkExpression
finalHyperLinkExpression
Final Hyper Link Expression
Final Hyper Link Expression

BigText

sortFields.finalJasperExpression
finalJasperExpression
Final Jasper Expression
Final Jasper Expression

BigText

sortFields.finalSqlExpression
finalSqlExpression
Final Sql Expression
Final Sql Expression

BigText

sortFields.hasTotalInSummary
hasTotalInSummary
تجميع في الإجماليات
Has Total In Summary

Boolean

sortFields.hidden
hidden
إخفاء
Hidden

Boolean

sortFields.id
id

ID

sortFields.lineNumber
lineNumber

Integer

sortFields.mainFieldId
mainFieldId
الحقل الرئيسي (في حالة حقل بديل لحقل)
Main Field Id (In Case Alternative Field)

Text

sortFields.mergedArabicTitle
mergedArabicTitle
Merged Arabic Title
Merged Arabic Title

Text

sortFields.mergedEnglishTitle
mergedEnglishTitle
Merged English Title
Merged English Title

Text

sortFields.namaFieldType
namaFieldType
Field Type
Field Type

Text

sortFields.namaId
namaId
Nama Id
Nama Id

Text

sortFields.patternField
patternField
Pattern Field
Pattern Field

FieldID

sortFields.patternType
patternType
Pattern Type
Pattern Type

PatternType

sortFields.referenceOrderBy
referenceOrderBy
ترتيب المرجع بـ
Reference Order By

ReferenceOrderBy

sortFields.showRunningTotalInsteadOfValue
showRunningTotalInsteadOfValue
إظهار الإجمالي الحالي في التفاصيل بدلا من القيمة
Show Running Total Instead Of Value

ShowRunningTotalInsteadOfValue

sortFields.showTotalInGroup1Section
showTotalInGroup1Section
Show Total In Group 1 Section
Show Total In Group 1 Section

GroupSection

sortFields.showTotalInGroup2Section
showTotalInGroup2Section
Show Total In Group 2 Section
Show Total In Group 2 Section

GroupSection

sortFields.showTotalInGroup3Section
showTotalInGroup3Section
Show Total In Group 3 Section
Show Total In Group 3 Section

GroupSection

sortFields.showTotalInGroup4Section
showTotalInGroup4Section
Show Total In Group 4 Section
Show Total In Group 4 Section

GroupSection

sortFields.showTotalInGroup5Section
showTotalInGroup5Section
Show Total In Group 5 Section
Show Total In Group 5 Section

GroupSection

sortFields.sortDirection
sortDirection
اتجاه الترتيب
Sort Direction

SortDirection

sortFields.sqlAggregationType
sqlAggregationType
SQL Aggregation Type
SQL Aggregation Type

SqlAggregationType

sortFields.sqlColumns
sqlColumns

Text

sortFields.style
style_id
Style
Style

Reference

ReportStyle

sortFields.summaryConditionalStyleGrid
summaryConditionalStyleGrid
رقم جدول التنسيق الشرطي للإجماليات
Summary Conditional Style Grid

Integer

sortFields.summaryStyle
summaryStyle_id
Summary Style
Summary Style

Reference

ReportStyle

sortFields.totalPosition
totalPosition
Total Position
Total Position

TotalPosition

sortFields.type
type
النوع
Type

WizardFieldType

sortFields.unionHandling
unionHandling
Union Handling
Union Handling

BigText

sortFields.usedAsDefaultValueToParameterNumber
usedAsDefaultValueToParameterNumber
يستعمل كقيمة افتراضية للمدخل رقم
Used As Default Value To Parameter Number

Integer

sortFields.userAlias
userAlias
User Alias
User Alias

Text

sortFields.widthSize
widthSize
مقاس العرض
Width Size

GridSizeEnum

unionTables (Union Tables - Union Tables)

Table Name: DashBoardWidgetWizardUnionTablesLine, Join Column: dashBoardWidgetWizard_id

Property
Column
Arabic
English
Type
Foreign Table
unionTables.id
id

ID

unionTables.lineNumber
lineNumber

Integer

unionTables.unionTable
unionTable
Union Table
Union Table

FieldID

userAliases (User Aliases - User Aliases)

Table Name: DashBoardWidgetWizardUserAliasesLine, Join Column: dashBoardWidgetWizard_id

Property
Column
Arabic
English
Type
Foreign Table
userAliases.id
id

ID

userAliases.lineNumber
lineNumber

Integer

userAliases.propertyName
propertyName
Property Name
Property Name

Text

userAliases.systemAlias
systemAlias
System Alias
System Alias

Text

userAliases.tableName
tableName
Table Name
Table Name

Text

userAliases.userAlias
userAlias
User Alias
User Alias

Text

whereLines (Where Lines - Where Lines)

Table Name: DashBoardWidgetWizardWhereLine, Join Column: dashBoardWidgetWizard_id

Property
Column
Arabic
English
Type
Foreign Table
whereLines.doNotQuote
doNotQuote
Do Not Quote
Do Not Quote

Boolean

whereLines.id
id

ID

whereLines.lhsFieldId
lhsFieldId
LHS Field Id
LHS Field Id

FieldID

whereLines.lineNumber
lineNumber

Integer

whereLines.operator
operator
المعامل
Operator

FilterType

whereLines.rhsDefaultValueDate
rhsDefaultValueDate
RHS Default Value Date
RHS Default Value Date

Date

whereLines.rhsDefaultValueDateTime
rhsDefaultValueDateTime
RHS Default Value Date Time
RHS Default Value Date Time

DateAndTime

whereLines.rhsDefaultValueDateTimeWithBetween
rhsDefaultValueDateTimeWithBetween
RHS Default Value Date Time (Works with Between)
RHS Default Value Date Time (Works with Between)

DateAndTime

whereLines.rhsDefaultValueDateWithBetween
rhsDefaultValueDateWithBetween
RHS Default Value Date (Works with Between)
RHS Default Value Date (Works with Between)

Date

whereLines.rhsDefaultValueTime
rhsDefaultValueTime
RHS Default Value Time
RHS Default Value Time

Time

whereLines.rhsDefaultValueTimeWithBetween
rhsDefaultValueTimeWithBetween
RHS Default Value Time (Works with Between)
RHS Default Value Time (Works with Between)

Time

whereLines.rhsFieldId
rhsFieldId
RHS Field Id
RHS Field Id

FieldID

whereLines.rhsRefDefaultValue
rhsRefDefaultValueActualCode, rhsRefDefaultValueCode, rhsRefDefaultValueEntityType, rhsRefDefaultValueId
RHS Reference Default Value
RHS Reference Default Value

Genericreference

whereLines.rhsRefDefaultValueWithBetween
rhsRefDefaultValueWithBetweenActualCode, rhsRefDefaultValueWithBetweenCode, rhsRefDefaultValueWithBetweenEntityType, rhsRefDefaultValueWithBetweenId
RHS Reference Default Value (Works with Between)
RHS Reference Default Value (Works with Between)

Genericreference

whereLines.rhsValue
rhsValue
RHS Value
RHS Value

Text

whereLines.rhsValueWithBetween
rhsValueWithBetween
RHS Value (Works with Between)
RHS Value (Works with Between)

Text

whereLines.specialValue
specialValue
Special Value
Special Value

Text

Edit On github
Last Updated:: 4/21/26, 12:10 AM