nequinox
Novice

Advanced SmartObject Right Join

Jump to solution

When i do a right join on a smartobject i cannot find only the rightjoin items. there is no way to filter where Left.ID=NULL

 

i have 2 smartobjects linked

Employee

-ID (input)

-Name(input, Bound)

-EmailFlag (input)

 

ADUser:GetUsersByPath

-LDAP(Input)

-Name(bound)

-email

 

firstly when i do a right lookup the ADUser Get Users By Path ignores my LDAP input.

LDAP:\OU=Users,OU=location,OU=Sites,DC=regional,DC=corporate,DC=com

 

I need all items from ADUser by that specific path that do not atch in my employee smartobject.

0 Kudos
Reply
3 Replies
nequinox
Novice

Re: Advanced SmartObject Right Join

Jump to solution
Does anyone have any thoughts?
0 Kudos
Reply
JeanSmit1
Apprentice

Re: Advanced SmartObject Right Join

Jump to solution

Hi,


 


Let me know if you have opened a K2 Support ticket, but i would like to find out how you have made these 2 SmartObjects and linked them?


 


The Employee SmartObject is (from what i can see) a SmartBox one?


And the other SmartObject is from the ActiveDirectory2 SmartObject?


 


How are these 2 linked? Are they associated? Did you create one composite SMO?


Can you share some screenshots?


 


-Jean

0 Kudos
Reply
nequinox
Novice

Re: Advanced SmartObject Right Join

Jump to solution

The solution was the LDAP path i was using needed to be in a different format.

 

correct path should be where XXXX are the same thing and YYYY are the same thing if you have a forest domain

 

LDAP://XXXX.YYYY.com/OU=Users,OU=Location,OU=Sites,DC=XXXX,DC=YYYY,DC=com

0 Kudos
Reply