Monkeybread Software - MBS FileMaker Plugin: MongoDB Blog

Components	All	New	MacOS		Windows		Linux		iOS
Examples	Mac & Win		Server	Client	Guides	Statistic	FMM	Blog	Deprecated	Old

MBS FileMaker Plugin Example Databases

MongoDB Blog

All examples are included with download of MBS FileMaker Plugin.

MongoDB Blog.fmp12

Overview
Tables	1
Relationships	0
Layouts	1
Scripts	24
Value Lists	0
Custom Functions	0
Custom Menus	24

File Options
Default custom menu set	[Standard FileMaker Menus]
Default theme	Enlightened
When opening file
Minimum allowed version	12.0
Login using	Account Name; Account= Admin
Allow user to save password	Off
Require iOS passcode	Off
Show Sign-in fields	Off
Switch to layout	Off
Hide all toolbars	Off
Script triggers
OnFirstWindowOpen	Off
OnLastWindowClose	Off
OnWindowOpen	Off
OnWindowClose	Off
OnFileAVPlayerChange	Off
OnWindowTransaction	Off
Thumbnail Settings
Generate Thumbnails	On; Temporary

Tables

Table Name	Statistics	Comments	Occurrences in Relationship Graph
MongoDB	13 fields defined, 1 record		MongoDB

Fields

Table Name: MongoDB - 13 Fields
Field Name	Type	Options	Comments	On Layouts	In Relationships	In Scripts	In Value Lists
PrimaryKey	Normal, Text	Auto-Enter: Context table: MongoDB Calculation: Get( UUID ) Validation: Only during data entry Not empty Unique Strict validation Storage: Repetitions: 1 Indexing: Minimal Automatically create indexes as needed Index Language: Unicode Raw	Unique identifier of each record in this table
CreationTimestamp	Normal, Timestamp	Auto-Enter: Creation timestamp Validation: Only during data entry Strict data type: 4 digit year Not empty Strict validation Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: English	Date and time each record was created
CreatedBy	Normal, Text	Auto-Enter: Creation account name Validation: Only during data entry Not empty Strict validation Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: English	Account name of the user who created each record
ModificationTimestamp	Normal, Timestamp	Auto-Enter: Modification timestamp Validation: Only during data entry Strict data type: 4 digit year Not empty Strict validation Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: English	Date and time each record was last modified
ModifiedBy	Normal, Text	Auto-Enter: Modification account name Validation: Only during data entry Not empty Strict validation Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: English	Account name of the user who last modified each record
Name	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: English		MongoDB		UpdateOne UpdateMany Replace Insert One DeleteWithName Search by Name
Age	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: English		MongoDB		UpdateOne UpdateMany
URI	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: English		MongoDB		Connection
Collection	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: English		MongoDB		UseCollection
Database	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: English		MongoDB		UseDatabase
Result	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: English		MongoDB		FindCollections FindDatabase Search by Name Search by Age Show All DatabaseCommand
CursorLimit	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: English		MongoDB		SetCursorLimit
Command	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: English		MongoDB		DatabaseCommand

Layout Objects: MongoDB

Regular Fields

Field Name: MongoDB::URI

Layout Name:

MongoDB

Top: 93 pt
Left: 17 pt
Bottom: 114 pt
Right: 261 pt

Anchoring: Left, Top

Field Format:

Edit Box

Field Behavior:

Allow field to be entered: In Find mode, In Browse mode
Touch keyboard type: Default for Data Type
Go to next field using: Tab key

Yes

Field Name: MongoDB::Database

Layout Name:

MongoDB

Top: 140 pt
Left: 17 pt
Bottom: 161 pt
Right: 261 pt

Anchoring: Left, Top

Field Format:

Edit Box

Field Behavior:

Allow field to be entered: In Find mode, In Browse mode
Touch keyboard type: Default for Data Type
Go to next field using: Tab key

Yes

Field Name: MongoDB::Collection

Layout Name:

MongoDB

Top: 232 pt
Left: 17 pt
Bottom: 253 pt
Right: 261 pt

Anchoring: Left, Top

Field Format:

Edit Box

Field Behavior:

Allow field to be entered: In Find mode, In Browse mode
Touch keyboard type: Default for Data Type
Go to next field using: Tab key

Yes

Field Name: MongoDB::Name

Layout Name:

MongoDB

Top: 331 pt
Left: 17 pt
Bottom: 352 pt
Right: 261 pt

Anchoring: Left, Top

Field Format:

Edit Box

Field Behavior:

Allow field to be entered: In Find mode, In Browse mode
Touch keyboard type: Default for Data Type
Go to next field using: Tab key

Yes

Field Name: MongoDB::Age

