Search Results for workquery

 

WorkQuery

Takes one parameter, QueryName

 

JsonStream

Used to manipulate a WorkQuery into a JSON type

 

LoadRawFile

Takes one parameter, FilePath

 

LoadTabFile

Takes two parameters, FileName, bHasHeader

 

NulStream

Takes two parameters, Data, bHasHeader

 

MergeRecords

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

 

LoadNulFile

Takes two parameters, FileName, bHasHeader

 

KeepIfFound

Takes 3 parameters, FieldBase, Fields, SearchTerms

 

CsvStream

Takes two parameters, CSVData, bNoHeaders

 

LoadCsvFile

Takes two parameters, FileName, bHasHeader

 

ListQueries

Takes no parameters

 

SetEnsure

Takes two parameters, FieldName, Value

 

SaveTabFile

Takes two parameters, FileName, bUseHeaders

 

TabStream

Takes two parameters, Data, bHasHeader

 

HtmlDTable

Takes 5 parameters, Location, Mode, Class/ID, Init, bNoAutoAlign

 

XmlStream

Takes one parameter, Data

 

Pull

Takes three parameters, QueryName, FieldBase, FieldNames

 

Pivot

Takes two parameters, FieldBase, PivotField

 

SaveCsvFile

Takes one parameter, FilePath

 

SaveRawFile

Takes two parameters, FileName, bUseHeaders

 

SaveNulFile

Takes two parameters, FileName, bUseHeader

 

[WQName]

Has no parameters

 

[WQFieldList]

Has no parameters

 

ApplyLang$

Takes one parameter

 

HttpSoap$

Takes 8 parameters, ServerName, Port, bSecure, Path, ExtraHttpHeaders, Envelope, ExtraBody, xml

 

CsvStream$

Takes one parameter bNoHeaders and returns the result to an assigned variable

 

PaaS

Takes three parameters, Url, SaaSTenant, InputQuery, OutputQuery

 

FailIfRecError

Has no parameters

 

Remote

Takes three parameters, Url, InputQuery, OutputQuery

 

[AnyRecError]

Takes no 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.

 

Delete

Takes two parameters, TableName and a boolean expression

 

Backfill

Has no parameters

 

Detach

Takes 3 parameters, ParentTableName, ChildTableName, and a boolean expression (optional)

 

Update

Takes two parameters, TableName, IfLenFld

 

Search

Takes three parameters, TableName, SearchTerms, SearchInFields

 

Len%

Takes one parameter, a Source value

 

JsonStream$

Has one parameter, Options

 

NulStream$

Takes one parameter, bNoHeader

 

Attach

Takes 3 parameters, ParentTableName, ChildTableName, IfLenFld

 

WebSafe$

Takes one parameter, Source