SFHub Table Row Filter Syntax

SFHub Table Row Filter Syntax allows you to filter table rows using standard c# row filter syntax (Reference https://docs.microsoft.com/it-it/dotnet/api/system.data.datatable.select?view=netframework-4.8), combined with a composite formatstring. The Table Row Filter allows you to filter a SFHub Table by specifying conditions through Boolean expression.

Note

Use the table row filter syntax when using SFHub Table Functions, typically the Where clause, or when using SFCodeBlocks handling tables such as the ForEach.

While using table row filter syntax you MUST use the proper single quote character '.

The following sections coverare the various table row filter syntaxes that can be used in SFHub.

• Conditions

• Literals

• Dynamic Values

• Column Names

• Special Characters

• Comparison Operators

• In Operator

• Like Operator

• Logical Operators

• Arithmetic Operators