If I leave them blank I get an empty string inserted into my database (postgis) - I really want Nulls
Best Answer
Is it possible to use Null as the value/default value for a User Parameter?
+8- Contributor
Best answer by david_r
User parameters cannot be set to NULL, but you can use a ParameterFetcher and a NullAttributeMapper before the writer to transform empty strings to NULL before being written.
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
- Best Answer
User parameters cannot be set to NULL, but you can use a ParameterFetcher and a NullAttributeMapper before the writer to transform empty strings to NULL before being written.