http://www.ldapsoft.com/forum/posts/list/7.page JForum - http://www.jforum.net 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

]]> http://www.ldapsoft.com/forum/posts/preList/21/100.page http://www.ldapsoft.com/forum/posts/preList/21/100.page GMT
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.



]]> http://www.ldapsoft.com/forum/posts/preList/21/101.page http://www.ldapsoft.com/forum/posts/preList/21/101.page GMT