[Gary]

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

[Deepak Tyagi]

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

[Gary]

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

[Rachit Vyas]

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

[Gary]

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

[Rachit Vyas]

It is scheduled to be released in Q3 most likely.

Regards,

Rachit

[Author]

Posts