Lookup Column Limit – QuickApps
Loading...

Lookup Column Limit

Home Forums QuickApps Forum Lookup Column Limit

Tagged: 

This topic contains 5 replies, has 3 voices, and was last updated by  Rachit Vyas 7 months, 2 weeks ago.

  • Author
    Posts
  • #10638

    Gary
    Participant

    Hi,

    When using a Lookup Field in a qListForm it will only display 2000 entries from the list…can this be increased?  If I use a Cross-Site Lookup field it uses a configurable setting…does the same exist for a Lookup Field?

    Regards

    Gary

  • #10640

    Deepak Tyagi
    Participant

    Hi Gary,

    Yes, we can increase the lookup field item limit from QuickApps for SharePoint Configuration Editor, by default it is 2000.

    Please follow the following steps:-

    1)            Open QuickApps for SharePoint Configuration Editor.

    2)            Select your Web Application.

    3)            Click on Edit Custom Setting button.

    4)            Click on Rollup and Query tab.

    5)            Edit Max Query Row Count.

    Thanks

    Deepak Tyagi

  • #10641

    Gary
    Participant

    Hi Deepak,

    Thank you for your update…

    I have changed this value to 8000 but I am still only seeing 2000 in the dropdown…this seems to change to Cross-Site Lookup only…but not the Lookup Field…

    <QuestSoftware>

    <RollupSettings MaxRollupDepth=”8000″ MaxRollupListCount=”8000″ MaxQueryRowCount=”8000″ />

    </QuestSoftware>

    I am using Version <span id=”lblVersion” class=”qui-application-version”>6.7 (Build 2016.07.15)</span> with SharePoint 2010 if that helps…

    Regards

    Gary

  • #10642

    Rachit Vyas
    Participant

    Hi Gary,

    This is a bug with SP 2010 version of QASP. And it will be resolved in next QASP version(v6.8), MaxQueryRowCount is working perfectly with lookup field in SP 2013.

    Workaround:

    You can use “Cross-Site Lookup field” using QASP instead of lookup field.

    Have a good day!

    Thanks,

    Rachit

  • #10643

    Gary
    Participant

    Thanks Rachit,

    I should probably look at upgrading to SP2013 or SP2016 sometime…

    Do you have any idea of when v6.8 is likely to be released…such as Q2 or Q3?

    Regards

    Gary

  • #10644

    Rachit Vyas
    Participant

    It is scheduled to be released in Q3 most likely.

    Regards,

    Rachit

You must be logged in to reply to this topic.