# getValueListDisplayValue problem

**URL:** <https://forum.servoy.com/t/getvaluelistdisplayvalue-problem/8087>\
**Category:** Classic Servoy\
**Created:** [September 1, 2007, 10:01pm UTC](https://forum.servoy.com/t/getvaluelistdisplayvalue-problem/8087 "2007-09-01T22:01:57Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Michael\_Mooney](https://avatars.discourse-cdn.com/v4/letter/m/45deac/32.png) [@Michael\_Mooney](https://forum.servoy.com/u/Michael_Mooney)\
**Post date:** [September 1, 2007, 10:01pm UTC](https://forum.servoy.com/t/getvaluelistdisplayvalue-problem/8087/1 "2007-09-01T22:01:57Z")

</div>

I am having problems with a call to getValueListDisplayValue. The code snippet below is problematic. An identical call to another valuelist works properly; the one below does not. The only difference between the 2 valuelists is that the one that works is linked directly to a table key while the one that does not work goes through a relation. sys\_subregion\_id is an integer as is the subregion data provider column. Returns null per debugger. I have confirmed that the inbound parameter (sys\_subregion\_id) is a known integer value in the target db.

```auto
if (application.getValueListDisplayValue('Subregion_id_from_globals', sys_subregion_id) == subregion)
{advice_str += 'Keyed subregion and current Subregion setting cross-check. \n'; sub_crosscheck = true;}
else
{advice_str += 'ERROR: Keyed subregion and current Subregion setting DO NOT cross-check. \n';}

```

Any known issues with this method? 3.5 final.

Thanks, Michael

---

<div class="post-metadata">

**Author:** ![Michael\_Mooney](https://avatars.discourse-cdn.com/v4/letter/m/45deac/32.png) [@Michael\_Mooney](https://forum.servoy.com/u/Michael_Mooney)\
**Post date:** [September 1, 2007, 10:31pm UTC](https://forum.servoy.com/t/getvaluelistdisplayvalue-problem/8087/2 "2007-09-01T22:31:55Z")

</div>

This is NOT a Servoy issue/bug … it is my bug. ![:roll:]( "Rolling Eyes")

I needed to use another relation as the one I had used was 1:n whereas the routine needed 1:1 for its cross-check. The function in question appropriately returned a null since it is expecting 1:1 for the real value that corresponds to the display value. If 1:n is in the relation for this function it has no other sensible option but to fail and return a null.

Thread left here just in case anyone else runs into this.

---

<div class="post-metadata">

**Author:** ![Karel\_Broer](https://avatars.discourse-cdn.com/v4/letter/k/bcef8e/32.png) [@Karel\_Broer](https://forum.servoy.com/u/Karel_Broer)\
**Post date:** [September 6, 2007, 8:46am UTC](https://forum.servoy.com/t/getvaluelistdisplayvalue-problem/8087/3 "2007-09-06T08:46:42Z")

</div>

application.getValueListDisplayValue allways returns null in

Servoy Developer  
Version 3.1.6-build 410  
Java version 1.5.0\_07-87 (Mac OS X)

Could this be fixed please?

---

<div class="post-metadata">

**Author:** ![ROCLASI](https://yyz2.discourse-cdn.com/flex010/user_avatar/forum.servoy.com/roclasi/32/4371_2.png) [@ROCLASI](https://forum.servoy.com/u/ROCLASI)\
**Post date:** [September 6, 2007, 9:03am UTC](https://forum.servoy.com/t/getvaluelistdisplayvalue-problem/8087/4 "2007-09-06T09:03:46Z")

</div>

Yep,

I’ve seen this too, same setup.

---

<div class="post-metadata">

**Author:** ![IT2Be](https://avatars.discourse-cdn.com/v4/letter/i/dc4da7/32.png) [@IT2Be](https://forum.servoy.com/u/IT2Be)\
**Post date:** [September 6, 2007, 9:12am UTC](https://forum.servoy.com/t/getvaluelistdisplayvalue-problem/8087/5 "2007-09-06T09:12:09Z")

</div>

> Could this be fixed please?

Now that Robert confirmed this, have you added it to the support system?