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
v-janeyg-msft's avatar
v-janeyg-msft
Community Support
5 years ago

Hi, richard_wylde 

 

I'm sorry that I can't open your file and can't see any data because you use DQ, so I can't visually see the problem.

You can try to modify your formula:

 

where status =Text.Insert( """&&""",2,status)

 

Best Regards

Janey Guo

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • 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.