Composite Smart Object in k2 with non matching rows

  • 15 March 2018
  • 1 reply
  • 2 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

 

OUTPUTNon 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

Badge +9

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.

Reply