Search Results for workquery

 

WorkQuery

Takes one parameter, QueryName

 

Public Method WorkQuery Example

In this example, you will see how to use a public method that works on or with the current WorkQuery that you pass into the method.

 

LoadRawFile

Takes one parameter, FilePath

 

LoadNulFile

Takes two parameters, FileName, bHasHeader

 

MergeRecords

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

 

LoadTabFileWS

Takes two parameters, FileName, bHasHeader

 

LoadTabFile

Takes two parameters, FileName, bHasHeader

 

LoadCsvFileWS

Takes two parameters, FileName, bHasHeader

 

JsonEmbed

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

 

CsvStreamWS

Takes two parameters, CSVData, bNoHeaders

 

KeepIfFound

Takes 3 parameters, FieldBase, Fields, SearchTerms

 

LoadCsvFile

Takes two parameters, FileName, bHasHeader

 

ListQueries

Takes no parameters

 

NulStream

Takes two parameters, Data, bHasHeader

 

TabStream

Takes two parameters, Data, bHasHeader

 

SetEnsure

Takes two parameters, FieldName, Value

 

TabStreamWS

Takes two parameters, CSVData, bNoHeaders

 

HtmlDTable

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

 

XmlStream

Takes one parameter, Data

 

SaveTabFile

Takes two parameters, FileName, bUseHeader

 

Pull

Takes three parameters, QueryName, FieldBase, FieldNames

 

Pivot

Takes two parameters, FieldBase, PivotField

 

SaveCsvFile

Takes two parameters, FilePath, bUseHeader

 

SaveRawFile

Takes two parameters, FileName, bUseHeaders

 

SaveNulFile

Takes two parameters, FileName, bUseHeader

 

ApplyLang$

Takes one parameter

 

[WQName]

Has no parameters

 

CsvStream$

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

 

Greg$

Takes one parameter, a gregorian number

 

Greg%

Takes one parameter, a date of the form yyyy-mm-dd

 

[WQFieldList]

Has no parameters

 

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.

 

HttpSoap$

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

 

Detach

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

 

Delete

Takes two parameters, TableName and a boolean expression

 

Search

Takes three parameters, TableName, SearchTerms, SearchInFields

 

CsvStream

Takes two parameters, CSVData, bNoHeaders

 

Update

Takes two parameters, TableName, IfLenFld

 

Backfill

Has no parameters

 

NulStream$

Takes one parameter, bNoHeader

 

Len%

Takes one parameter, a Source value

 

TabStream$

Takes one parameter, bNoHeaders

 

Attach

Takes 3 parameters, ParentTableName, ChildTableName, IfLenFld

 

WebSafe$

Takes one parameter, Source