Layout Name:

MongoDB

Top: 331 pt
Left: 277 pt
Bottom: 352 pt
Right: 521 pt

Anchoring: Left, Top

Field Format:

Edit Box

Field Behavior:

Allow field to be entered: In Find mode, In Browse mode
Touch keyboard type: Default for Data Type
Go to next field using: Tab key

Yes

Field Name: MongoDB::Result

Layout Name:

MongoDB

Top: 503 pt
Left: 17 pt
Bottom: 670 pt
Right: 501 pt

Anchoring: Left, Top

Field Format:

Edit Box

Field Behavior:

Allow field to be entered: In Find mode, In Browse mode
Touch keyboard type: Default for Data Type
Go to next field using: Tab key

Yes

Field Name: MongoDB::CursorLimit

Layout Name:

MongoDB

Top: 402 pt
Left: 17 pt
Bottom: 438 pt
Right: 116 pt

Anchoring: Left, Top

Field Format:

Edit Box

Field Behavior:

Allow field to be entered: In Find mode, In Browse mode
Touch keyboard type: Default for Data Type
Go to next field using: Tab key

Yes

Field Name: MongoDB::Command

Layout Name:

MongoDB

Top: 503 pt
Left: 508 pt
Bottom: 634 pt
Right: 744 pt

Anchoring: Left, Top

Field Format:

Edit Box

Field Behavior:

Allow field to be entered: In Find mode, In Browse mode
Touch keyboard type: Default for Data Type
Go to next field using: Tab key

Type:

Text: Connect

Layout Name:

MongoDB

Top: 93 pt
Left: 289 pt
Bottom: 115 pt
Right: 417 pt

Anchoring: Left, Top

Perform Script [ “Connection” ]

Scripts:

Connection

Button Properties

Coordinates

Script/Script Step

Type:

Text: Use Database

Layout Name:

MongoDB

Top: 140 pt
Left: 289 pt
Bottom: 162 pt
Right: 417 pt

Anchoring: Left, Top

Perform Script [ “UseDatabase” ]

Scripts:

UseDatabase

Button Properties

Coordinates

Script/Script Step

Type:

Text: List Databases

Layout Name:

MongoDB

Top: 140 pt
Left: 425 pt
Bottom: 162 pt
Right: 553 pt

Anchoring: Left, Top

Perform Script [ “ListDatabases” ]

Scripts:

ListDatabases

Button Properties

Coordinates

Script/Script Step

Type:

Text: Default Database

Layout Name:

MongoDB

Top: 166 pt
Left: 289 pt
Bottom: 188 pt
Right: 417 pt

Anchoring: Left, Top

Perform Script [ “UseDefaultDatabase” ]

Scripts:

UseDefaultDatabase

Button Properties

Coordinates

Script/Script Step

Type:

Text: End Connection

Layout Name:

MongoDB

Top: 93 pt
Left: 425 pt
Bottom: 115 pt
Right: 553 pt

Anchoring: Left, Top

Perform Script [ “Release” ]

Scripts:

Release

Button Properties

Coordinates

Script/Script Step

Type:

Text: Use Collection

Layout Name:

MongoDB

Top: 231 pt
Left: 289 pt
Bottom: 253 pt
Right: 417 pt

Anchoring: Left, Top

Perform Script [ “UseCollection” ]

Scripts:

UseCollection

Button Properties

Coordinates

Script/Script Step

Type:

Text: List Collections

Layout Name:

MongoDB

Top: 231 pt
Left: 425 pt
Bottom: 253 pt
Right: 553 pt

Anchoring: Left, Top

Perform Script [ “ListCollections” ]

Scripts:

ListCollections

Button Properties

Coordinates

Script/Script Step

Type:

Text: Current Collection

Layout Name:

MongoDB

Top: 257 pt
Left: 425 pt
Bottom: 279 pt
Right: 553 pt

Anchoring: Left, Top

Perform Script [ “CurrentCollection” ]

Scripts:

CurrentCollection

Button Properties

Coordinates

Script/Script Step

Type:

Text: New Document ( Only need Name)

Layout Name:

MongoDB

Top: 364 pt
Left: 17 pt
Bottom: 400 pt
Right: 192 pt

Anchoring: Left, Top

Perform Script [ “Insert One” ]

Scripts:

Insert One

Button Properties

Coordinates

Script/Script Step

Type:

Text: Search Documents by Name

Layout Name:

MongoDB

Top: 364 pt
Left: 201 pt
Bottom: 400 pt
Right: 376 pt

Anchoring: Left, Top

Perform Script [ “Search by Name” ]

Scripts:

Search by Name

Button Properties

Coordinates

