Forum Discussion

richard_wylde's avatar
richard_wylde
Helper IV
5 years ago

M Query filter

Hello, I am using the following  document to create an M Query Parameter but can't get it to work.  In Query Editor, the source query (direct query, not import) runs fine with the custom sql using t...
Need Help
richard_wylde's avatar
richard_wylde
Helper IV
5 years ago

Thanks v-janeyg-msft  - no luck unfortunately, I changed it to :-

where b.status =Text.Insert( """&P_STATUS&""",1,b.status)

but it says the default value of the parameter does not exist :-

DataSource.Error: PostgreSQL: 42703: column "JASON1" does not exist

v-janeyg-msft's avatar
v-janeyg-msft
Community Support
5 years ago

Hi, richard_wylde 

 

I’m not sure what the custom sql you want is, but according to the error message, it should be a parameter problem, causing the database to find the corresponding column.