Forum Discussion

SMid's avatar
SMid
Frequent Visitor
4 years ago
Solved

Native query greyed out

Hi all,   I am trying to fold my queries, but the View Native Query option is always greyed out, even at source. I am only connecting to SQL server, and not using the SQL statement box in the advan...
Need Help
  • BA_Pete's avatar
    BA_Pete
    4 years ago

    Hi SMid ,

     

    Silly question, but have you checked that your Navigation step has a Native Query?

    The source step will never have a Native Query as it doesn't form a complete SELECT statement, but you should have it from Navigation onwards.

     

    Pete

  • Fowmy's avatar
    Fowmy
    4 years ago

    SMid 

    If you check on the Source Step, it always shows greyed out but query folds, check on the 2ns step where you navigate to a table

     

BA_Pete's avatar
BA_Pete
Super User
4 years ago

Hi SMid ,

 

Silly question, but have you checked that your Navigation step has a Native Query?

The source step will never have a Native Query as it doesn't form a complete SELECT statement, but you should have it from Navigation onwards.

 

Pete