Hi All, I have been investigating the issue with Company menu where it lists down the partially results and then gives ARWARN66
The back end query which gets fired is SELECT DISTINCT TOP 302 T445.C1000000001, T445.C1000000070, T445.C1000000071 FROM T445 WHERE ((T445.C7 = 1) AND ((T445.C1000000006 LIKE N'%Operating Company%') OR (T445.C1000000006 LIKE N'%Customer%')) AND (T445.C1000000071 LIKE N'The%')) ORDER BY T445.C1000000001 ASC, T445.C1000000070 ASC, T445.C1000000071 ASC The point to be noted is TOP 302 in the query(i.e. it fetches the first 302 records and in total there are 470 qualifiable records with Company name starting with 'The%') I am interested in knowing what config/etc is making it fetching the first 302 records. The server is configured for unlimited entries on get list like shown below Max Entries Returned By GetList : 0 Server Table Field Chunk Size : 0 Also the user preference for me (an administrator) is like shown below Limit Number of Items Returned : No Any pointers to fix it. ITSM 9.0.01 201606230729 Windows Server 2012 R2 6.3 SQL -- SQL Server 2014 - 12.0.4100.1 (X64) Regards, Saurabh -- View this message in context: http://ars-action-request-system.1.n7.nabble.com/Partial-results-on-Company-Field-and-then-ARWARN-66-tp124673.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