Script/Script Step

Type:

Text: Update first Document by Name with an Age

Layout Name:

MongoDB

Top: 364 pt
Left: 385 pt
Bottom: 400 pt
Right: 560 pt

Anchoring: Left, Top

Perform Script [ “UpdateOne” ]

Scripts:

UpdateOne

Button Properties

Coordinates

Script/Script Step

Type:

Text: Library Version

Layout Name:

MongoDB

Top: 93 pt
Left: 561 pt
Bottom: 115 pt
Right: 689 pt

Anchoring: Left, Top

Perform Script [ “LibraryVersion” ]

Scripts:

LibraryVersion

Button Properties

Coordinates

Script/Script Step

Type:

Text: Set Limit

Layout Name:

MongoDB

Top: 402 pt
Left: 122 pt
Bottom: 438 pt
Right: 192 pt

Anchoring: Left, Top

Set Variable [ $$Limit; Value:MongoDB::CursorLimit ]

Fields:

MongoDB::CursorLimit

Button Properties

Coordinates

Script/Script Step

Type:

Text: Delete first document in the collection

Layout Name:

MongoDB

Top: 364 pt
Left: 569 pt
Bottom: 400 pt
Right: 744 pt

Anchoring: Left, Top

Perform Script [ “DeleteOne” ]

Scripts:

DeleteOne

Button Properties

Coordinates

Script/Script Step

Type:

Text: Delete Documents with the given "Name"

Layout Name:

MongoDB

Top: 402 pt
Left: 569 pt
Bottom: 438 pt
Right: 744 pt

Anchoring: Left, Top

Perform Script [ “DeleteWithName” ]

Scripts:

DeleteWithName

Button Properties

Coordinates

Script/Script Step

Type:

Text: Delete All Documents

Layout Name:

MongoDB

Top: 440 pt
Left: 569 pt
Bottom: 476 pt
Right: 744 pt

Anchoring: Left, Top

Perform Script [ “DeleteAll” ]

Scripts:

DeleteAll

Button Properties

Coordinates

Script/Script Step

Type:

Text: Show All (in the limit)

Layout Name:

MongoDB

Top: 440 pt
Left: 201 pt
Bottom: 476 pt
Right: 376 pt

Anchoring: Left, Top

Perform Script [ “Show All” ]

Scripts:

Show All

Button Properties

Coordinates

Script/Script Step

Type:

Text: Update all Documents by Name with an Age

Layout Name:

MongoDB

Top: 402 pt
Left: 385 pt
Bottom: 438 pt
Right: 560 pt

Anchoring: Left, Top

Perform Script [ “UpdateMany” ]

Scripts:

UpdateMany

Button Properties

Coordinates

Script/Script Step

Type:

Text: Find Collections

Layout Name:

MongoDB

Top: 283 pt
Left: 425 pt
Bottom: 305 pt
Right: 553 pt

Anchoring: Left, Top

Perform Script [ “FindCollections” ]

Scripts:

FindCollections

Button Properties

Coordinates

Script/Script Step

Type:

Text: Find Database

Layout Name:

MongoDB

Top: 140 pt
Left: 561 pt
Bottom: 162 pt
Right: 689 pt

Anchoring: Left, Top

Perform Script [ “FindDatabase” ]

Scripts:

FindDatabase

Button Properties

Coordinates

Script/Script Step

Type:

Text: Server Information

Layout Name:

MongoDB

Top: 92 pt
Left: 697 pt
Bottom: 114 pt
Right: 825 pt

Anchoring: Left, Top

Show Custom Dialog [ Message: MBS( "MongoDB.ServerDescriptions"; $$MongoDB ); Default Button: “OK”, Commit: “Yes” ]

Button Properties

Coordinates

Script/Script Step

Type:

Text: Count Documents

Layout Name:

MongoDB

Top: 231 pt
Left: 561 pt
Bottom: 253 pt
Right: 689 pt

Anchoring: Left, Top

Perform Script [ “Count” ]

Scripts:

Count

Button Properties

Coordinates

Script/Script Step

Type:

Text: Replace Document with new Document

Layout Name:

MongoDB

Top: 440 pt
Left: 385 pt
Bottom: 476 pt
Right: 560 pt

Anchoring: Left, Top

Perform Script [ “Replace” ]

Scripts:

Replace

Button Properties

Coordinates

Script/Script Step

Type:

Text: Database Command

Layout Name:

MongoDB

Top: 638 pt
Left: 508 pt
Bottom: 670 pt
Right: 744 pt

Anchoring: Left, Top

Perform Script [ “DatabaseCommand” ]

Scripts:

DatabaseCommand

Button Properties

Coordinates

