AnsweredAssumed Answered

SERIOUS bug: FileMaker Server 12 Web Publishing Engine omitting portal data from RESULT

Question asked by tcmeyers on May 8, 2012
Latest reply on Jul 18, 2012 by tcmeyers

Summary

SERIOUS bug: FileMaker Server 12 Web Publishing Engine omitting portal data from RESULT

Product

FileMaker Server

Version

Server 12.0.1.178

Operating system version

Lion Server 10.7.3

Description of the issue

The XML results of a query to the WPE completely (and erroneously) omit column data for portals that have no related records; the field name elements for these in the XML are (correctly) not omitted. Thus, the results have more elements than elements, so data ends up being attributed to incorrect fields.

Steps to reproduce the problem

Include a portal on a layout to be used with the WPE. Add the portal and its fields, then afterwards add some more fields or portals, so that the result can be expected to have non-portal data presented AFTER the test portal as well.

Make sure the test portal's relationship does not have any related records for the test record.

Request the XML using the FMPXMLRESULT.xml?-db= etc. method.

Observe that the data elements in the do not align with the field names in the section.

Expected result

There should be exactly as many elements as elements.

Actual result

For portals that have no related records, the elements are totally OMITTED, rather than being supplied as for each field in the portal, as they should be.

Exact text of any error message(s) that appear

None, other than lots of "Undefined index" errors and data appearing in wrong places, further downstream in the PHP output.

Workaround

None.

Outcomes