Search Results for blank

 

[_$] Currency if not blank (Top Query)

Has no parameters. If the field is blank it will remain blank.

 

[_#] Format if not blank (Top Query)

Takes 1 parameter, a formatting mask

 

 

 

 

[_#] Format if not blank (DB Field Attribute)

Takes 1 parameter, a formatting mask

 

 

 

 

 

MergeRecords

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

 

Format

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

 

New

Takes two parameters, TableName, IfLenFld

 

NewTable

Takes two parameters, TableName, AutoAlias

 

ParentsAlias

Takes three parameters, ChildTableName, ParentTableName, Mode

 

Parents

Takes three parameters, ChildTableName, ParentTableName, Mode

 

HttpCookie

Takes 6 parameters, Name, Value, Path, Domain, Expires, Other

 

Children

Takes two parameters, ChildTableName, Mode

 

Delete

Takes two parameters, TableName and a boolean expression

 

ChildrenAlias

Takes two parameters, ChildTableName, Mode

 

Logout

Takes one parameter, SessionID

 

Attach

Takes 3 parameters, ParentTableName, ChildTableName, IfLenFld

 

Detach

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

 

Left$

Takes two parameters, Source, Value

 

JsonStream$

Has one parameter, Options

 

RawStream$

Has no parameters

 

Login$

Takes three parameters, Login, Password, bRememberMe

 

IsGroupType$

Takes two parameters: Username, GroupTypes

 

HttpSoap$

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

 

JsonEncode$

Has two parameters: Source, Options

 

IsValidAlias$

Takes one parameter, a Source value

 

HtmlHistory

Takes two parameters, Title, Path

 

HtmlAButton

Takes 6 parameters, Location, Mode, ActionLabel, ActionPath, Class, Extra.

 

HtmlUpload

Takes seven parameters, Location, Mode, Prompt, Path, Class, Name, HelpText

 

HtmlSearchBox

Takes 6 parameters, Location, Mode, ActionPath, Name, Class, Prompt

 

Similar%

Takes 2 parameters, pNum1, pNum2

 

Shell$

Takes two parameters Command, Options

 

TimeZone$

Takes two parameters, Source, Value

 

Similar$

Takes 2 parameters, pString1, pString2

 

Search

Takes three parameters, TableName, SearchTerms, SearchInFields

 

Value

Takes four parameters, FieldBase, Destination, Function, IfLenFld

 

SSReference

A command to help build spreadsheets

 

WithGroup

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

 

WithAll

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

 

SaveJsonFile

Takes two parameters, FileName, Options

 

ResetFields

Takes two parameters, FieldBase, FieldNames

 

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

 

HtmlNav

Takes 7 parameters, Location, Mode, Title, TitleLink, Class, HtmlPre, HtmlApn

 

HtmlForm

Takes 6 parameters, Location, Mode, ActionLabel, ActionPath, Class, ActionMethod

 

HtmlTab

Takes 3 parameters, Location, Mode, bWithNoHeader

 

HtmlNavbar

Takes 10 parameters, Location, Mode, Title, TitleLink, Class, Fixed, bUseContainer, bNotResponsive, bInverted, HtmlPre, HtmlApn

 

HtmlDropdown

Takes 5 parameters, Location, Mode, Title, Element, Class

 

XmlMerge

Takes two parameters, [WorkWith]+Scope, EmbedScope

 

HtmlETable

Takes 6 parameters, Location, Mode, Div, Data, Script, Extra

 

HtmlDTable

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

 

Group

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

 

FixFields

Takes one parameter, a single character

 

KeepIf

Takes 4 parameters, FieldBase, Left, Comparison, Right

 

Images

Takes up to 6 parameters, FieldBase, Destination, Action, Source, Value, IfLenField

 

Build

Takes a variable number of parameters

 

Update

Takes two parameters, TableName, IfLenFld

 

Files

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

 

EnsureNavFields

Takes two parameters, FieldBase, FieldNamesList

 

ParseRecords

Takes two parameters, WorkFieldBase + FieldToParse, Delimiter

 

NewRecords

Takes one parameter, QuantityToAdd

 

Pull

Takes three parameters, QueryName, FieldBase, FieldNames

 

PickFirstField

Takes three parameters, FieldBase, Destination, SourceFields

 

KeepIfAny

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

 

KeepIfAll

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

 

Math

Takes a variable number of parameters

 

KeepIfFound

Takes 3 parameters, FieldBase, Fields, SearchTerms

 

Public Method

A Public Method may be called from any other Procedure, by the Default plug-in as part of the CMS.

 

Remote Method

A Remote Method may be called by any other Moxie system. It can be used to divide up a large system among a number of backend servers, or as a public API for 3rd parties. In order to call a Remote Method from MOX, the Remote statement is used.

 

Soapbox Studios

Effective Websites. Downtown Quality, Small Town Affordability.

 

[Raw] Raw HTML

Accepts one parameter which is the raw HTML content to be placed in the form at the Field's location.

 

[Score] 0.0 to 10

Accepts 3 parameters, first is required, 2nd and 3rd are optional. A trailing optional expression after an = sign may also assign a value on the same line.

 

PaaS Method

A PaaS Method may be called by any other Moxie system. In order to call a PaaS Method from MOX, the PaaS statement is used.

 

CFPurge

Takes one parameter, the URL to purge from CloudFlare's cache

 

[Ensure] Field Exists

Takes a variable number of parameters, a comma separated list of TopQuery variable names

 

File

Takes three parameters, Destination, Action, Source

 

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.

 

AjaxReply

Has no parameters

 

Call

Takes a variable number of parameters

 

[!] Limited Selection List (DB Field Attribute)

Parameter is a comma separated list (using CSV rules and not in quotes) of the options made available to the user which are enforced on save.

 

Learn More about Frontend Development

Prerequisites: This tutorial assumes that you have already set up a Category and Procedure if necessary. This page covers some of the basics that are involved in Front End development using the MOX language.

 

Learn More About Managing Files

Prerequisites: This tutorial assumes that you have already set up your Moxie.Build server and logged in. This page covers some of the basics that are involved in managing files and folders in the Moxie.Build system.

 

Learn More About the Content Management System

Prerequisites: This page assumes that you have already set up your Moxie.Build server and logged in as an admin user. This page covers some of the basics that are involved in using the Content Management aspects of the Moxie.Build system.

 

Get Started with Service Setup on a Server

A single Windows OS can host many instances of Moxie.Build, these steps will guide you through the setup process.

 

Get Started with Setting up the Development Environment

Developing in Moxie.Build on localhost give you the advantage of working with the template files natively. When working on procedures (MOX code) you need to access that through the Procedures page in the Admin area of a Moxie.Build system, if running the server on localhost or on a remote server. When running on a remote server, you can edit the template files via the Files page in the Admin area.

 

 

MOX Coding and Programing Language Syntax Documentation

The MOX coding and programming language pays heritage to BASIC, but has been crafted for the specific type of work and environment that is demanded of Moxie.Build.

 

[Ajax]

Takes 3 parameters, Event, DestinationID, Path

 

 

Licensing

Moxie.Build, in short, may be used and licensed free of charge for education and non-profit organizations. Whenever it is used by government or for-profit organizations the license is granted on a subscription basis.

Moxie.Build includes a number of open source components as part of its distribution; each is subject to their own licenses as included with the files for those components.

 

Help with Markdown

Markdown enables simple formatting of plain text via easy to remember conventions. This page will provide you with some pointers on what formatting options are available with "Moxie Flavored Markdown".

 

Style Guide, Procedures and Code Documentation

In order for source code to be more readily readable across teams, it is recommended that your source code always be styled according to this style guide.

 

Bom$

Takes one parameter

 

CheckPw$

Takes two parameters, User and Password

 

Ctid$

Has one parameter.

 

[CountIf]

Takes one parameter, TestCondition

 

[DateTime] (Top Query)

Has no parameters

 

[ ? ] Pick First (Top Query)

Parameter is a space separated list of fields to choose from

 

Greg%

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

 

Greg$

Takes one parameter, a gregorian number

 

Http$

Takes 9 parameters, ServerName, Port, bSecure, Mode, Path, ContentType, extraHeader, body, rtnHeaders

 

Dir$

Takes one parameter, a path-mask

 

FieldStream$

Takes two parameter: FieldName, Delimiter

 

GeoDistance$

Takes five parameters, Lat1, Long1, Lat2, Long2, Options

 

[!] Assert (Top Query)

Parameter is a comma separated list (using CSV rules and not in quotes) of the fixed hard coded values to select from

 

Prefix

Takes a single string as parameter, which is then appended to each line in the code block.

 

[Pull] List of Fields from another Query

Takes three parameters, QueryName, FieldBase, FieldNames

 

Remote

Takes three parameters, Url, InputQuery, OutputQuery

 

Image

Has 4 parameters, Destination, Action, Source, Value

 

NewEComQuery

Takes one parameter, QueryName

 

PaaS

Takes three parameters, Url, SaaSTenant, InputQuery, OutputQuery

 

Cloudflared Tunnel

Cloudflared Tunnel exposes applications running on your local web server on any network with an internet connection with an outbound tunnel that connects directly to Cloudflare's edge network without the need to configure inbound firewall rules.

 

Moxie.cfg Config

The Moxie.cfg file is read on server start and controls aspects that cannot be changed while the server is running.

 

Nightly Management Utility

This utility program manages a server install with one or many Moxie.Build services running by taking care of nightly tasks via a scheduled task.

 

[Reset]

Fields

 

Cloudflare Origin Certificates

Cloudflare automatically provides free client-facing certificates for your domain, even if using their free service. In addition, they provide free Origin Certificates to encrypt the connection between Cloudflare and your origin Moxie.Build server. Use this article if you are going to have Cloudflare connect to inbound open ports on your Moxie.Build server.

 

Cloudflare Integration

Cloudflare is a first and foremost a Web Application Firewall and Content Distribution Network, among other additional services.