Script/Script Step

Type:

Text: Show Documents with an age less then 20

Layout Name:

MongoDB

Top: 402 pt
Left: 201 pt
Bottom: 438 pt
Right: 376 pt

Anchoring: Left, Top

Perform Script [ “Search by Age” ]

Scripts:

Search by Age

Script Hierarchy

Next Script: [FindDatabase]

Script Name	FindCollections
Run script with full access privileges	Off
Siri Shortcut Visible	Off
Include In Menu	No
Layouts that use this script	MongoDB
Scripts that use this script
Script Definition
Script Steps	#Gives us a JSON with collection information Set Variable [ $r; Value:MBS("MongoDB.FindCollections"; $$MongoDB; "{}") ] If [ MBS("IsError") ] Show Custom Dialog [ Title: "Error"; Message: $r; Default Button: “OK”, Commit: “Yes” ] End If Set Variable [ $Result; Value:"" ] Loop [ Flush: Always ] Set Variable [ $res; Value:MBS("MongoDB.CursorNext"; $$MongoDB) ] Exit Loop If [ MBS("IsError") or Length ( $res ) = 0 ] Set Variable [ $Result; Value:$Result & $res & "¶" ] End Loop Set Field [ MongoDB::Result; $Result ]
Fields used in this script	MongoDB::Result
Scripts used in this script
Layouts used in this script
Tables used in this script	MongoDB
Table occurrences used by this script	MongoDB
Custom Functions used by this script
Custom menu set used by this script

Previous Script: [FindCollections]

Next Script: [UseCollection]

Script Name	FindDatabase
Run script with full access privileges	Off
Siri Shortcut Visible	Off
Include In Menu	No
Layouts that use this script	MongoDB
Scripts that use this script
Script Definition
Script Steps	#Gives us a JSON with database information Set Variable [ $r; Value:MBS( "MongoDB.FindDatabases"; $$MongoDB ) ] If [ MBS("IsError") ] Show Custom Dialog [ Title: "Error"; Message: $r; Default Button: “OK”, Commit: “Yes” ] End If Set Variable [ $Result; Value:"" ] Loop [ Flush: Always ] Set Variable [ $res; Value:MBS("MongoDB.CursorNext"; $$MongoDB) ] Exit Loop If [ MBS("IsError") or Length ( $res ) = 0 ] Set Variable [ $Result; Value:$Result & $res & "¶" ] End Loop Set Field [ MongoDB::Result; $Result ]
Fields used in this script	MongoDB::Result
Scripts used in this script
Layouts used in this script
Tables used in this script	MongoDB
Table occurrences used by this script	MongoDB
Custom Functions used by this script
Custom menu set used by this script

Previous Script: [FindDatabase]

Next Script: [UpdateOne]

Script Name	UseCollection
Run script with full access privileges	Off
Siri Shortcut Visible	Off
Include In Menu	No
Layouts that use this script	MongoDB
Scripts that use this script
Script Definition
Script Steps	#Set the current collection Set Variable [ $r; Value:MBS( "MongoDB.OpenCollection"; $$MongoDB; MongoDB::Collection) ] If [ MBS("IsError") ] Show Custom Dialog [ Title: "Error"; Message: $r; Default Button: “OK”, Commit: “Yes” ] End If
Fields used in this script	MongoDB::Collection
Scripts used in this script
Layouts used in this script
Tables used in this script	MongoDB
Table occurrences used by this script	MongoDB
Custom Functions used by this script
Custom menu set used by this script

Previous Script: [UseCollection]

Next Script: [UpdateMany]

Script Name	UpdateOne
Run script with full access privileges	Off
Siri Shortcut Visible	Off
Include In Menu	No
Layouts that use this script	MongoDB
Scripts that use this script
Script Definition
Script Steps	#Update a document. We add the key Age, but we can also can change the Name Set Variable [ $r; Value:MBS( "MongoDB.UpdateOne"; $$MongoDB; "{\"Name\": \""&MongoDB::Name&"\"}"; "{\"$set\": {\"Age\": "&MongoDB::Age&"}}") ] If [ MBS("IsError") ] Show Custom Dialog [ Title: "Error"; Message: $r; Default Button: “OK”, Commit: “Yes” ] Exit Script [ ] End If Perform Script [ “Show All” ]
Fields used in this script	MongoDB::Name MongoDB::Age
Scripts used in this script	Show All
Layouts used in this script
Tables used in this script	MongoDB
Table occurrences used by this script	MongoDB
Custom Functions used by this script
Custom menu set used by this script

Previous Script: [UpdateOne]

Next Script: [SetCursorLimit]

