02-11-2019 02:56 AM
I did a workflow with a list-element and I wanted to show the id-field in the Desktop-App with HIDDEN unchecked, but the id-field is still hidden. How can I show the id-field?
02-19-2019 08:58 AM
you are right, sorry. This is a bit of a workaround but it works:
the idea is to put an additional field and using the sqlselect providing the values. SqlSelect property must be put in the following way (it is intended to show values from an external relation):
Select DisplayValue From ForeignTable where ForeignTable.KeyField = CurrentTable.Field
So in your case you will have ForeignTable and CurrentTable being the same.
02-19-2019 11:24 AM
thank you for your answer!
I tried it, but unfortunately I failed.
I could save the workflow with the second id-field with the sql-command.
But now there a two errors in studio:
Npgsql.PostgresException: 21000: als Ausdruck verwendete Unteranfrage ergab mehr als eine Zeile (= the result of the request is more than one row)
[Details] Severity: FEHLER SqlState: 21000 Code: 21000 MessageText: als Ausdruck verwendete Unteranfrage ergab mehr als eine Zeile File: nodeSubplan.c Line: 1039 Routine: ExecSetParamPlan Href: https://dev.mappenterprise.de:443/Workflows/List/Index?nodeid=GruenflaechenListe&workflow=Eigenschaf... bei Npgsql.NpgsqlConnector.<>c__DisplayClass161_0.<<ReadMessage>g__ReadMessageLong|0>d.MoveNext()
log2: XX000: Relate Operation called with a LWGEOMCOLLECTION type. This is unsupported.
06-18-2019 02:41 PM - edited 06-18-2019 09:15 PM
I tried to show the id using
select id from locations where locations.id=locations.id
but i got the following error
Npgsql.PostgresException: 21000: more than one row returned by a subquery used as an expression
Do you have any suggestion?
Thanks for advance.
06-19-2019 01:03 PM
hi @esalgadoe , you are right, that works only when there is a 1 to 1 relationship between the 2 tables. In this case the query generates multiple rows because the table refers to itself.
Please log a support ticket, the system should honor the visibility property.