Loading...

Lookup Column Limit

Lookup Column Limit

Home Forums QuickApps Forum Lookup Column Limit

Tagged: 

Viewing 5 reply threads
  • Author
    Posts
    • #10638
      Gary Broad
      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
      Deepak Tyagi
      Moderator

      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 Broad
      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
      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 Broad
      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
      Rachit Vyas
      Participant

      It is scheduled to be released in Q3 most likely.

      Regards,

      Rachit

Viewing 5 reply threads

You must be logged in to reply to this topic.