Skip to main content
Nintex Community Menu Bar
Solved

List View column restriction

  • July 23, 2019
  • 4 replies
  • 28 views
  • Translate
A
Forum|alt.badge.img+10

Are there limits or restrictions on how many columns a list view can have? 
Running into some behavior on a list view populating from a Stored Procedure (35 columns) that the list will take forever to load and open up.  Sometimes the view will open and sometimes the view will error out and not load at all. 

If the stored procedure / smartobject is updated with new column - the view seems to error out and then I'm forced to create a new view / expressions / functionality and add it to the form again.

 

This does not seem pratical.  

Basic function I need this for is because I need to export the data into an excel file.

Anybody else having this behavior or suggestions.


15590i9BE0002543D45844.png
12249i4B7BDEFE6F8E93D2.png
14822i7B3A0BA809275B7A.png
12858i15AB5FC12C1AD256.png

Best answer by AAschenbrener

I ended up using the oDATA API after finding some instructions on that K2 piece. Seems to provide what I need for the time being. Thank you!
View original
    Did this topic help you find an answer to your question?

    K
    Forum|alt.badge.img+16
    • khanh1
    • July 23, 2019

    Hi AAschenbrener,


     


    The last time I check, there is a limit of 30 columns when you generate views from a SmartObject. Let me know if this helps with your inquiry.


     


     

    Translate
    A
    Forum|alt.badge.img+10

    I have a support ticket into K2 for this issue and the agent assigned did not know of any limitation. If 30 is the limit for views, that will cause some complications for my project. 

    Any suggestions on how to provide the solution the customer is requesting?

    Translate
    Albarghouthy
    Forum|alt.badge.img+16

    Hi  @AAschenbrener,


     


    The other option is to use the following broker 


    https://community.k2.com/t5/K2-blackpearl/ADO-query-to-Excel/ba-p/1115


     


    This will allow you to export excel using ADO query, let me know if this helps or if you need further information


     


    I have tested this broker in K2 Five, it works as expected


     


     

    Translate
    A
    Forum|alt.badge.img+10
    I ended up using the oDATA API after finding some instructions on that K2 piece. Seems to provide what I need for the time being. Thank you!
    Translate

    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