7 Replies Latest reply on Aug 9, 2017 7:32 AM by TSGal

    PHP API - getValueListTwoFields - empty Array with related values


      I'm using FileMaker Server 16.0.2 and the PHP API/Custom Web Publishing.


      I've setup a value list in the database that uses the "values from field" option and references an ID field as well as a name field but with the "show values only from second field" selected. It also has the "included only related values starting from" selected - see screenshot.


      When I use the getValueListTwoFields method to retrieve this valuelist I get an empty array.


      If I change the value list from the "included only related values starting from"  to the "include all values" option it starts working immediately, but this is not the value list I can use as I need to use the "included only related values starting from" to return specific records. I can't see anything in the CWP v16 guide that mentions any limitations or incompatibility with the "included only related values starting from" setting in the value list.


      This discussion:


      getValueListTwoFields for related values only


      is also about this same issue, but there was no resolution so far.