Skip to main content
Nintex Community Menu Bar

Creating a list view from two Smart object Tables

  • October 26, 2020
  • 3 replies
  • 210 views
  • Translate

Can any body help

I want to create a single list view from two smart object tables. The first table is a list of contracts the second table is a list of Contract owners and managers. The two lists are maintained by two different groups of people. Is there any way the when a contract list view is opened it can pull in to the list view the the current contract owners and managers.

 

Many thanks

 

Andy R  

  • October 26, 2020

Hi @AndyR1,

 

Each list view can only display data from its own smart object/ database. Unfortuanately list views cannot pull data from other tables. As an alternative, you can display listviews side by side via a Form (even below each other):

Simply drag and drop a list view onto a form and you will see panels of where you can drop them.

 Hope this helps :)

 

Kind Regards

Prineel

Translate

Forum|alt.badge.img+6
  • October 26, 2020

I think you can create advanced smartobject association (Master-Detail).  please check here 

https://help.k2.com/onlinehelp/k2five/userguide/5.3/default.htm#How-Tos/SmartObjectAssociations/SmartObjectAssociations.htm

 

or

For loading performance, you can create advanced smartobject list method (storedprocedure with join master detail table).  This approach table join is performed in Database level

 

 

 

Translate

Hi there @AndyR1 

 

Are you using a smartBox smartObject or is it an Advanced smartObject?

If you are using SQL as your database, I would suggest that you use a stored Procedure for this, then after create a smartObject and list view out of it.

 

Regards

HulisaniN

Translate

Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie Settings