# Valuelist based on global relation empty w/o dataprovider

**URL:** <https://forum.servoy.com/t/valuelist-based-on-global-relation-empty-w-o-dataprovider/9661>\
**Category:** Classic Servoy\
**Created:** [October 1, 2008, 3:59pm UTC](https://forum.servoy.com/t/valuelist-based-on-global-relation-empty-w-o-dataprovider/9661 "2008-10-01T15:59:10Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![jbader](https://avatars.discourse-cdn.com/v4/letter/j/dfb087/32.png) [@jbader](https://forum.servoy.com/u/jbader)\
**Post date:** [October 1, 2008, 3:59pm UTC](https://forum.servoy.com/t/valuelist-based-on-global-relation-empty-w-o-dataprovider/9661/1 "2008-10-01T15:59:10Z")

</div>

Hello,

I have a valuelist that is based on a global relationship. The idea is that it returns a list of companies that belong to a certain group. The group id is stored in a global and is used on the left side of a relationship that looks at a group table. The valuelist then joins the group table to to a company table; returning only companies that belong to the specified group ID stored in the global. The valuelist works great when attached to a dataprovider, but when trying to retrieve the values from the valuelist programatically using application.getValueListItems(name) I always get an empty dataset?

Any suggestions?

---

<div class="post-metadata">

**Author:** ![Joas](https://yyz2.discourse-cdn.com/flex010/user_avatar/forum.servoy.com/joas/32/5095_2.png) [@Joas](https://forum.servoy.com/u/Joas)\
**Post date:** [October 2, 2008, 12:53pm UTC](https://forum.servoy.com/t/valuelist-based-on-global-relation-empty-w-o-dataprovider/9661/2 "2008-10-02T12:53:54Z")

</div>

I just tried this using 4.0.1, but the dataset I get returned from getValueListItems(name) is filled with the all the right values.

Can you reproduce the bug in a small solution? If so, then please create a case in the [Support System](http://crm.servoy.com/servoy-webclient/solutions/solution/servoy_support). If not, then it will probably help you in solving your own problem.
