It seems that id
is a reserved keyword for Module Inputs.
If you try and use id.value in a SQL query with you module, you get this error:
Conversion failed when converting the nvarchar value 'filesModule1' to data type int.
It seems like id.value is actually the id of the module within your app. I am doing where file_job.job_id={{id.value}}
in my query. Since job_id
is expecting int and "filesModule" is a string, well you get this error. If job_id were a string, this might not return an error, just very confusing results!
I change my Input to idNum
and all is well in the world once again. Just thought this should be documented somewhere.