[Logo] LDAPSoft LDAP And Active Directory Tools Community Forums
  [Search] Search   [Register] Register /  [Login] Login 
 
cannot build equivalent search using SQL?  XML
Forum Index » Report Bugs
Author Message
PaulG



Joined: 03/12/2008 19:51:42
Messages: 1
Offline

I am having trouble translating a working LDAP query into
something equivalent in the SQL editor. My reason for wanting
this is to get control over which attributes are displayed in the
search results.

my "normal" search uses this criteria:

Search Base: [ ou=People,o=my.com ]

Filter Preview: [ (&(JobFunctionCode=LRD)(buildingName=mycity*))

Running this search correctly returns a list of 40 -some odd matching entries


I cannot duplicate this query in SQL ... problem (I think) is in the syntax
for the "FROM" clause.

I've tried "FROM dc=my,dc=com" w/ no results.

What is the proper syntax to use to correctly specify the target of my FROM clause?

Thanks!
Paul

support



Joined: 27/06/2008 19:01:18
Messages: 123
Offline

Try the following Statement

SELECT FROM ou=People,o=my.com where buildingName like 'mycity%' and JobFunctionCode= 'LRD'
subtreescope

whenever there is wildcard character you have to use like.



 
Forum Index » Report Bugs
Go to:   
[Recent Topics] Recent Topics   [Hottest Topics] Hottest Topics   [Members]  Member Listing  
Powered by JForum 2.1.9 © JForum Team