francis

The pivot gadget has been developed to support our Table Grid Editor customers who are looking for an easy way to report on the values stored in the tables. Given that the table grid editor is only server side, we focused on that environment first. Porting the gadget to the cloud is certainly on our roadmap, but the…

in Will the pivot gadget be available for JIRA Cloud Comment by francis February 2015

Hi, Someone pointed me to this question (we are developping the table grid editor) Service desk is currently not supporting complex custom fields like the table grid editor. We asked for suggestions to integrate it on SD through the JSD JIRA and also by talking to the SD developers during Summit. I guess it is in the…

in Table Grid in Customer interface for Jira Service Desk Comment by francis October 2014

Well, that's now the case. Still they can access the rapid board which is obviously completely empty. I'm wondering if that access can be hidden.

in rapid board is accessible anonymously when project allows anonymous access Comment by francis January 2015

Hello Mike, There are different solutions on the marketplace - check following query https://marketplace.atlassian.com/search?query=issue%20sync We are the team behind Exalate (which is one of these solutions) https://marketplace.atlassian.com/plugins/com.exalate.jiranode/server/overview It fully covers your use case, and…

in how to clone an issue to another jira instance? Comment by francis March 2017

(sorry that I didn't followup earlier - JIRA is much easier to track issues than answers) Can you check following stackoverflow document http://stackoverflow.com/questions/12155648/how-to-fetch-text-column-value-from-postgresql Locate the last answer ... select convert_from(loread(lo_open(comments2::int, x'40000'::int),…

in Question about Idalko Table Grid Edtior Comment by francis July 2016

Textarea columns are clobs allowing to store huge comments. This clobs are implemented differently depending on the database system. What database are you using ?

in Question about Idalko Table Grid Edtior Comment by francis June 2016

Hi Guilherme, Have a look at this faq https://wiki.idalko.com/display/TGPD/How+is+the+grid+table+identifier+calculated All tge based data is stored in a table which is managed by the add-on. The number in the CF is the number of rows in the grid for that particular issue. Let me know if this helps, Francis

in Question about Idalko Table Grid Edtior Comment by francis June 2016

Hi Kate, We are planning to upgrade, and we are extensively using script runner, so your post is really interesting. What is debug logging on com onresolve spitting out ? (Admin -> Logging & Profiling -> add class ...) Francis

in scriptrunner post function conditions not working in jira 7.1.9 Comment by francis September 2016

Consider using a scripted field where the logic collects all the custom field data and formats the view as a table. It might be straightforward, but you'll have to tweak a bit as I'm not sure what renderer is being used to show the content of the scripted field

in can we create a table for custom fields? Comment by francis September 2016

Thanks Paulo, that's a workaround, but not really acceptable for the users. I followed your suggestion and created a story request https://jira.atlassian.com/browse/GHS-6569 .

in How to assign an issue to a greenhopper sprint Comment by francis November 2012

(thanks Nic) Hi Bonita, I'm from Exalate - we organise a small workshop to get your synchronisation in place. Feel free to book a meeting at https://exalate-demo.youcanbook.me at your convenience. Francis

in Can I link two on premise instances of JIRA? Comment by francis December 2016

Cool - thanks for the nice words. A review on the marketplace is always welcome https://marketplace.atlassian.com/plugins/com.idalko.jira.plugins.igrid/server/reviews F.

in Table Grid Editor - Can you hide a column if no values are entered? Comment by francis October 2016

OK - it is a good idea. We do have col.xyz.hidemode which specifies when the column should be showed. We can add the 'empty' option. Also - if you have screen estate issues - check the gd.fitcolumns property which might be a help.

in Table Grid Editor - Can you hide a column if no values are entered? Comment by francis October 2016

Hello Peter, You can hide columns, but not dynamically. It is either visible or hidden. Can you elaborate on the use case ? Francis

in Table Grid Editor - Can you hide a column if no values are entered? Comment by francis October 2016

Euroxid, I'm bumping also into this one yesterday. I installed JIRA service desk, and since then no joy anymore. Removing caches, indexes, bundled_plugins, osgi_plugins and so on didn't help. So I cleared the database, brought up JIRA, imported an xml backup from the day before yesterday, and JIRA is humming happy again.…

in Jira redirecting to http://jiralockederror/ Comment by francis November 2013

That's a cool approach, not requiring to access JIRA 'behind the scenes' Certainly a candidate for a build-in script (IMO)

in How to find all workflows which are using postfunctions of a plugin Comment by francis August 2013

We are currently using a query on the database, but I'm wondering if there is another approach. The query is something like select workflownamefrom jira.jiraworkflowswhere descriptor like '%iamhuy%'

in How to find all workflows which are using postfunctions of a plugin Comment by francis August 2013

FYI col.xyz.formatNumber has been released in 1.13

in Field currency or format for number-field Comment by francis April 2014

Hi Stephan, We are currently working on the calculated column feature. You will be able to add a formula to each column of type string, integer or number. For example: col.linetotal.type=number col.linetotal.formula = {quantity} * {price} * {discount} The obvious next step is of course a number formatting capability…

in Field currency or format for number-field Comment by francis June 2013

There is a workaround which requires some additional configuration, but which might be usefull going forward. The table grid editor supports to load data using a dyamic query https://wiki.idalko.com/display/TGPD/gd.query This query can retrieve its data from a driving table…

in Table Grid Editor - how to add comma under default value using gd.query.rowX Comment by francis March 2015

The script calls an utility function - returning a list of issues. (Not sure what the new answers will do with the next piece of code)When we run another query like 'project = MRM and resolution is empty', the query runs fine.{code}class SearchUtil { private static Logger log = Logger.getLogger(SearchUtil.class); private…

in When running a search inside a script runner script, no results are returned when an issuefunction in .... is used Comment by francis September 2014

Scott, sorry to say but my earlier proposed workaround is not an option as all internal comments are visible to customers when they get access to the JIRA view of the issue. The only workaround would be to track these public issues in another - non service desk related - project.

in How do we allow Service Desk customers to view all open tickets in our JIRA project? Comment by francis November 2014

When you allow customers access to JIRA issues (by including them in the jira-users group), they will be able to see both internal as external comments ...

in How do we allow Service Desk customers to view all open tickets in our JIRA project? Comment by francis November 2014

Oops - glad that it helped and kudos to Andrey.

in Why does a select string list type in a Driving table include a blank and null option? Comment by francis April 2016

Hi Jon, I'm not sure if you want to continue the discussion here or on our support site, but in any case - could you share your grid configuration ? Thanks, Francis

in Why does a select string list type in a Driving table include a blank and null option? Comment by francis April 2016

Good idea - we will give it a try - thanks

in Javascript updates are ignored in "Create Issue" popup window. Comment by francis January 2013

I was not trying to put it in an URL, but in a comment about what the target domain name should look like. Thanks - both answers look equally good.

in jira is JIRA in confluence Comment by francis September 2012

Did you try jdigest ? https://plugins.atlassian.com/plugin/details/19656 It's a commercial plugin but it allows to summarize notifications.

in Is there a way to send a single summary e-mail after a group of actions has been completed in JIRA? Comment by francis June 2011

This is a production system - so I can't experiment. I removed the commentvalidator from the workflow, which obviously resolved the symptom.Will try to reproduce on test system.

in ScriptRunner: BUG! exception in phase 'semantic analysis' in source unit 'Script40.groovy' Bundle is uninstalled Comment by francis November 2014

Got the same thing but cycling the addon is not resolving the problem, which is happening since we installed the service desk add-onThis stack trace is raised when you have a 'commentvalidator' script in your workflow transition.The full stack trace is http://pastebin.com/B4Sj2Ak1

in ScriptRunner: BUG! exception in phase 'semantic analysis' in source unit 'Script40.groovy' Bundle is uninstalled Comment by francis November 2014

francis Atlassian Partner

Comments