Server Side Functions/Methods

Official Content
This documentation is valid for:

Whenever a navigation group (For Each, Grid with Base Table, Formula, etc) references a function or method, GeneXus determines whether that function can be evaluated in the server by the DMBS handler. If it is resolved by the DMBS it is better because the whole navigation could be evaluated on the server side, thus optimizing the access to them; instead of solved by program.

The list that follows shows the function or method that currently are evaluated on the server side for at least one of the DBMS.

 

GeneXus Function/Method SQLServer Oracle MySQL DB2 DB2 ISERIES Informix PostgreSQL SQLite
Dates Handling
Day3 Yes Yes Yes Yes Yes 4 Yes Yes -
Month3 Yes Yes Yes Yes Yes4 Yes Yes -
Year3 Yes Yes Yes Yes Yes4 Yes Yes -
Hour3 Yes Yes1 Yes Yes Yes Yes Yes -
Minute3 Yes Yes 1 Yes Yes Yes Yes Yes -
Second Yes Yes 1 Yes Yes Yes Yes Yes -
AddMth / AddMonths Yes NO Yes Yes Yes 2 Yes Yes -
AddYr / AddYears Yes Yes Yes Yes Yes2 Yes Yes -
Operator Yes Yes Yes Yes Yes Yes Yes -
Age Yes Yes Yes Yes Yes2 Yes Yes -
Dow3 / DayOfWeek3 Yes NO Yes Yes Yes2 Yes Yes -
Eom3 / EndOfMonth3 Yes Yes NO NO Yes2 Yes Yes -
TAdd / AddSeconds Yes NO Yes NO NO Yes Yes -
TDiff6 / Difference6 NO NO NO NO NO NO NO -
ServerNow Yes Yes Yes Yes Yes5 NO Yes -
ServerDate Yes Yes Yes Yes Yes5 NO Yes -
Numeric Values Handling
Int / Integer Yes Yes Yes Yes Yes Yes Yes Yes
Round Yes Yes Yes Yes Yes Yes Yes Yes
Trunc / Truncate Yes Yes Yes Yes Yes Yes Yes -
Strings Handling
Asc Yes Yes Yes Yes NO Yes Yes -
Val / ToNumeric Yes Yes Yes Yes Yes Yes Yes Yes
Len / Length Yes Yes Yes Yes Yes Yes Yes Yes
Lower / ToLower Yes Yes Yes Yes Yes Yes Yes Yes
Ltrim / TrimStart Yes Yes Yes Yes Yes Yes Yes Yes
Padl / PadLeft Yes Yes Yes Yes NO Yes Yes Yes
Padr / PadRight Yes Yes Yes Yes Yes Yes Yes Yes
Rtrim / TrimEnd Yes Yes Yes Yes Yes Yes Yes Yes
Str Yes Yes Yes NO NO Yes Yes -
Strreplace / Replace Yes Yes Yes Yes NO Yes Yes Yes
Strsearch / IndexOf Yes Yes Yes Yes Yes NO Yes -
Strsearchrev / LastIndexOf Yes Yes NO NO NO NO NO -
Substr / Substring Yes Yes Yes Yes Yes Yes Yes Yes
Trim Yes Yes Yes Yes Yes Yes Yes Yes
Upper / ToUpper Yes Yes Yes Yes Yes Yes Yes Yes
Concat Yes Yes Yes Yes Yes Yes Yes Yes
+ (to concatenate) Yes Yes Yes Yes Yes Yes Yes Yes
Other functions
iif Yes Yes Yes Yes Yes Yes Yes Yes
IsMatch NO Yes Yes NO NO NO Yes NO
ReplaceRegEx NO Yes NO NO NO NO Yes NO

 

Notes

  • When navigation group (For Each, Data Provider, Grid) includes in their Where/Condition clause a function or method that can not be evaluated by the DBMS, a warning icon WarningIcon will be shown for that condition in the navigation list. Passing the mouse over it displays: "Constraint evaluated in the client. This may lead to poor performance"
  • 1 Supported as "Server Side" since Oracle 9.
  • 2 Supported as "Server Side" only if the value of the property Date data type definition is "Date" and argument is Date (not DateTime).
  • 3 Some of the functions handling Datetime fields may not be evaluated in the DBMS when TimeZone Support is Enabled. See TimeZone Support - General Considerations for more information.
  • 4 Supported as "Server Side" for GeneXus X Evolution 3 U4 and upper versions. For lower versions, only if the value of the property Date data type definition is "Date".
  • 5 It only applies if the value of the property Date data type definition is "Date".
  • 6 Supported as "Server Side" for GeneXus 15 U4 and upper versions.


Was this page helpful?
What Is This?
Your feedback about this content is important. Let us know what you think.