Forum Discussion

GrahamR99's avatar
GrahamR99
Resolver I
8 years ago

Filter based on Parmeter

Hello

I'm trying to do a basic query, using a Parmeter.

 

I have a Oracle query with results called Retail_Weeks.  I have a Parmeter called Retail_Week.

 

I want to have a new query with just data that matches the Parmeter Retail_Week.

 

I have this code, but it does not work;

let
    Source = (Retail_Weeks,[Query="Select * From Retail_Weeks where RW_WEEK_NUMBER = " & Retail_Week])
   
in
    Source

 

How do I change the code to make this work?

 

Regards

 

GrahamR99

Need Help

3 Replies

  • v-sihou-msft's avatar
    v-sihou-msft
    Microsoft Employee
    8 years ago

    GrahamR99

     

    You should concatenate the string within Query part. It will be like: 

     

     

    let
    Source = (Retail_Weeks,[Query="Select * From Retail_Weeks where RW_WEEK_NUMBER = ' "& Retail_Week&" ' " ])
   
in
    Source

    See my sample below:

     

     

     

     

     

    Regards,

    • GrahamR99's avatar
      GrahamR99
      Resolver I
      8 years ago

      Hi

      Thank you for the help, but the code you have given me does not work, it comes up with the error;

      Expression.SyntaxError: Token RightParen expected.

       

      I don't know what this means, can you help any futher please?

       

      Regards

       

      GrahamR99

    • GrahamR99's avatar
      GrahamR99
      Resolver I
      8 years ago

      Hello Simon Hou-MSFT

      Is there any more help you can give me please, I still struggling with this problem.

       

      Regards

       

      GrahamR99