Hi, How can I create a profile in the SQL for Confluence app that will connect to a SQL server host that has Force Encryption enabled? I'm using the values below, Profile name: Force Encrypt Data...
I am a have question about the datasource name secion of bobswift addon (SQL Query) there is a drop down appearing there under datasource name. do we need to confirgure this information in server(us...
Hello, We are trying to use the rowOrientation in order to display charts in a better way. However, we have noticed that a when using a Bob Swift's SQL Query macro that is pulling data from a l...
We've been using Bob Swift's "SQL for Confluence" add-on for a while. Until today, all of the data sources were SQL Server and it's worked fine, but now we have to query a PostgreSQL DB. ...
Hi, We use Bob Swift's Run extensively and we are trying to now implement the Cache plugin to reduce database load and db connection issues. I have tried embedding the sql-query macro inside the Ca...
Hi, I'd like to query a few employees based on certain criteria and display them on a confluence page. This works well in general with the SQL query macro, but the surrounding borders of the table d...
Looking at the documentation for Bob Swift's SQL for Confluence addon (https://bobswift.atlassian.net/wiki/display/SQL/Data+Source+Profiles), I don't see any examples for SQL Server. There are&...
This Confluence add-on provides many choices for styling the output when you choose "Show results in a table", but I'm really struggling with options for output NOT in a table. Nothing I've tri...
Hello everybody, I'm trying to invent a kind of "mini-CRM" in Confluence. I thought about our agents. They would like to have an overview of their customers, let's call it a "Customer Cockpit". ...
I am using the Bob Swift SQL and I want the user to have the option to be able to export the data from the table to a csv file. I have tried the CSV Table Export Macro add-on but I randomly get...
I'm using the SQL for Confluence add-on and I have the below data source in my server.xml file for accessing SQL data from that add-on. I'm running a server side trace on the MS SQL server and I...
I just installed the Bob Swift SQL plugin and am trying to display anything just to get familiar with the tool to evaluate if it meets our needs. I am accessing my moc mysql confluence database...
When defining a data-source profile for the just installed "SQL for Confluence" plugin, I'd like a short-cut to be able to refer to the Confluence's own database-connection. Ideally, I'd have shortcu...
Hi All We recently upgraded the confluence version to 5.4.4 and upgraded the SQL plugin but we are facing issues. Plese help me to configure the Configure SQL Plugin
sql-file macro is new in SQL plugin 6.0 (https://bobswift.atlassian.net/wiki/x/I4GAAg) and is said to "allow[s] accessing specifically authorized scripts stored on the Confluence server file system."...
I have SQL Plugin for Confluence and I use it to display information from the table from MSSQL server. I have limit option set to 300 in plugin configuration, but the table size encreases and now i...
Hi I'm using the latest stable version of Bob Swift's SQL Plugin (6.0.1) with Confluence version 5.1.4. I'd like to upgrade to Confluence 5.2.3 and although Bob's plugin states it's compatible I se...
Hi, first up I'll qualify my ignorance by saying that I'm not a developer but, hey, at least I'm trying! I've been tinkering with our newly acquired Run and SQL macros with the aim of achieving the...
For various reasons our databases (sqlserver) may be unavailable when the page is refreshed and the sql query is run. The SQL connection will throw an error showing the database is unavailable. Th...
Copied to clipboard