Hello everybody...
I've my own objectClass called 'Agency'. It has fields called 'radius' and 'agencyName'. I want to find out all 'agencyNames' such that 'radius' is less than 400. How can I achieve this?
Regards Ashish
Unlimited freedom, unlimited storage. Get it now, on http://help.yahoo.com/l/in/yahoo/mail/yahoomail/tools/tools-08.html/
On Fri, 8 Aug 2008, ashish mahamuni wrote:
I've my own objectClass called 'Agency'. It has fields called 'radius' and 'agencyName'. I want to find out all 'agencyNames' such that 'radius' is less than 400. How can I achieve this?
You need to ensure that "radius" can compare appropriately, and you look for instances of "agencyName" where the comparison matches.
I won't say more than that because:
1) It's a fundamental question hardly worthy of -technical, and
2) It sounds like a homework question.
In short, it's covered in the Admin Guide.
PS: They're not called "fields".
Dave Horsfall wrote:
On Fri, 8 Aug 2008, ashish mahamuni wrote:
I've my own objectClass called 'Agency'. It has fields called 'radius' and 'agencyName'. I want to find out all 'agencyNames' such that 'radius' is less than 400. How can I achieve this?
You need to ensure that "radius" can compare appropriately,
Dave, it's worth to mention what "compare appropriately" really means. IMHO the original poster is looking for using a filter like (radius<=400).
For this to work attribute type 'radius' has to be of syntax Integer (LDAP syntax with OID 1.3.6.1.4.1.1466.115.121.1.27) and defined with ORDERING matching rule integerOrderingMatch (OID 2.5.13.15).
Then one could query with
ldapsearch [..command-line options with host, base-DN, scope etc..] (radius<=400) agencyName
Ciao, Michael.
Thanks for reply...
I'm novice with LDAP..so please be with me.. The question was really stupid any way... But next problem is really discouraging.. Within last hour schema has been changed... I've been given Latitude(p) and Longitude(q) as attributes of a objectClass(radius is removed). Lets say my current LAT and LOG are x and y. I'll get the radius as a user input.. I want to find out all agencies(agencyNames precisely) that comes under given radius.. equation becomes something like this..
radius < squareroot((q-y)2 + (p-x)2)
I can do this by retrieving all agencies and applying formula on p and q attributes...(call this as post processing). But my client believes that..we don't need any post processing..LDAP can do this for us...
is it true? Can we do this in query or something else ?
--- On Fri, 8/8/08, Dave Horsfall daveh@coreng.com.au wrote:
From: Dave Horsfall daveh@coreng.com.au Subject: Re: Using logical operators in LDAP queries..... To: "OpenLDAP Technical List" openldap-technical@openldap.org Date: Friday, 8 August, 2008, 3:48 PM On Fri, 8 Aug 2008, ashish mahamuni wrote:
I've my own objectClass called 'Agency'. It has fields called 'radius' and
'agencyName'.
I want to find out all 'agencyNames' such that
'radius' is less than 400.
How can I achieve this?
You need to ensure that "radius" can compare appropriately, and you look for instances of "agencyName" where the comparison matches.
I won't say more than that because:
- It's a fundamental question hardly worthy of
-technical, and
- It sounds like a homework question.
In short, it's covered in the Admin Guide.
PS: They're not called "fields".
-- Dave Horsfall DTM VK2KFU Ph: +61 2 9552-5509 (direct) +61 2 9552-5500 (switch) Corinthian Eng'ng P/L, Ste 54 Jones Bay Whf, 26-32 Pirrama Rd, Pyrmont 2009, AU
Unlimited freedom, unlimited storage. Get it now, on http://help.yahoo.com/l/in/yahoo/mail/yahoomail/tools/tools-08.html/
ashish mahamuni wrote:
radius < squareroot((q-y)2 + (p-x)2)
I can do this by retrieving all agencies and applying formula on p and q attributes...(call this as post processing). But my client believes that..we don't need any post processing..LDAP can do this for us...
You can query with filter (attributeType<=attributeValue) given that LDAP syntax and matching rules declared for the attribute type support this (see my other reply).
You cannot let the LDAP server process something like the formula above.
Ciao, Michael.
openldap-technical@openldap.org
-
ashish mahamuni -
Dave Horsfall -
Michael Ströder