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...
I've created this pivot table and it has the literal operation type for my link column. I'm wondering if I can shorten the names of these links so they save space and make it easier for the user to s...
I'm using the SQL macro the query through a set of data including defects for specific products. I'm creating graphs and charts using this data, and one thing I would like is for the user to be able ...
I'm using SQL Queries to sort a piece of data and I created a variable that gives a link to the specific item. Each value is therefore given a distinct link, but they are not clickable inside of the ...
Dear all, I try to pass a simple form (confiforms plugins) as result of SQL query (bob swift plugin) I copy paste the page code in a sql function, and call this function to a SQL macro. <ac:str...
An use case I need is to provide live pivot tables directly in Confluence based on TFS's reporting cube (analysis database/service). Does this add-on supports such use case?
I am using Swift Atlassian Add-ons - SQL. I have created data source profile like that : name : myds value : dbUrl=jdbc:postgresql://localhost:5432/NDAConfluence | dbUser=nda1 | dbPasswo...
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...
I have problem displaying a nice column header using the SQL plug-in. For example in the code block below, I want to show "Primary Owner" instead of D1.displayName, how can I do this? it seems this s...
Hi, If my instances of JIRA and Confluence are Server types but each run on a separate server, would it be possible to use SQL-Macro in Confluence to query data from JIRA DB which will be on another...
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...
Is it possible to use url query parameters in SQL query? For example, I'd like to pass an id to a page and execute the following sql. SELECT * FROM Projects WHERE id = '$id'
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'm trying to add a Cache connection to the SQL addon. I initally tried it on the config page in the administration but I kept getting errors. I decided to try the alternate method 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...
I have installed sql for confluence express and set up a datasource, but only confluence-administrators can see the datasource in the macro drop down. When I log in as a non-admin there aren't any se...
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...
Copied to clipboard
Online forums and learning are now in one easy-to-use experience.
By continuing, you accept the updated Community Terms of Use and acknowledge the Privacy Policy. Your public name, photo, and achievements may be publicly visible and available in search engines.