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.

 

LoadNulFile

Takes two parameters, FileName, bHasHeader

 

LoadPipeFileWS

Takes two parameters, FileName, bHasHeader

 

LoadRawFile

Takes one parameter, FilePath

 

MergeRecords

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

 

LoadTabFileWS

Takes two parameters, FileName, bHasHeader

 

LoadTabFile

Takes two parameters, FileName, bHasHeader

 

ListQueries

Takes no parameters

 

KeepIfFound

Takes 3 parameters, FieldBase, Fields, SearchTerms

 

JsonEmbed

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

 

LoadJsonFile

Takes two parameters, PathToFile, Options

 

LoadCsvFileWS

Takes two parameters, FileName, bHasHeader

 

LoadCsvFile

Takes two parameters, FileName, bHasHeader

 

TabStream

Takes two parameters, Data, bHasHeader

 

SetEnsure

Takes two parameters, FieldName, Value

 

SaveTabFile

Takes two parameters, FileName, bUseHeader

 

HtmlDTable

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

 

XmlStream

Takes one parameter, Data

 

TabStreamWS

Takes two parameters, CSVData, bNoHeaders

 

Pull

Takes three parameters, QueryName, FieldBase, FieldNames

 

Pivot

Takes two parameters, FieldBase, PivotField

 

NulStream

Takes two parameters, Data, bHasHeader

 

SaveRawFile

Takes two parameters, FileName, bUseHeaders

 

SaveNulFile

Takes two parameters, FileName, bUseHeader

 

SaveCsvFile

Takes two parameters, FilePath, bUseHeader

 

CsvStreamWS

Takes two parameters, CSVData, bNoHeaders

 

ApplyLang$

Takes one parameter

 

[WQName]

Has no parameters

 

[WQFieldList]

Has no parameters

 

Greg$

Takes one parameter, a gregorian number

 

Greg%

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

 

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

 

LoadPipeFile

Takes two parameters, FileName, bHasHeader

 

[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.

 

Remote

Takes three parameters, Url, InputQuery, OutputQuery

 

Detach

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

 

Delete

Takes two parameters, TableName and a boolean expression

 

Backfill

Has no parameters

 

CsvStream

Takes two parameters, CSVData, bNoHeaders

 

Update

Takes two parameters, TableName, IfLenFld

 

Search

Takes three parameters, TableName, SearchTerms, SearchInFields

 

NulStream$

Takes one parameter, bNoHeader

 

Len%

Takes one parameter, a Source value

 

HttpSoap$

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

 

Attach

Takes 3 parameters, ParentTableName, ChildTableName, IfLenFld

 

WebSafe$

Takes one parameter, Source

 

TabStream$

Takes one parameter, bNoHeaders