Forum Discussion

GrahamR99's avatar
GrahamR99
Icon for Resolver I rankResolver 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 da...
Need Help
v-sihou-msft's avatar
v-sihou-msft
Icon for Microsoft Employee rankMicrosoft 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
    Icon for Resolver I rankResolver 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
    Icon for Resolver I rankResolver 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