Skip to Content

How to edit free hand Queries in SAC or BobJ Cloud

Dec 05, 2017 at 04:52 PM


avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Mate Kiss
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,

Show 2 Share
10 |10000 characters needed characters left characters exceeded

Excellent answer. Thanks this solves much of my problem.


I am glad to see, that it works.

Best Regards,