AnsweredAssumed Answered

ValueListItems ( ) function acting strangely ...

Question asked by Mike_Mitchell Expert on Apr 15, 2015
Latest reply on Apr 15, 2015 by mtwalker

Okay, here's a puzzler. Identical databases on different servers (development and production). Here's the value list in development:

 

valListDev.png

 

ValueListItems reports like this:

 

valListItemDev.png

 

The value list in production looks like this:

 

valListProd.png

 

But the ValueListItems function?

 

valListItemProd.png

 

Blank. And it's reporting that way when called via script.

 

Double-checked all the indexing, and it's good. Even turned off the indexes between all the relationships and allowed it to rebuild; nothing. Identical data on both sides. (Of course, if the indexes were bad, the value lists themselves wouldn't be working.)

 

Any ideas what might be going on here?

Outcomes