LDAPSoft LDAP And Active Directory Tools Community Forums
Search
Register
/
Login
cannot build equivalent search using SQL?
Forum Index
»
Report Bugs
Author
Message
03/12/2008 19:58:46
Subject:
cannot build equivalent search using SQL?
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
04/12/2008 17:25:40
Subject:
Re:cannot build equivalent search using SQL?
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:
Select a forum
General Discussion
Feature Requests
Report Bugs
Official Bug List [read only]
Recent Topics
Hottest Topics
Member Listing
Powered by
JForum 2.1.9
©
JForum Team