RecroGridRGOptionOptionKeys Enumeration

Predefined options in RecroGrid.

Definition

Namespace: Recrovit.RecroGridFramework
Assembly: Recrovit.RecroGrid (in Recrovit.RecroGrid.dll) Version: 8.5.2.24.0805.1
C#
public enum OptionKeys

Members

RGO_AddToBottom0Entity option:
 If its value is true, then during a new entry, it scrolls the list view to the end and adds it as the last one.
RGO_AjaxBinding1Property option:
 For a DropDown field, a true value enables asynchronous loading, which the browser can cache for faster retrieval.
⚠️ Warning!
 If specified, the contents of the dictionary become directly accessible from the browser, so its use is recommended only for publicly accessible data.
Default: false
RGO_Attributes2Property option:
 Specifying HTML attributes.
e.g. {min:1, max:5, role:'role-x'}
RGO_ChildWhere3Property option:
 In Child mode, specifying the WHERE clause for the entity in NSQL format, instead of using the parent relationship.
e.g. exists(select * from tablename A where A.Id={1})
One-to-Many relationship, {0}=context, {1}=key
RGO_ClientFilter4Entity option:
 Enabling client-side search.
RGO_ClientMode5Entity option:
 Dynamically created entity, no SQL, no toolbar buttons. Limited client-side search.
RGO_ContextMenuType6Entity option:
 A type of right-click menu display 0: Disabled
1: Appears (with +CTRL, follows browser default)
2: Only with the CTRL key"
RGO_CRUD7Entity option:
 Available functions (buttons) in the RecroGrid interface:
C: Create/New
R: Read/View
U: Update/Edit
D: Delete
Overrides settings for RecroSec buttons!
RGO_CssClass8Entity option:
 Setting the CSS class for RecroGrid.

Property option:
 Specifying the CSS class for the field.
RGO_CustomMenu9Entity option:
 RgfMenu megadása.
RGO_DependentColumns10Property option:
 Represents an option setting indicating the dependencies of the current column on other columns. The value is a comma-separated list of aliases representing the columns on which the current column depends.
RGO_DictionaryItems11Entity option:
 The entity can be treated as a dictionary, eliminating the need to define for every property. Parameterization is consistent with the Property option, and a simplified query format can also be provided in the format Id,Name[,Order].

Property option:
  • Static enumeration: in the format {id0:val0;id1:val2;...}
  • Fill from RecroDict dictionary. Format: <%%>Scope, or <%%>KK:Scope for generating Key/Key pairs.
  • Enum:TypeDefinition Server-side Enum.
    e.g. Enum:Model.Class1+DSEnum, AssemblyName
  • Enum<%%>Scope:TypeDefinition Server-side Enum with RecroDict target.
  • Data-dependent NSQL, which should return Key/value pairs. Annotation with the (NSQL:) prefix. The current record data can be used in conditions. Reference with @ClientName.
    e.g. NSQL:select p.PropertyId, p.ColName from RecroGrid_Property p where p.EntityId=@rg-col-31
  • Callback of a server-side function. Annotation Callback:functionName. The function type is
    public static List<KeyValuePair<string, string>> functionName(RGDictionaryCallbackParam)
    which can be found in the current RecroGrid, EntityType, EntityBase RecroGrid, or its EntityType.
  • If the option is not specified, it searches in the EntityBase.
RGO_DisableInheritance12Property option:
 Disables inheritance from EntityBase. Default: false
RGO_EnableClientCreate13Entity option:
 If the value is true, it can also be created client-side using the CreateRecroGrid. Default: false
RGO_EnableJqPlot14Entity option:
 If true, it loads the files required for using jqPlot. Default: false
RGO_EntityId15Entity option:
 Passes the entity Id to the client, which is used for internal tasks. Automatically generated option, read-only.
RGO_FilterExpression16Property option:
 Defining a custom filter condition based on the selected parameters.
If the reference pertains to a child table, the table must be added with a type other than RecroGrid and the option RGO_Forced=true.
e.g. exists(select * from tablename g where g.Name {1})
Replace {1} with the condition.
RGO_FixWhere17Entity option:
 Specifying a constant filter condition (SQL WHERE) for the entity in NSQL format.
e.g. exists(select * from Users A where A.Status = 'Valid')

Property option:
 Specifying a fixed WHERE clause for the entity in NSQL format in Child mode.
