My nifty solution for generating loan forms in Specify7 has suddenly stopped working, because of a strange issue with an aggregator not doing its job. For my code to work, its crucial that loan agents are separated by a semicolon. However, I am not sure what happened, but all of a sudden the separator refuse to appear in my underlying query:
The semicolons defined as separators in the table aggregation within the DataObjFormatters app resource (which specifies the table formats and aggregations) are removed automatically in v7.9.6.2 due to a bug in whitespace stripping for that resource.
This issue only occurs when a user modifies a table format or aggregation; otherwise, it remains unchanged.
This issue will be fixed automatically for all users when updating to v7.10.2 later this spring, but for now you can run the following SQL statement to add the semicolon separators back if they are removed (after any edits to the table formats or aggregation in that discipline):
UPDATE spappresourcedata spard
SET spard.data = REPLACE(spard.data, 'separator=""', 'separator="; "')
WHERE spard.SpAppResourceID IN (
SELECT spar.SpAppResourceID
FROM spappresource spar
WHERE spar.Name = 'DataObjFormatters'
);
Thank you Grant! I incidentally checked our test installation of 7.10.2 and there it was working as usual. So the upgrade did break this momentarily, but I am glad we’re up and running again after that hotfix!