Script Name	UpdateMany
Run script with full access privileges	Off
Siri Shortcut Visible	Off
Include In Menu	No
Layouts that use this script	MongoDB
Scripts that use this script
Script Definition
Script Steps	#We can update not only a single record but several records at the same time that match a criteria we specify in a JSON. If this JSON is an empty object, then all records are referred to. In this case we update documents that have a special name and add an age to it Set Variable [ $r; Value:MBS( "MongoDB.UpdateMany"; $$MongoDB; "{\"Name\": \""&MongoDB::Name&"\"}"; "{\"$set\": {\"Age\": "&MongoDB::Age&"}}") ] If [ MBS("IsError") ] Show Custom Dialog [ Title: "Error"; Message: $r; Default Button: “OK”, Commit: “Yes” ] Exit Script [ ] End If Perform Script [ “Show All” ]
Fields used in this script	MongoDB::Name MongoDB::Age
Scripts used in this script	Show All
Layouts used in this script
Tables used in this script	MongoDB
Table occurrences used by this script	MongoDB
Custom Functions used by this script
Custom menu set used by this script

Previous Script: [UpdateMany]

Next Script: [CurrentCollection]

Script Name	SetCursorLimit
Run script with full access privileges	Off
Siri Shortcut Visible	Off
Include In Menu	No
Layouts that use this script
Scripts that use this script	Search by Name Search by Age Show All
Script Definition
Script Steps	#Set the cursor limit. Is called after a find Set Variable [ $r; Value:MBS( "MongoDB.CursorSetLimit"; $$MongoDB ; MongoDB::CursorLimit ) ] If [ MBS("IsError") ] Show Custom Dialog [ Title: "Error"; Message: $r; Default Button: “OK”, Commit: “Yes” ] End If
Fields used in this script	MongoDB::CursorLimit
Scripts used in this script
Layouts used in this script
Tables used in this script	MongoDB
Table occurrences used by this script	MongoDB
Custom Functions used by this script
Custom menu set used by this script

Previous Script: [SetCursorLimit]

Next Script: [Connection]

Script Name	CurrentCollection
Run script with full access privileges	Off
Siri Shortcut Visible	Off
Include In Menu	No
Layouts that use this script	MongoDB
Scripts that use this script
Script Definition
Script Steps	#Query the current in use collection Show Custom Dialog [ Title: "Current Collection"; Message: MBS( "MongoDB.CollectionName"; $$MongoDB ); Default Button: “OK”, Commit: “Yes” ]
Fields used in this script
Scripts used in this script
Layouts used in this script
Tables used in this script
Table occurrences used by this script
Custom Functions used by this script
Custom menu set used by this script

Previous Script: [CurrentCollection]

Next Script: [ListDatabases]

Script Name	Connection
Run script with full access privileges	Off
Siri Shortcut Visible	Off
Include In Menu	No
Layouts that use this script	MongoDB
Scripts that use this script
Script Definition
Script Steps	#Connect us to the Server #Old connections are cleaned up If [ $$MongoDB ≠ "" ] Set Variable [ $r; Value: MBS( "MongoDB.Release"; $$MongoDB ) ] // Set Variable [ $r; Value: MBS( "MongoDB.ReleaseAll" ) ] End If #Get a new reference number Set Variable [ $$MongoDB; Value:MBS( "MongoDB.New" ) ] If [ MBS("IsError") ] Show Custom Dialog [ Title: "Error"; Message: $$MongoDB; Default Button: “OK”, Commit: “Yes” ] Exit Script [ ] End If #Set the URI from the field Set Variable [ $r; Value:MBS( "MongoDB.SetURI"; $$MongoDB; MongoDB::URI ) ] If [ MBS("IsError") ] Show Custom Dialog [ Title: "Error"; Message: $r; Default Button: “OK”, Commit: “Yes” ] Exit Script [ ] End If #Connect to the server Set Variable [ $r; Value:MBS( "MongoDB.Connect"; $$MongoDB) ] If [ MBS("IsError") ] Show Custom Dialog [ Title: "Error"; Message: $r; Default Button: “OK”, Commit: “Yes” ] Else [ ] Show Custom Dialog [ Title: "Connection"; Message: "OK"; Default Button: “OK”, Commit: “Yes” ] End If
Fields used in this script	MongoDB::URI
Scripts used in this script
Layouts used in this script
Tables used in this script	MongoDB
Table occurrences used by this script	MongoDB
Custom Functions used by this script
Custom menu set used by this script

Previous Script: [Connection]

Next Script: [UseDatabase]

