Skip to main content
Nintex Community Menu Bar
Solved

ListView (Version 4.7)

  • February 5, 2019
  • 3 replies
  • 1 view
  • Translate
A

I have been trying to create a list view which pulls in data from an additional smartobjects.

I have created a list view form the master activity list which includes a column for a supplier reference. I have a SmartObject which holds a lists of supplier and the contact names. When the list view initalizes I need it to pull in  the supplier contact name. Is this possible and if so how can it be accomplished. I also need to be able to export the list to Excel. Is there an easy way to do this

 

Thanks

 

Regrads

Andrew

Best answer by tbyrne777

Write a stored procedure that is basicall a select statement that returns exactly what you want to see in your list view. Then, register the database that contains this stored procedure as a Service Instance in either the K2 management site or SmartObject service tester. That Stored Procedure will then become available as somthing you can tie to a SmartObject method. That SmartObject method is what you will use to populate your list view.

View original
    Did this topic help you find an answer to your question?

    3 replies

    T
    Forum|alt.badge.img+13
    • tbyrne777
    • Scholar
    • 499 replies
    • February 5, 2019

    As to your first question, my recommendation would be to create an advanced smart object that includes the join to pull in the contact names by supplier Id. I'm not sure what your source is for this data, but one smart object can have multiple service object methods that you can join by Ids (kind of like SQL queries).

    Alternatively, a stored procedure that puts everything together for you would perform slightly better.

    Translate
    A
    • AndyR1
    • Author
    • 19 replies
    • February 6, 2019

    Many thanks,

     

    Would you have any advice on how to set up the stored procedure. As a relativley new user to K2 in need pointing the right direction sometimes.

     

    Regards

     

    Andrew 

    Translate
    T
    Forum|alt.badge.img+13
    • tbyrne777
    • Scholar
    • 499 replies
    • Answer
    • February 6, 2019

    Write a stored procedure that is basicall a select statement that returns exactly what you want to see in your list view. Then, register the database that contains this stored procedure as a Service Instance in either the K2 management site or SmartObject service tester. That Stored Procedure will then become available as somthing you can tie to a SmartObject method. That SmartObject method is what you will use to populate your list view.

    Translate
    adithepo
    1 person likes this
    • adithepo
      adithepo

    Reply


    Sidebar Buttons
    Nintex Community Home Contact Nintex Support Email Nintex Community Check Nintex Status
    Terms & ConditionsCookie Settings

    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