Search Using SQL

 

LDAP Admin & Reporting Tool provides tools for working with LDAP-SQL queries: SQL Editor for editing the query text directly and drag and drop visual query builder for building queries visually.

To create a new query in LDAP - SQL Editor:

Select the SQL | SQL main menu item or select the SQL from the toolbar

Build the sql by dragging and dropping the keywords, operators and the query parameters from the bottom pane

This how the sql editor looks like when you first open it.

 

 

 

Opening Queries

 

Queries can be opened either in SQL Editor or from the tool bar

To open a query in SQL Editor

or

 

 

Executing Queries

To execute a query:

Highlight the query to run or it will try to run whatever you typed in the editor

Then

or

or

 

View and edit the returned data in the SQL Results tab

 

Saving Queries

       

To save a query:

or

or 

 

 

 

Related links 

Complex Search 

Quick Search 

 


Ldapsoft Home page LDAP Admin & Reporting Tool Home Page