Search Results for fieldbase

 

ResetFields

Takes two parameters, FieldBase, FieldNames

 

Pull

Takes three parameters, QueryName, FieldBase, FieldNames

 

Plus8Encode

Takes three parameters, FieldBase, Fields, IfLenFld

 

SetFirst

Takes four parameters, FieldBase, Destination, Source, IfLenFld

 

Set

Takes four parameters, FieldBase, Destination, Source, IfLenFld

 

SendEmail

Takes 10 parameters, FieldBase, From, To, Subject, Body, bMerge, AttachName, AttachPath, Slow, IfLenFld

 

Num

Takes 6 parameters, FieldBase, Destination, Function, Source, Value, IfLenFld

 

MergeRecords

Takes 5 parameters, FieldBase, GroupBy, MergeField, Delimiter, bKeepBlanks

 

MergeFields

Takes 4 parameters, FieldBase, Destination, SourceFields, Delimiter

 

PickFirstField

Takes three parameters, FieldBase, Destination, SourceFields

 

Parse

Takes seven parameters, FieldBase, Destination, Source, bAny, Delimiter, Item, IfLenFld

 

Offset

Takes 7 parameters, FieldBase, Destination, Source, OffsetVal, Operator, OpValue, IfLenFld

 

Value

Takes four parameters, FieldBase, Destination, Function, IfLenFld

 

Time

Takes six parameters, FieldBase, Destination, Function, Source, Value, IfLenFld

 

Text

Takes six parameters, FieldBase, Destination, Function, Source, Value, IfLenFld

 

Lang

Takes four parameters, FieldBase, Destination, Source, IfLenFld

 

WithGroup

Takes six parameters, FieldBase, GroupByField, Destination, Action, Source, IfLenFld

 

WithAll

Takes five parameters, FieldBase, Destination, Action, Source, IfLenFld

 

SetIfAny

Takes a variable number of parameters, FieldBase, Destination, Source, Test1, Test2, [etc...]

 

SetIfAll

Takes a variable number of parameters, FieldBase, Destination, Source, Test1, Test2, [etc...]

 

SetIf

Takes six parameters, FieldBase, Destination, Source, Left, Comparison, Right

 

Sort

Takes two parameters, FieldBase, SortFieldList

 

SetNew

Takes four parameters, FieldBase, FieldName, Source, IfLenFld

 

SetLast

Takes four parameters, FieldBase, Destination, Source, IfLenFld

 

Format

Takes five parameters, FieldBase, FieldList, Mask, bBlanks2Zero, IfLenFld

 

Files

Takes 5 parameters, FieldBase, Destination, Action, Source, IfLenFld

 

EnsureFields

Takes two parameters, FieldBase, FieldNames

 

Geo

Takes nine parameters, FieldBase, Destination, Function, Source1, Source2, Source3, Source4, Options, IfLenFld

 

JsonEmbed

Has six parameters, UniqueParent, DestField, FieldBase, UniqueChild, EmbedFields, Options

 

Images

Takes up to 6 parameters, FieldBase, FileName, Action, Val1, Val2, IfLenField

 

Group

Takes 7 parameters, FieldBase, GroupBy, GroupTotals, GrandTotals, Seperator, TotalPre, TotalPost

 

TopQuery

Takes one parameter, FieldBase

 

[Pull] List of Fields from another Query

Takes three parameters, QueryName, FieldBase, FieldNames

 

ForeignWith

Takes a single parameter, a FieldBase

 

TopWith

Takes one parameter, FieldBase

 

DeleteFields

Takes two parameters, FieldBase, FieldNameList

 

Lookup

Takes six parameters, FieldBase, Destination, Table, Alias, SourceField, IfLenFld

 

WorkWith

Takes one parameter, FieldBase

 

KeepIfAny

Takes a variable number of parameters, FieldBase, Test1, Test2, [etc...]

 

KeepIfAll

Takes a variable number of parameters, FieldBase, Test1, Test2, [etc..]

 

KeepIfSimilar

Takes 3 parameters, FieldBase, pOne, pTwo

 

KeepIfFound

Takes 3 parameters, FieldBase, Fields, SearchTerms

 

KeepIf

Takes 4 parameters, FieldBase, Left, Comparison, Right

 

NameField

Takes three parameters, FieldBase, OldFieldName, NewFieldName

 

NewFields

Takes two parameters, FieldBase, FieldNames

 

KeepFields

Takes two parameters, FieldBase, FieldNamesList

 

LTrimFields

Takes one parameter, FieldBaseToTrim

 

LFillFields

Takes one parameter, a FieldBase

 

Pivot

Takes two parameters, FieldBase, PivotField

 

EnsureNavFields

Takes two parameters, FieldBase, FieldNamesList

 

ParseRecords

Takes two parameters, WorkFieldBase + FieldToParse, Delimiter

 

Plus8Decode

Takes three parameters, FieldBase, Fields, IfLenFld

 

Build

Takes a variable number of parameters

 

Math

Takes a variable number of parameters

 

Using the Backtick `

Some Work Query command parameters can accept a source of either a Work Query Field name or a text literal. Text literals in these cases are prefixed with a backtick ` character.