Skip to Content

How to edit free hand Queries in SAC or BobJ Cloud

Hi, I'm using a SQL Connection in SAC and have created a Model with Free Hand Query. I'm still developing the model so need to make adjustments to the query but I don't see an option to do that. When I select the query edit button I'm only given an option to view the query but not edit it.

Any suggestions or alternatives?

Thanks, Todd

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Dec 07, 2017 at 03:43 PM

    Hello Todd,

    As it is described on the updating and scheduling models help page, it is not possible to edit the freehand SQL used for model creation: "Query filters can be modified, but columns cannot be added, removed, or changed. In the case of SQL databases, freehand SQL queries can't be edited."
    What you can do is importing a new SQL query to the existing model.

    Best Regards,
    Mate

    Add comment
    10|10000 characters needed characters exceeded