geoserver 2.21.1, Postgresql

Hello,

Question: How can I add randomness to App Schema idExpression while joining 
support is active? (then random() is not supported)

Background:

 *   App Schema automatically encodes the ids based on <tablename>.<primarykey>.
 *   Ids have to be unique within the output document, else the document will 
not validate.

If a mapping file repeatedly chains the same feature and there the same content 
(same line in the table, same primary key), the generated id is the same. (For 
me this happens with a mapping file that chains responsible party 
(gmd:CI_ResponsibleParty) in several places. When the same party is responsible 
more than once, the generated ids are the same and thus, the output document 
does not validate).

As all data are the same in these multiple occurrences, the only solution I see 
is to add a random string/number. To concatenate random() in the idExpression 
is a solution in case joining support is deactivated. However, with activated 
joining support, it generates an error (only database functions are supported, 
as indicated in the documentation). But when I turn of joining support, JDBC 
multi values support seems to be deactivated as well. Thus, this is not a 
solution. Therefore, I need a solution for adding randomness while joining 
support is active.

Thanks in advance for any help on this topic,

Henning

The funny thing is that the same app schema mapping with random() and multiple 
values did work and produce valid output on a now decommissioned server. The 
geoserver version was in the range 2.14-2.16, and I can't recall whether 
joining support was active. Maybe it just was a coincidence, or something has 
changed in geoserver.








När du har kontakt med oss på Uppsala universitet med e-post så innebär det att 
vi behandlar dina personuppgifter. För att läsa mer om hur vi gör det kan du 
läsa här: http://www.uu.se/om-uu/dataskydd-personuppgifter/

E-mailing Uppsala University means that we will process your personal data. For 
more information on how this is performed, please read here: 
http://www.uu.se/en/about-uu/data-protection-policy
_______________________________________________
Geoserver-users mailing list

Please make sure you read the following two resources before posting to this 
list:
- Earning your support instead of buying it, but Ian Turton: 
http://www.ianturton.com/talks/foss4g.html#/
- The GeoServer user list posting guidelines: 
http://geoserver.org/comm/userlist-guidelines.html

If you want to request a feature or an improvement, also see this: 
https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer


Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

Reply via email to