Script Name	ListDatabases
Run script with full access privileges	Off
Siri Shortcut Visible	Off
Include In Menu	No
Layouts that use this script	MongoDB
Scripts that use this script
Script Definition
Script Steps	#Gives us a list of databases located on the server Show Custom Dialog [ Title: "List of Databases"; Message: MBS( "MongoDB.DatabasesNames"; $$MongoDB ); Default Button: “OK”, Commit: “Yes” ]
Fields used in this script
Scripts used in this script
Layouts used in this script
Tables used in this script
Table occurrences used by this script
Custom Functions used by this script
Custom menu set used by this script

Previous Script: [ListDatabases]

Next Script: [Release]

Script Name	UseDatabase
Run script with full access privileges	Off
Siri Shortcut Visible	Off
Include In Menu	No
Layouts that use this script	MongoDB
Scripts that use this script
Script Definition
Script Steps	#Sets the database as the database we want to use Set Variable [ $r; Value:MBS( "MongoDB.OpenDatabase"; $$MongoDB; MongoDB::Database ) ] If [ MBS("IsError") ] Show Custom Dialog [ Title: "Error"; Message: $r; Default Button: “OK”, Commit: “Yes” ] End If
Fields used in this script	MongoDB::Database
Scripts used in this script
Layouts used in this script
Tables used in this script	MongoDB
Table occurrences used by this script	MongoDB
Custom Functions used by this script
Custom menu set used by this script

Previous Script: [UseDatabase]

Next Script: [LibraryVersion]

Script Name	Release
Run script with full access privileges	Off
Siri Shortcut Visible	Off
Include In Menu	No
Layouts that use this script	MongoDB
Scripts that use this script
Script Definition
Script Steps	#Release all connections Set Variable [ $r; Value: MBS( "MongoDB.ReleaseAll" ) ] If [ MBS("IsError") ] Show Custom Dialog [ Title: "Error"; Message: $r; Default Button: “OK”, Commit: “Yes” ] End If
Fields used in this script
Scripts used in this script
Layouts used in this script
Tables used in this script
Table occurrences used by this script
Custom Functions used by this script
Custom menu set used by this script

Previous Script: [Release]

Next Script: [ListCollections]

Script Name	LibraryVersion
Run script with full access privileges	Off
Siri Shortcut Visible	Off
Include In Menu	No
Layouts that use this script	MongoDB
Scripts that use this script
Script Definition
Script Steps	#Query the library version Show Custom Dialog [ Title: "Library Version"; Message: MBS( "MongoDB.LibraryVersion" ); Default Button: “OK”, Commit: “Yes” ]
Fields used in this script
Scripts used in this script
Layouts used in this script
Tables used in this script
Table occurrences used by this script
Custom Functions used by this script
Custom menu set used by this script

Previous Script: [LibraryVersion]

Next Script: [Replace]

Script Name	ListCollections
Run script with full access privileges	Off
Siri Shortcut Visible	Off
Include In Menu	No
Layouts that use this script	MongoDB
Scripts that use this script
Script Definition
Script Steps	#Gives us a list of collections located in the current database Show Custom Dialog [ Title: "List of Collections"; Message: MBS( "MongoDB.CollectionNames";$$MongoDB ); Default Button: “OK”, Commit: “Yes”; Button 2: “Abbrechen”, Commit: “No” ]
Fields used in this script
Scripts used in this script
Layouts used in this script
Tables used in this script
Table occurrences used by this script
Custom Functions used by this script
Custom menu set used by this script

Previous Script: [ListCollections]

Next Script: [UseDefaultDatabase]

Script Name	Replace
Run script with full access privileges	Off
Siri Shortcut Visible	Off
Include In Menu	No
Layouts that use this script	MongoDB
Scripts that use this script
Script Definition
Script Steps	#Replaces a document with a document that can have completely different fields Set Variable [ $r; Value:MBS( "MongoDB.ReplaceOne"; $$MongoDB; "{\"Name\":\""& MongoDB::Name &"\"}"; "{\"Typ\": \"clothes\", \"ArtNum\": 1234, \"InStock\": true, \"Age\": 3}") ] If [ MBS("IsError") ] Show Custom Dialog [ Title: "Error"; Message: $r; Default Button: “OK”, Commit: “Yes” ] End If Perform Script [ “Show All” ]
Fields used in this script	MongoDB::Name
Scripts used in this script	Show All
Layouts used in this script
Tables used in this script	MongoDB
Table occurrences used by this script	MongoDB
Custom Functions used by this script
Custom menu set used by this script

Previous Script: [Replace]

Next Script: [Insert One]

