Hi all,

I seem to keep struggling on these DAL queries when I make my own query
and entity in the DAL... I must not understand something...

What I want to achieve is for the workflow initiator to be able to
search for a group that is contained within the vault, these groups are
nested groups as they contain other groups as members...
This workflow will allow the initiator to manage these groups
(PositionTitleGroups) by adding or removing other groups
(PositionTitle).

Here is my current configuration with links to screenshots... NOTE: I
only want to search at the moment... I also want to return the CN of the
result...

NESTEDGROUP ENTITY:
'ImageShack® - Online Photo and Video Hosting'
(http://imageshack.us/photo/my-images...stedgroup.png/)


I THEN ADDED ATTRIBUTES TO THE ENTITY

'ImageShack® - Online Photo and Video Hosting'
(http://imageshack.us/photo/my-images...oupmember.png/)

'ImageShack® - Online Photo and Video Hosting'
(http://imageshack.us/photo/my-images...upmembers.png/)

'ImageShack® - Online Photo and Video Hosting'
(http://imageshack.us/photo/my-images...scription.png/)

'ImageShack® - Online Photo and Video Hosting'
(http://imageshack.us/photo/my-images...edgroupcn.png/)

'ImageShack® - Online Photo and Video Hosting'
(http://imageshack.us/photo/my-images...tedconfig.png/)

HERE IS THE QUERY:
'ImageShack® - Online Photo and Video Hosting'
(http://imageshack.us/photo/my-images/32/queryf.png/)

THIS IS THE CODE I AM USING (LOOK AT THE ONLOAD NOT THE DOQUERY EVENT
FOR NOW...):
'ImageShack® - Online Photo and Video Hosting'
(http://imageshack.us/photo/my-images/196/onload.png/)
The field groupName is a PickList with data type "string"

Now, when the form loads, the picklist remains empty...

When I increase the logging level of the UserApp I can see the query
being made, and the query is what I expected... i.e.
(&(objectClass=groupOfNames)(cn=*))

But nothing is returned...

I assume I have something configured incorrectly... I have flushed the
cache numerous times and with each DAL configuration change...


Code:
--------------------
2012-03-26 10:13:34,338 INFO [STDOUT] (http-0.0.0.0-8180-3) DEBUG [RBPM] [com.novell.srvprv.impl.vdata.model.VirtualDataAcce ss:getLdapAttributes] VDA.checking if object instance contains the requi
red objectClass per DAL definition: sys-provisioning-request
2012-03-26 10:13:34,338 INFO [STDOUT] (http-0.0.0.0-8180-3) 323980710 [http-0.0.0.0-8180-3] DEBUG com.novell.srvprv.impl.vdata.model.VirtualDataAcce ss - VDA.checking if object instance contains t
he required objectClass per DAL definition: sys-provisioning-request
2012-03-26 10:13:34,338 INFO [STDOUT] (http-0.0.0.0-8180-3) DEBUG [RBPM] [com.novell.srvprv.impl.vdata.model.VirtualDataAcce ss:getLdapAttributes] VDA.does contain required (search=true or auxillia
ry=false) objectClass:srvprvRequest
2012-03-26 10:13:34,338 INFO [STDOUT] (http-0.0.0.0-8180-3) 323980711 [http-0.0.0.0-8180-3] DEBUG com.novell.srvprv.impl.vdata.model.VirtualDataAcce ss - VDA.does contain required (search=true or
auxilliary=false) objectClass:srvprvRequest
2012-03-26 10:13:34,338 INFO [STDOUT] (http-0.0.0.0-8180-3) DEBUG [RBPM] [com.novell.srvprv.impl.vdata.model.VirtualDataAcce ss:getLdapAttributes] VDA.object instance is correct type
2012-03-26 10:13:34,339 INFO [STDOUT] (http-0.0.0.0-8180-3) 323980711 [http-0.0.0.0-8180-3] DEBUG com.novell.srvprv.impl.vdata.model.VirtualDataAcce ss - VDA.object instance is correct type
2012-03-26 10:13:34,339 INFO [STDOUT] (http-0.0.0.0-8180-3) DEBUG [RBPM] [com.novell.srvprv.impl.vdata.model.VirtualDataMode l:getEntityDefinition] VDM.getEntityDefinition(String, Locale):sys-provi
sioning-request
2012-03-26 10:13:34,339 INFO [STDOUT] (http-0.0.0.0-8180-3) 323980712 [http-0.0.0.0-8180-3] DEBUG com.novell.srvprv.impl.vdata.model.VirtualDataMode l - VDM.getEntityDefinition(String, Locale):sys
-provisioning-request
2012-03-26 10:13:34,683 INFO [STDOUT] (http-0.0.0.0-8180-3) DEBUG [RBPM] [com.novell.srvprv.impl.vdata.model.VirtualDataAcce ss:getEntityResultList] VDA.getEntityResultList
2012-03-26 10:13:34,683 INFO [STDOUT] (http-0.0.0.0-8180-3) 323981055 [http-0.0.0.0-8180-3] DEBUG com.novell.srvprv.impl.vdata.model.VirtualDataAcce ss - VDA.getEntityResultList
2012-03-26 10:13:34,683 INFO [STDOUT] (http-0.0.0.0-8180-3) DEBUG [RBPM] [com.novell.srvprv.impl.vdata.model.VirtualDataMode l:getEntityDefinition] VDM.getEntityDefinition(String, Locale):nestedGro
up
2012-03-26 10:13:34,683 INFO [STDOUT] (http-0.0.0.0-8180-3) 323981056 [http-0.0.0.0-8180-3] DEBUG com.novell.srvprv.impl.vdata.model.VirtualDataMode l - VDM.getEntityDefinition(String, Locale):nes
tedGroup
2012-03-26 10:13:34,684 INFO [STDOUT] (http-0.0.0.0-8180-3) DEBUG [RBPM] [com.novell.srvprv.impl.vdata.model.VirtualDataAcce ss:resolveLdapFilter] Dynamically query with paramter substition: (cn=*)
2012-03-26 10:13:34,684 INFO [STDOUT] (http-0.0.0.0-8180-3) 323981056 [http-0.0.0.0-8180-3] DEBUG com.novell.srvprv.impl.vdata.model.VirtualDataAcce ss - Dynamically query with paramter substition
: (cn=*)
2012-03-26 10:13:34,684 INFO [STDOUT] (http-0.0.0.0-8180-3) DEBUG [RBPM] [com.novell.srvprv.impl.vdata.model.VirtualDataAcce ss:buildEntityFilter] VDA.getEntityResultList query filter: (&(objectCla
ss=groupOfNames)(cn=*))
2012-03-26 10:13:34,684 INFO [STDOUT] (http-0.0.0.0-8180-3) 323981057 [http-0.0.0.0-8180-3] DEBUG com.novell.srvprv.impl.vdata.model.VirtualDataAcce ss - VDA.getEntityResultList query filter: (&(o
bjectClass=groupOfNames)(cn=*))
--------------------


--
ccikara
------------------------------------------------------------------------
ccikara's Profile: http://forums.novell.com/member.php?userid=86966
View this thread: http://forums.novell.com/showthread.php?t=453883