Skip to main content
Nintex Community Menu Bar

Composite Smart Object in k2 with non matching rows

  • March 15, 2018
  • 1 reply
  • 14 views

We need all the application names which are not registered for the particular Change Request. And we need to send email to respective application groups.

 

List A

CR No

App Name

CR1

APP1

CR1

APP2

CR1

APP3

 

List B

App Name

Email

APP1

Email1

APP2

Email2

APP3

Email3

APP4

Email4

APP5

Email5

 

OUTPUT: Non matching rows for the particular change request from both the list

 

App Name

EMAIL

APP4

Email4

APP5

Email5

 

 

 

Note: In SO association we have option to get ONLY matching data.

Note :we have access only to the K2 Designer, we dont have access to K2 Studio

1 reply

Forum|alt.badge.img+9
  • March 15, 2018

why not just create a sql view or a stored proc to do that and just create a smartobject out of it? that will also give you the flexibility to make changes to your conditions and still keep the same smartobject if needed.