Script Name	UseDefaultDatabase
Run script with full access privileges	Off
Siri Shortcut Visible	Off
Include In Menu	No
Layouts that use this script	MongoDB
Scripts that use this script
Script Definition
Script Steps	#Set the default database the current database Set Variable [ $r; Value:MBS( "MongoDB.OpenDefaultDatabase"; $$MongoDB) ] If [ MBS("IsError") ] Show Custom Dialog [ Title: "Error"; Message: $r; Default Button: “OK”, Commit: “Yes” ] End If
Fields used in this script
Scripts used in this script
Layouts used in this script
Tables used in this script
Table occurrences used by this script
Custom Functions used by this script
Custom menu set used by this script

Previous Script: [UseDefaultDatabase]

Next Script: [DeleteAll]

Script Name	Insert One
Run script with full access privileges	Off
Siri Shortcut Visible	Off
Include In Menu	No
Layouts that use this script	MongoDB
Scripts that use this script
Script Definition
Script Steps	#We add a single document with the specified name to the collection Set Variable [ $r; Value:MBS( "MongoDB.InsertOne"; $$MongoDB; " { \"Name\": \""&MongoDB::Name&"\"}" ) ] If [ MBS("IsError") ] Show Custom Dialog [ Title: "Error"; Message: $r; Default Button: “OK”, Commit: “Yes” ] Exit Script [ ] End If Perform Script [ “Show All” ]
Fields used in this script	MongoDB::Name
Scripts used in this script	Show All
Layouts used in this script
Tables used in this script	MongoDB
Table occurrences used by this script	MongoDB
Custom Functions used by this script
Custom menu set used by this script

Previous Script: [Insert One]

Next Script: [DeleteWithName]

Script Name	DeleteAll
Run script with full access privileges	Off
Siri Shortcut Visible	Off
Include In Menu	No
Layouts that use this script	MongoDB
Scripts that use this script
Script Definition
Script Steps	#Delete all documents in the collection Set Variable [ $r; Value:MBS( "MongoDB.DeleteMany"; $$MongoDB; "{}" ) ] Perform Script [ “Show All” ]
Fields used in this script
Scripts used in this script	Show All
Layouts used in this script
Tables used in this script
Table occurrences used by this script
Custom Functions used by this script
Custom menu set used by this script

Previous Script: [DeleteAll]

Next Script: [DeleteOne]

Script Name	DeleteWithName
Run script with full access privileges	Off
Siri Shortcut Visible	Off
Include In Menu	No
Layouts that use this script	MongoDB
Scripts that use this script
Script Definition
Script Steps	#Delete all documents with a given Name Set Variable [ $r; Value:MBS( "MongoDB.DeleteMany"; $$MongoDB; "{\"Name\": \""& MongoDB::Name &"\" }" ) ] Perform Script [ “Show All” ]
Fields used in this script	MongoDB::Name
Scripts used in this script	Show All
Layouts used in this script
Tables used in this script	MongoDB
Table occurrences used by this script	MongoDB
Custom Functions used by this script
Custom menu set used by this script

Previous Script: [DeleteWithName]

Next Script: [Search by Name]

Script Name	DeleteOne
Run script with full access privileges	Off
Siri Shortcut Visible	Off
Include In Menu	No
Layouts that use this script	MongoDB
Scripts that use this script
Script Definition
Script Steps	#Delete the first document Set Variable [ $r; Value:MBS( "MongoDB.DeleteOne"; $$MongoDB; "{}" ) ] Perform Script [ “Show All” ]
Fields used in this script
Scripts used in this script	Show All
Layouts used in this script
Tables used in this script
Table occurrences used by this script
Custom Functions used by this script
Custom menu set used by this script

Previous Script: [DeleteOne]

Next Script: [Search by Age]

Script Name	Search by Name
Run script with full access privileges	Off
Siri Shortcut Visible	Off
Include In Menu	No
Layouts that use this script	MongoDB
Scripts that use this script
Script Definition
Script Steps	#Find all documents with a given name Set Variable [ $r; Value:MBS("MongoDB.Find"; $$MongoDB;"{\"Name\":\"" & MongoDB::Name & "\"}") ] If [ MBS("IsError") ] Show Custom Dialog [ Title: "Error"; Message: $r; Default Button: “OK”, Commit: “Yes” ] End If #Set Limit if it was set If [ $$Limit>0 ] Perform Script [ “SetCursorLimit” ] End If #Runs the cursor over the find Set Variable [ $Result; Value:"" ] Loop [ Flush: Always ] Set Variable [ $res; Value:MBS("MongoDB.CursorNext"; $$MongoDB) ] Exit Loop If [ MBS("IsError") or Length ( $res ) = 0 ] Set Variable [ $Result; Value:$Result & $res & "¶" ] End Loop Set Field [ MongoDB::Result; $Result ]
Fields used in this script	MongoDB::Name MongoDB::Result
Scripts used in this script	SetCursorLimit
Layouts used in this script
Tables used in this script	MongoDB
Table occurrences used by this script	MongoDB
Custom Functions used by this script
Custom menu set used by this script