RGO_Forced18Property option:
 Sets the column to always be included in queries and sent to the client. Default: false
RGO_ForeignKey19Property option:
 Can be specified for navigation properties. Used in the case of nested lists and choosing from a list.
Many to One: Property name used in the own type
One to Many: Property name used in the external type.
When choosing a child, only selection is allowed in the key field, direct input is not possible.
The value is case-sensitive.
RGO_Format20Property option:
 Formatting appearance in RecroGrid. Full format string with {0}, or only the format specifier ({0:format}).
e.g. yyyy.MM.dd. HH:mm:ss.fff, {0:#,0.##}
RGO_FormatDateTimePicker21Property option:
 Date calendar format for the Form view. Overrides can be provided in JSON format.
The format must be in sync with what is specified in RGO_Format.
Default: { "dateFormat":"yy.mm.dd.", "timeFormat":"HH:mm:ss" }
e.g. Modification for displaying milliseconds: { "timeFormat":"HH:mm:ss.l" }
Other formats
RGO_FormElementClass22Property option:
 Defining the CSS class associated with the field container in Form view.
RGO_FormElementStyle23Property option:
 Defining the Style associated with the field container for the Form view.
RGO_FormFlexColumnWidth24Entity option:
 Default field width in form view, based on a 12-column FlexBox grid. Can be specified at Entity, Tab, and Group levels.
e.g. RGO_FormFlexColumnWidth-{Tidx}, RGO_FormFlexColumnWidth-{Tidx}-{Gidx}.
Note: The Tab index (Tidx) starts from 1, while the Group index (Gidx) starts from 0.
Property option:
 The width of the field in Form view, based on a 12-column FlexBox grid.
RGO_FormLineBreak25Property option:
 Sets to have a line break (<br/>) before the field in Form view.
Default: false
RGO_FormPreElements26Property option:
 In Form view, the specified HTML expression is placed in front of the field.
A RecroDict dictionary element can also be specified in the format <%%>Scope.StringId."
RGO_FormStyleSheetURL27Entity option:
 The name of the stylesheet (CSS file) used in the Form view.
Default: /rgf/styles/{NameVersion.ToLower()}.css
RGO_FormTabGroupTitle28Entity option:
 Specifies the title of the specified Tab or Group in the Form view. The option must indicate the Tab (Tidx) and Group (Gidx) index in the name. e.g. RGO_FormTabGroupTitle-{Tidx}, RGO_FormTabGroupTitle-{Tidx}-{Gidx}.
Note: The Tab index (Tidx) starts from 1, while the Group index (Gidx) starts from 0.
A RecroDict dictionary element can also be specified in the format <%%>Scope.StringId."
RGO_FormTemplate29Entity option:
 XSL template for the Form view.
RGO_FormTemplateName30Entity option:
 The name of the XSL template for the Form view.
RGO_FEP31Entity option:
 Four Eyes Principle. If true, then it is enabled.
RGO_FEPB32Entity option:
 Four Eyes Principle (Double Data Entry). RGO_FEPColums must be used. If true, then it is enabled.
RGO_FEPColums33Entity option:
 Listing FEP fields' Alias identifiers separated by commas.
RGO_FEPQueue34Entity option:
 If true, then the List view displays only items pending for FEP.
RGO_FriendlyKey35Entity option:
 You can list the ClientName identifiers of those columns whose data allows the user to identify the record. These data will appear, for example, in the confirmation message for deletion.
RGO_HtmlEditor36Property option:
 Enables editing in HTML mode (with the help of a button) for the TextBox in the Form view.
Default: false
RGO_HtmlElements37Property option:
 Custom HTML expression for a field of type IsDynamic. If specified, RGO_NoLabel is set to true by default.
A RecroDict dictionary element can also be specified in the format <%%>Scope.StringId."
RGO_HtmlTag38Property option:
 Defining the HTML tag for FormTypeEnum.Custom type.
Default: div
RGO_ImageTarget39Property option:
 Alias identifier for the Image field of an external entity. In this case, the ColName should contain the identifier of the external entity (column name) with an NSQL annotation. This will be received as a parameter by the RGF Image service.
e.g. ColName: NSQL:{0}.CategoryID
Alias: Picture
RGO_ImageTarget: Picture
RGO_ImageVersion40Property option:
 In the case of a field of type ImageInDB, another field indicating the version of the image can be specified. Default: from the RowVersionName setting (if the field exists).
RGO_InnerJoin41Property option:
 Defining a relationship that is not defined in the EF logical model. An alias must be given to the external table, and it must be referenced with that alias and an NSQL prefix in the name. The {0} notation should be used in the name instead of the current table name. The expression should be provided starting from the external table name, and NSQL format should be used in conditions.
e.g. Person personExt on {0}.BusinessEntityID = personExt.BusinessEntityID
ColName: NSQL:personExt.FirstName
RGO_InvalidForeignKey42Property option:
 Enables entering invalid data into the ForeignKey field. Default: false
RGO_ItemsPerPage43Entity option:
 Specifies the maximum number of rows in the List view.
Default: the value specified in the appsettings or 15.
RGO_ItemsTooltip44Property option:
 Tooltip for items of a DropDown type field from the RecroDict. You need to provide the Scope identifier, and StringId is the key for individual elements.
RGO_JQManual45Property option:
 JavaScript callback function usable on the client side to modify the generated HTML element. The original Value is not written. Only the body of the function needs to be specified.
Input parameter: args args.Self: jQuery current column $('td')
args.Value: value of the current column
args.Columns: all column values and definitions passed to the client, referenced with ClientName
args.Columns['rg-col-x'].Value: value
args.Columns['rg-col-x'].ColumnDefs: see ColumnDefs class
e.g. args.Self.attr('href', '/tar?id=' + args.Value);"
RGO_JQReplace46Property option:
 JavaScript callback function usable on the client side to modify the generated HTML element. Only the body of the function needs to be specified. In the case of RGO_JQManual definition, the option is not executed.
Input parameter: args
args.Self: jQuery current column $('td')
args.Value: value of the current column
args.Columns: all column values and definitions passed to the client, referenced with ClientName
args.Columns['rg-col-x'].Value: value
args.Columns['rg-col-x'].ColumnDefs: see ColumnDefs class"
e.g. args.Self.on('click', function () { alert('Clicked'); });
JavaScript
//Extending the functionality of an HTML element
args.Self.on('click', function () {
    alert('Clicked');
});

//Displaying an additional element
if (args.Value > 1000)
    $(args.Self).parent().prepend('<div class="ui-state-error" style="float:right"><span class="ui-icon ui-icon-alert"></span></div>');

//Modifying attributes in template mode
args.Self.attr('href', 'href="/Details?Id=' + args.Columns['rg-col-2077'].Value + '"');
//
RGO_JSColClass47Property option:
 JavaScript callback function usable on the client side for formatting a cell. Only the body of the function needs to be specified. In the return value, you can provide CSS classes.
Input parameter: args
args.Value: value of the current column
args.Columns: all column values and definitions passed to the client, referenced with ClientName
args.Columns['rg-col-x'].Value: value
args.Columns['rg-col-x'].ColumnDefs: see ColumnDefs class"
e.g. if (args.Value == 'M') return 'gray-italic';
RGO_JSColStyle48Property option:
 JavaScript callback function usable on the client side for formatting a cell. Only the body of the function needs to be specified. In the return value, you can provide styles.
Input parameter: args
args.Value: value of the current column
args.Columns: all column values and definitions passed to the client, referenced with ClientName
args.Columns['rg-col-x'].Value: value
args.Columns['rg-col-x'].ColumnDefs: see ColumnDefs class"
e.g. if (args.Value == 'F') return 'background-color:yellow;';
RGO_JSReplace49Property option:
 JavaScript callback function usable on the client side for modifying the value. Only the body of the function needs to be specified. The new value should be returned in the return value.
Input parameter: args
args.Value: value of the current column
args.Columns: all column values and definitions passed to the client, referenced with ClientName
args.Columns['rg-col-x'].Value: value
args.Columns['rg-col-x'].ColumnDefs: see ColumnDefs class"
e.g. if (args.Value == 'M') return 'Male';
JavaScript
//Data modification
if (args.Value == 'M') return 'Male';
if (args.Value == 'F') return 'Female';

//Creating a link using data from another field
return '<a href="/Details?Id=' + args.Columns['rg-col-2077'].Value + '" target="_blank">' + args.Value + '</a>';
//
RGO_JSRowClass50Property option:
 JavaScript callback function usable on the client side for formatting a row. Only the body of the function needs to be specified.
In the return value, you can provide CSS classes.
Input parameter: args
args.Value: value of the current column
args.Columns: all column values and definitions passed to the client, referenced with ClientName
args.Columns['rg-col-x'].Value: value
args.Columns['rg-col-x'].ColumnDefs: see ColumnDefs class"
e.g. if (args.Value == 'M') return 'gray-italic';

Entity option:
 Similar to the property, but called only once per row, and the args.Value parameter is invalid for each row
RGO_JSRowStyle51Property option:
 JavaScript callback function usable on the client side for formatting a cell. Only the body of the function needs to be specified. In the return value, you can provide styles.
Input parameter: args
args.Value: value of the current column
args.Columns: all column values and definitions passed to the client, referenced with ClientName
args.Columns['rg-col-x'].Value: value
args.Columns['rg-col-x'].ColumnDefs: see ColumnDefs class"
e.g. if (args.Value == 'F') return 'background-color:yellow;';

Entity option:
 Similar to the property, but called only once per row, and the args.Value parameter is invalid for each row
RGO_JSValidator52Property option:
 JavaScript callback function usable on the client side for validating the value during new entry or modification. Only the body of the function needs to be specified. In case of an error, the return value is false, and the error message can be provided in args.Error.
Input parameter: args
args.Value: value of the current field
args.ClientRec: all available field values and definitions, referenced with ClientName
args.ClientRec['rg-col-x'].Value: value
args.ClientRec['rg-col-x'].ColumnDefs: see ColumnDefs class"
e.g. var patt = new RegExp('^[0-9a-zA-Z]+$');
if( !patt.test(args.Value) ){
//args.Error = 'Error message';
return false;
}
JavaScript
//Value validation using RegExp
var patt = new RegExp('^[\$0-9a-zA-Z]+$');
if (!patt.test(args.Value)) {
    args.Error = 'The field value can only contain letters and numbers!';
    return false;
}

//Dependency on another field
if (args.Value < args.ClientRec['rg-col-112'].Value) {
    //args.Error = get_RecroDictStr('Scope', 'Id'); //Message from the RecroDict dictionary.
    args.Error = 'The Value cannot be less than XY!';
    return false;
}
//
RGO_KeepAlive53 Interval, specified in seconds, for keeping the session alive in a legacy project. It can be configured in the web.config.
Default: 300 seconds
RGO_Language54Entity option:
 Setting the mandatory language to be used.
RGO_LegacyFormTemplate55Entity option:
 Use Legacy FormTemplate. Default: false
RGO_ListTemplate56Entity option:
 HTML template that defines the appearance of an element in the List view.
RGO_ListTemplateName57Entity option:
 The name of the HTML template that defines the appearance of an element in the List view.
RGO_MaxChar58Property option:
 The maximum length usable for displaying the element. Longer lengths will be truncated.
RGO_MaxLength59Property option:
 Setting the maximum length for a character input field.
RGO_Name60Entity option:
 It passes the client the NameVersion entity, which is used for internal tasks. It is an automatically generated option and is read-only.
RGO_NoDetails61Entity option:
 If its value is true, then the Form view is not accessible.
RGO_NoFilter62Entity option:
 If its value is `true`, the filter will not be accessible.

Property option:
 Specifies that the field should not be included in the filter.
Default: false
In the filter, it will only appear if the field is Readable or Admin for the current permission, and in the case of IsDynamic, it will only appear if RGO_FilterExpression is defined.
RGO_NoFormat63Property option:
 Specifies that in the List view, the field should not use default formatting (e.g. numeric values right-aligned). Default: false
RGO_NoKeyUpdate64Entity option:
 Specifies whether modifying the key in the entity is allowed. It is disabled when the value is true.
Default: false
RGO_NoLabel65Property option:
 Specifies that in the Form view, the label of the field should not be displayed.
Default: false
RGO_NoMouseWheel66Entity option:
 If its value is true, then it does not handle the Mouse Wheel in the List view.
RGO_NoScroll67Entity option:
 If its value is true, only forward paging is available, the scrollbar is not accessible, and it does not query the count(*). In this mode, resizing (RGO_Resizable) is not available. The minimum value for preload is 100.
RGO_Nullable68Property option:
 If its value is false, then it is a required field on the client side (in the Form view). This setting is not inherited from an external field.
RGO_Orderable69Property option:
 Specifies whether the field can be sorted in the List view.
RGO_OuterJoin70Property option:
 Defining a relationship that is not defined in the EF logical model. An alias must be given to the external table, and it must be referenced with that alias and an NSQL prefix in the name. The {0} notation should be used in the name instead of the current table name. The expression should be provided starting from the external table name, and NSQL format should be used in conditions.
e.g. Person personExt on {0}.BusinessEntityID = personExt.BusinessEntityID
ColName: NSQL:personExt.FirstName
RGO_PartialView71Entity option:
 The specified MVC Partial View is invoked for the generation of the Form view for all fields, except when explicitly disabled with the RGO_PartialView=false option in the Property.

Property option:
 Referring to the MVC PartialView of the field.
e.g. ~/Views/Northwind/EmployeeForm.cshtml
RGO_Password72Property option:
 It sets the field to be of password type in the Form view. Default: false
RGO_PortableName73Property option:
 The optional client-side secondary name of the column.
RGO_Preload74Entity option:
 The number of records to prefetch during pagination.
Default: RGO_ItemsPerPage * 2
RGO_QuerySkip75Entity option:
 Skips the specified number of records from the beginning of the query result.
RGO_RecroSec76Entity option:
 ObjectName defined in RecroSec. If its value is false, then it does not enforce permissions for the entity.
Default: entity name.

Property option:
 The value can be an ObjectName defined in RecroSec, or if its value is `true`, it retrieves permissions for the column based on the RecroSec/Alias associated with the entity. If RGO_RecroSecLevel contains the keyword Column, then it is not necessary to define permissions separately for each column.
If its value is false, it does not retrieve permissions for the field.
RGO_RecroSecCol77Entity option:
 If its value is true, then it is mandatory to specify permissions for the columns in the Form view. If permission is not provided, the default is Read. Default: false
RGO_RecroSecLevel78Entity option:
 If it contains the keyword Row, then in the List view, it checks permissions at the record level. In this case, it already looks for permissions for the record key in the database query, and it sends CRUD operations to the client on a per-row basis.
If it contains the keyword Column, then it retrieves permissions for each column and sends CRUD operations to the client on a per-column basis. This setting applies only to the List view.
RGO_Resizable79Entity option:
 Specifies whether the RecroGrid can be resized by the user.
Default: false
Cannot be used simultaneously with RGO_NoScroll mode.
RGO_SCEditor80Property option:
 SCEditor options can be provided in JSON format.
RGO_ScriptControl81Entity option:
 Defining a class derived from the client-side Recrovit.WebCli.RecroGrid.
RGO_ScriptURLs82Entity option:
 Paths of scripts to be loaded.
RGO_Skeleton83Entity option:
 The skeleton of a List view template in HTML format.
e.g. empty template: <div class="scroll-content"></div>
RGO_SkeletonName84Entity option:
 The name of the List view template.
RGO_Sort85Property option:
 Specifies the sorting of the List view. Positive number indicates ascending order, negative indicates descending order. In case of multi-column sorting, the order is based on the absolute value of the number. /// Default: 0
RGO_SQLTimeout86Entity option:
 The timeout to use, in seconds.
RGO_StatusbarCustomItems87Entity option:
 Other elements that can be placed on the Statusbar, in HTML format.
RGO_Style88Entity option:
 Specifies the style set for RecroGrid.

Property option:
 Specifies the style associated with the field.
RGO_StyleSheet89Entity option:
 Stylesheet, which is attached to the page. If not specified, it is extracted from the RGO_SkeletonName template (if it exists).
RGO_StyleSheetURLs90Entity option:
 List of Stylesheet files to be loaded.
RGO_SystemType91Property option:
 When using Join or Subquery, you need to specify the type of the outer field in order to use the filter.
Default: if ListType=Numeric or FormType=DropDown,ListBox then Int64, otherwise String.
RGO_ToolbarCustomItems92Entity option:
 Other elements that can be placed on the Toolbar, in HTML format.
RGO_Tooltip93Entity option:
 Using the RecroDict dictionary for displaying Tooltips. The Scope identifier must be provided, and the StringId will be the field Alias. If the Property also has a Tooltip, it will be used.
Property option:
 Specifies the Tooltip for the field. A RecroDict dictionary element can also be specified in the format <%%>Scope.StringId."
RGO_UserFilter94Entity option:
 Stores the UserFilter for the default List view in XML format. The administrator saves this along with the column settings. Manual modification is not recommended.

See Also