MBS FileMaker Plugin Example Databases

LDAP Query

All examples are included with download of MBS FileMaker Plugin.

LDAP Query.fmp12

Overview
Tables1
Relationships0
Layouts1
Scripts1
Value Lists0
Custom Functions0
Custom Menus33
File Options
Default custom menu set[Standard FileMaker Menus]
When opening file
Minimum allowed version12.0
Login usingAccount Name; Account= Admin
Allow user to save passwordOff
Require iOS passcodeOff
Switch to layoutOff
Hide all toolbarsOff
Script triggers
OnFirstWindowOpenOff
OnLastWindowCloseOff
OnWindowOpenOff
OnWindowCloseOff
OnFileAVPlayerChangeOff
Thumbnail Settings
Generate ThumbnailsOn; Temporary

 

Tables

Table Name
Statistics
Occurrences in Relationship Graph
LDAP Query
13 fields defined, 0 record
LDAP Query

Fields

Table Name: LDAP Query - 13 Fields
Field NameTypeOptionsCommentsOn LayoutsIn RelationshipsIn ScriptsIn Value Lists
ServerNormal, TextAuto-Enter:
  • Allow editing
Validation:
  • Only during data entry
Storage:
  • Global
  • Repetitions: 1
  • Index Language: German
      UserNameNormal, TextAuto-Enter:
      • Allow editing
      Validation:
      • Only during data entry
      Storage:
      • Global
      • Repetitions: 1
      • Index Language: German
          PasswordNormal, TextAuto-Enter:
          • Allow editing
          Validation:
          • Only during data entry
          Storage:
          • Global
          • Repetitions: 1
          • Index Language: German
              SSLNormal, NumberAuto-Enter:
              • Allow editing
              Validation:
              • Only during data entry
              Storage:
              • Global
              • Repetitions: 1
              • Index Language: German
                  PortNormal, NumberAuto-Enter:
                  • Allow editing
                  Validation:
                  • Only during data entry
                  Storage:
                  • Global
                  • Repetitions: 1
                  • Index Language: German
                      AuthMethodNormal, TextAuto-Enter:
                      • Allow editing
                      Validation:
                      • Only during data entry
                      Storage:
                      • Global
                      • Repetitions: 1
                      • Index Language: German
                          BaseNormal, TextAuto-Enter:
                          • Allow editing
                          Validation:
                          • Only during data entry
                          Storage:
                          • Global
                          • Repetitions: 1
                          • Index Language: German
                              ScopeNormal, TextAuto-Enter:
                              • Allow editing
                              Validation:
                              • Only during data entry
                              Storage:
                              • Global
                              • Repetitions: 1
                              • Index Language: German
                                  FilterNormal, TextAuto-Enter:
                                  • Allow editing
                                  Validation:
                                  • Only during data entry
                                  Storage:
                                  • Global
                                  • Repetitions: 1
                                  • Index Language: German
                                      Entry CountNormal, TextAuto-Enter:
                                      • Allow editing
                                      Validation:
                                      • Only during data entry
                                      Storage:
                                      • Global
                                      • Repetitions: 1
                                      • Index Language: German
                                          EntryNormal, TextAuto-Enter:
                                          • Allow editing
                                          Validation:
                                          • Only during data entry
                                          Storage:
                                          • Repetitions: 1
                                          • Indexing: None
                                          • Automatically create indexes as needed
                                          • Index Language: German
                                              AttributeNormal, TextAuto-Enter:
                                              • Allow editing
                                              Validation:
                                              • Only during data entry
                                              Storage:
                                              • Repetitions: 1
                                              • Indexing: None
                                              • Automatically create indexes as needed
                                              • Index Language: German
                                                  ValuesNormal, TextAuto-Enter:
                                                  • Allow editing
                                                  Validation:
                                                  • Only during data entry
                                                  Storage:
                                                  • Repetitions: 1
                                                  • Indexing: None
                                                  • Automatically create indexes as needed
                                                  • Index Language: German

                                                      Layout Objects: LDAP Query

                                                      Regular Fields

                                                      Field Name: LDAP Query::Server
                                                      Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                      • Top: 6 pt
                                                      • Left: 132 pt
                                                      • Bottom: 20 pt
                                                      • Right: 385 pt
                                                      • Anchoring: Left, Top
                                                      Field Format:
                                                      • Edit Box
                                                      Field Behavior:
                                                      • Allow field to be entered: In Find mode, In Browse mode
                                                      • Touch keyboard type: System Default
                                                      • Go to next field using: Tab key
                                                      No

                                                      Field Name: LDAP Query::UserName
                                                      Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                      • Top: 24 pt
                                                      • Left: 132 pt
                                                      • Bottom: 38 pt
                                                      • Right: 385 pt
                                                      • Anchoring: Left, Top
                                                      Field Format:
                                                      • Edit Box
                                                      Field Behavior:
                                                      • Allow field to be entered: In Find mode, In Browse mode
                                                      • Touch keyboard type: System Default
                                                      • Go to next field using: Tab key
                                                      No

                                                      Field Name: LDAP Query::Password
                                                      Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                      • Top: 42 pt
                                                      • Left: 132 pt
                                                      • Bottom: 56 pt
                                                      • Right: 385 pt
                                                      • Anchoring: Left, Top
                                                      Field Format:
                                                      • Edit Box
                                                      Field Behavior:
                                                      • Allow field to be entered: In Find mode, In Browse mode
                                                      • Touch keyboard type: System Default
                                                      • Go to next field using: Tab key
                                                      No

                                                      Field Name: LDAP Query::SSL
                                                      Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                      • Top: 60 pt
                                                      • Left: 132 pt
                                                      • Bottom: 74 pt
                                                      • Right: 211 pt
                                                      • Anchoring: Left, Top
                                                      Field Format:
                                                      • Edit Box
                                                      Field Behavior:
                                                      • Allow field to be entered: In Find mode, In Browse mode
                                                      • Touch keyboard type: System Default
                                                      • Go to next field using: Tab key
                                                      No

                                                      Field Name: LDAP Query::AuthMethod
                                                      Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                      • Top: 78 pt
                                                      • Left: 132 pt
                                                      • Bottom: 92 pt
                                                      • Right: 385 pt
                                                      • Anchoring: Left, Top
                                                      Field Format:
                                                      • Edit Box
                                                      Field Behavior:
                                                      • Allow field to be entered: In Find mode, In Browse mode
                                                      • Touch keyboard type: System Default
                                                      • Go to next field using: Tab key
                                                      No

                                                      Field Name: LDAP Query::Base
                                                      Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                      • Top: 96 pt
                                                      • Left: 132 pt
                                                      • Bottom: 110 pt
                                                      • Right: 385 pt
                                                      • Anchoring: Left, Top
                                                      Field Format:
                                                      • Edit Box
                                                      Field Behavior:
                                                      • Allow field to be entered: In Find mode, In Browse mode
                                                      • Touch keyboard type: System Default
                                                      • Go to next field using: Tab key
                                                      No

                                                      Field Name: LDAP Query::Scope
                                                      Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                      • Top: 114 pt
                                                      • Left: 132 pt
                                                      • Bottom: 128 pt
                                                      • Right: 385 pt
                                                      • Anchoring: Left, Top
                                                      Field Format:
                                                      • Edit Box
                                                      Field Behavior:
                                                      • Allow field to be entered: In Find mode, In Browse mode
                                                      • Touch keyboard type: System Default
                                                      • Go to next field using: Tab key
                                                      No

                                                      Field Name: LDAP Query::Filter
                                                      Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                      • Top: 132 pt
                                                      • Left: 132 pt
                                                      • Bottom: 146 pt
                                                      • Right: 385 pt
                                                      • Anchoring: Left, Top
                                                      Field Format:
                                                      • Edit Box
                                                      Field Behavior:
                                                      • Allow field to be entered: In Find mode, In Browse mode
                                                      • Touch keyboard type: System Default
                                                      • Go to next field using: Tab key
                                                      No

                                                      Field Name: LDAP Query::Entry
                                                      Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                      • Top: 210 pt
                                                      • Left: 6 pt
                                                      • Bottom: 224 pt
                                                      • Right: 181 pt
                                                      • Anchoring: Left, Top
                                                      Field Format:
                                                      • Edit Box
                                                      Field Behavior:
                                                      • Allow field to be entered: In Find mode, In Browse mode
                                                      • Touch keyboard type: System Default
                                                      • Go to next field using: Tab key
                                                      Yes

                                                      Field Name: LDAP Query::Attribute
                                                      Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                      • Top: 210 pt
                                                      • Left: 186 pt
                                                      • Bottom: 224 pt
                                                      • Right: 325 pt
                                                      • Anchoring: Left, Top
                                                      Field Format:
                                                      • Edit Box
                                                      Field Behavior:
                                                      • Allow field to be entered: In Find mode, In Browse mode
                                                      • Touch keyboard type: System Default
                                                      • Go to next field using: Tab key
                                                      Yes

                                                      Field Name: LDAP Query::Values
                                                      Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                      • Top: 210 pt
                                                      • Left: 330 pt
                                                      • Bottom: 224 pt
                                                      • Right: 553 pt
                                                      • Anchoring: Left, Top
                                                      Field Format:
                                                      • Edit Box
                                                      Field Behavior:
                                                      • Allow field to be entered: In Find mode, In Browse mode
                                                      • Touch keyboard type: System Default
                                                      • Go to next field using: Tab key
                                                      Yes

                                                      Field Name: LDAP Query::Port
                                                      Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                      • Top: 60 pt
                                                      • Left: 306 pt
                                                      • Bottom: 74 pt
                                                      • Right: 385 pt
                                                      • Anchoring: Left, Top
                                                      Field Format:
                                                      • Edit Box
                                                      Field Behavior:
                                                      • Allow field to be entered: In Find mode, In Browse mode
                                                      • Touch keyboard type: System Default
                                                      • Go to next field using: Tab key
                                                      No

                                                      Field Name: LDAP Query::Entry Count
                                                      Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                      • Top: 150 pt
                                                      • Left: 132 pt
                                                      • Bottom: 164 pt
                                                      • Right: 385 pt
                                                      • Anchoring: Left, Top
                                                      Field Format:
                                                      • Edit Box
                                                      Field Behavior:
                                                      • Allow field to be entered: In Find mode, In Browse mode
                                                      • Touch keyboard type: System Default
                                                      • Go to next field using: Tab key
                                                      No

                                                      Script Hierarchy

                                                      LDAP Query

                                                      Script NameLDAP Query
                                                      Run script with full access privilegesOff
                                                      Include In MenuYes
                                                      Layouts that use this script
                                                        Scripts that use this script
                                                          Script Definition
                                                          Script Steps
                                                          • Delete All Records [ No dialog ]
                                                          • #Connect
                                                          • Set Variable [ $r; Value:MBS("LDAP.Connect"; LDAP Query::Server; LDAP Query::SSL; LDAP Query::Port) ]
                                                          • If [ MBS("IsError") ]
                                                          • Show Custom Dialog [ Title: "LDAP error"; Message: "Failed to connect." & ¶ & $r; Default Button: “OK”, Commit: “Yes”; Button 2: “Cancel”, Commit: “No” ]
                                                          • Exit Script [ ]
                                                          • Else
                                                          • Set Variable [ $ldap; Value:$r ]
                                                          • #Login
                                                          • Set Variable [ $r; Value:MBS("LDAP.Bind"; $ldap; LDAP Query::UserName; LDAP Query::Password; LDAP Query::AuthMethod) ]
                                                          • If [ MBS("IsError") ]
                                                          • Show Custom Dialog [ Title: "LDAP error"; Message: "Failed to authenticate." & ¶ & $r; Default Button: “OK”, Commit: “Yes”; Button 2: “Cancel”, Commit: “No” ]
                                                          • Else
                                                          • #Search
                                                          • Set Variable [ $r; Value:MBS("LDAP.Search"; $ldap; LDAP Query::Base; LDAP Query::Scope; LDAP Query::Filter; ""; 0; 20; 999) ]
                                                          • #Check results
                                                          • Set Variable [ $EntryCount; Value:MBS("LDAP.SearchResult.Count"; $ldap) ]
                                                          • #Walk over all entries
                                                          • Set Field [ LDAP Query::Entry Count; $EntryCount ]
                                                          • If [ $EntryCount > 0 ]
                                                          • Set Variable [ $EntryIndex; Value:0 ]
                                                          • Loop
                                                          • Set Variable [ $EntryName; Value:MBS("LDAP.SearchResult.DistinguishedName"; $ldap; $EntryIndex) ]
                                                          • #Walk over all attributes
                                                          • Set Variable [ $AttributeCount; Value:MBS("LDAP.SearchResult.AttributeCount"; $ldap; $EntryIndex) ]
                                                          • If [ $AttributeCount ]
                                                          • Set Variable [ $AttributeIndex; Value:0 ]
                                                          • Loop
                                                          • #Check attribute name and value:
                                                          • Set Variable [ $AttributeName; Value:MBS("LDAP.SearchResult.AttributeName"; $ldap; $EntryIndex; $AttributeIndex) ]
                                                          • Set Variable [ $AttributeValues; Value:MBS("LDAP.SearchResult.AttributeValues"; $ldap; $EntryIndex; $AttributeIndex; 1) ]
                                                          • #Store in a record:
                                                          • New Record/Request
                                                          • Set Field [ LDAP Query::Entry; $EntryName ]
                                                          • Set Field [ LDAP Query::Attribute; $AttributeName ]
                                                          • Set Field [ LDAP Query::Values; $AttributeValues ]
                                                          • Commit Records/Requests [ No dialog ]
                                                          • #next attribute
                                                          • Set Variable [ $AttributeIndex; Value:$AttributeIndex + 1 ]
                                                          • Exit Loop If [ $AttributeIndex = $AttributeCount ]
                                                          • End Loop
                                                          • End If
                                                          • #next entry
                                                          • Set Variable [ $EntryIndex; Value:$EntryIndex + 1 ]
                                                          • Exit Loop If [ $EntryIndex = $EntryCount ]
                                                          • End Loop
                                                          • End If
                                                          • End If
                                                          • #Cleanup
                                                          • Set Variable [ $r; Value:MBS("LDAP.Release"; $ldap) ]
                                                          • 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

                                                                  Download example: LDAP Query

                                                                  Used functions:




                                                                  Links
                                                                  MBS Xojo Chart Plugins