Previous Script: [Search by Name]

Next Script: [Show All]

Script Name	Search by Age
Run script with full access privileges	Off
Siri Shortcut Visible	Off
Include In Menu	No
Layouts that use this script	MongoDB
Scripts that use this script
Script Definition
Script Steps	#Find all documents with an age < 20 Set Variable [ $r; Value:MBS("MongoDB.Find"; $$MongoDB;"{\"Age\": {\"$lt\": 20}}") ] If [ MBS("IsError") ] Show Custom Dialog [ Title: "Error"; Message: $r; Default Button: “OK”, Commit: “Yes” ] End If #Set Limit if it was set If [ $$Limit>0 ] Perform Script [ “SetCursorLimit” ] End If #Runs the cursor over the find Set Variable [ $Result; Value:"" ] Loop [ Flush: Always ] Set Variable [ $res; Value:MBS("MongoDB.CursorNext"; $$MongoDB) ] Exit Loop If [ MBS("IsError") or Length ( $res ) = 0 ] Set Variable [ $Result; Value:$Result & $res & "¶" ] End Loop Set Field [ MongoDB::Result; $Result ]
Fields used in this script	MongoDB::Result
Scripts used in this script	SetCursorLimit
Layouts used in this script
Tables used in this script	MongoDB
Table occurrences used by this script	MongoDB
Custom Functions used by this script
Custom menu set used by this script

Previous Script: [Search by Age]

Next Script: [Count]

Script Name	Show All
Run script with full access privileges	Off
Siri Shortcut Visible	Off
Include In Menu	No
Layouts that use this script	MongoDB
Scripts that use this script	UpdateOne UpdateMany Replace Insert One DeleteAll DeleteWithName DeleteOne
Script Definition
Script Steps	#With the find function and an empty JSON we get all documents Set Variable [ $r; Value:MBS("MongoDB.Find"; $$MongoDB;"{}") ] #Set Limit if it was set If [ $$Limit>0 ] Perform Script [ “SetCursorLimit” ] End If If [ MBS("IsError") ] Show Custom Dialog [ Title: "Error"; Message: $r; Default Button: “OK”, Commit: “Yes” ] End If #Runs the cursor over the find Set Variable [ $Result; Value:"" ] Loop [ Flush: Always ] Set Variable [ $res; Value:MBS("MongoDB.CursorNext"; $$MongoDB) ] Exit Loop If [ MBS("IsError") or Length ( $res ) = 0 ] Set Variable [ $Result; Value:$Result & $res & "¶" ] End Loop Set Field [ MongoDB::Result; $Result ]
Fields used in this script	MongoDB::Result
Scripts used in this script	SetCursorLimit
Layouts used in this script
Tables used in this script	MongoDB
Table occurrences used by this script	MongoDB
Custom Functions used by this script
Custom menu set used by this script

Previous Script: [Show All]

Next Script: [DatabaseCommand]

Script Name	Count
Run script with full access privileges	Off
Siri Shortcut Visible	Off
Include In Menu	No
Layouts that use this script	MongoDB
Scripts that use this script
Script Definition
Script Steps	#Count the documents in the current collection Show Custom Dialog [ Title: "Count"; Message: MBS( "MongoDB.EstimatedDocumentCount"; $$MongoDB ); Default Button: “OK”, Commit: “Yes” ]
Fields used in this script
Scripts used in this script
Layouts used in this script
Tables used in this script
Table occurrences used by this script
Custom Functions used by this script
Custom menu set used by this script

Previous Script: [Count]

Script Name	DatabaseCommand
Run script with full access privileges	Off
Siri Shortcut Visible	Off
Include In Menu	No
Layouts that use this script	MongoDB
Scripts that use this script
Script Definition
Script Steps	#With this function you can use database commands Set Variable [ $res; Value:MBS( "MongoDB.DatabaseCommand"; $$MongoDB; MongoDB::Command ) ] If [ MBS("IsError") ] Show Custom Dialog [ Title: "Error"; Message: $res; Default Button: “OK”, Commit: “Yes” ] Else [ ] Set Field [ MongoDB::Result; $res ] End If
Fields used in this script	MongoDB::Command MongoDB::Result
Scripts used in this script
Layouts used in this script
Tables used in this script	MongoDB
Table occurrences used by this script	MongoDB
Custom Functions used by this script
Custom menu set used by this script

Download example: MongoDB Blog

Used functions: