Solved

Advanced SmartObject Right Join

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.

icon

Best answer by nequinox 13 November 2019, 15:02

Does anyone have any thoughts?

+9

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

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

Sign up