jkipling

FileMaker Server 14 php api static value list bug

Discussion created by jkipling on Oct 18, 2016
Latest reply on May 9, 2017 by TSGal

Product and version: FileMaker Server 14

OS and version: Ubuntu 14.04.5

Hardware

Description :
When using the FileMaker Server php api function getValueList, if the Value list is a Custom value list containing an ampersand "&" what is returned by the function in the Array is not the correct value.  The ampersand causes the value to be parsed out differently.

How to replicate:

Create a value list "valueList" that contains the following value:

"some text & some other text"

Add that to an object on a  layout accessed by a php custom web publishing page, "layout".

Within the php page that is connected to layout call the following:

$layout->getValueList("valueList").

 

When traversing the result note that the corresponding value with the ampersand comes out as:

"some text some text & some text & some other text"

Workaround:

Create an unstored calculation that is equal too:

ValueListItems(Get(filename); "valueList")

 

and have the php page access that field instead of the value list.  Not ideal because it does not return an Array and it requires a query to a table.

Outcomes