BUG Retool is mutating sql input which is not wanted

💬 App Building
1

I have a form text input: field_form_legacyDataType
with string value ‘nvarchar(10)‘ (this is the string not the datatype of the string)

And following MS SQL procedure:
EXECUTE myschemaname.myprocedurename
{{field_form_legacyDataType.value}}, --legacyDataType

I can execute the procedure after which my application will display the result again.

Issue: my string changed from ‘nvarchar(10)‘ to ‘nvarchar 10‘

Desired: How to tell retool to stop mutating my string?

3

Update: I found out what the issue is, source value is data from table component, retool decided there to interprit the value without concent. To top it off, it will forcefully format it as a tag, I can’t change it to string.

This inspector will just not accept any change if it is in a module:

image
image298×843 30.1 KB

4

The real issue is with the Mapped value, it seems. The {{ _.startCase(item) }} is what is performing the mutation of your string value. Can someone with module access edit this field to remove the mapped value override?

1 Like
5

Hi @Michel_Mirchandani1,

I believe @pyrrho is correct, were you able to have someone with module access edit the field?

Have you tried the same logic outside of a module?