JAQLine Plugin - Visualize Widget’s Queries

Comments

31 comments

  • Avatar
    Mark Busuttil

    I added the plugin and re-started the service, however when I click on Analyze Widget JAQL I get a blank page with only the description on the top left.

     

    Anyone experiencing the same issue?

  • Avatar
    Gideon B

    Hi Mark, 

    What version of Sisense are you using? 

  • Avatar
    Stuart Gaston

    Hello,

    I'm experiencing a similar result on V6.4.0.30091

    We'll be rolling on to 6.5 soon, is this something that relies on the newer versions?

    Thanks

  • Avatar
    Stuart Gaston

    Hi Gideon,

    Just noticed the version disclaimer at the top - we'll look to upgrade asap!

    Thanks for the plugin

  • Avatar
    Malinda Jepsen

    Is there a way to remove this functionality for plain users and only be available for designers and admins?

  • Avatar
    Arik

    Thanks for bringing this up Malinda, I will check.

    Best,

    Arik

  • Avatar
    Malinda Jepsen

    And, I should add... it's very cool!

  • Avatar
    Ahuva Hazan-Fuchs (Edited )

    The plugin was updated.  The plugin functionality is now hidden for viewer users.

  • Avatar
    Malinda Jepsen

    Thanks Ahuva!

  • Avatar
    Wendy Adams

    I'm a bit confused by your image (in the ids/linkages between Patients, Divisions, Rooms and Admissions).  Are there just a couple of 'line crossovers' (i.e. should the Patient linkage be shown in the upper right quadrant to avoid this), or is there some kind of 'indirect' relationship stuff going on there, or what?

  • Avatar
    Dean Shub

    Hi Wendy,

    you're absolutely right, it does seem like there is a connection between them, but there is no real connection it is just line crossover.

    When you activate JAQLine, the graph is interactive, so you can move around the nodes to see if there is a real connection or not :)

  • Avatar
    Alice Summers

    I've just learned about this plugin on the 6.7 Release webinar - I'm new to BI  and it's going to be so useful!

    Is there an article with more details around what to look out for?

  • Avatar
    Sam Ovenshine

    Hi Alice,

    Unfortunately, there's not much more in the way of documentation on this plugin. A many side of a relationship is represented with the infinity symbol. You'll want to look for joins between tables where both sides have the many symbol to help detect a many-to-many relationship. More generally, you can use the plugin to see what tables/fields are involved in a widget. But for most of our customers, the plugin is primarily used as a many-to-many detection tool.

    Sam

  • Avatar
    Andy Chan (Edited )

    This has been working fine for the last 2 weeks, but now we have the blank window showing for this, but we are on v6.6.  

    I have restarted the Sisense app pool and IIS, but the problem is still there.

    Any ideas what the issue might be? 

     

    Update:
    Works ok in Chrome, but IE shows the blank page. It may be a setting - I allowed pop-ups but it wasn't that. Will use Chrome anyway.

  • Avatar
    Nouman bhatti

    I'm not able to see the option in the dropdown menu . 

    It worked fine for few days but after that  I don't know what happened

  • Avatar
    Michael Sutton

    I got Sisense 7.0. and it stopped working for me.

    Any ideas what's wrong here?

  • Avatar
    Oxana Noa Umansky

    Hi all,

    We'll look into the compatibility of the plugin with version 7.0 and get back to you with an update. 

    Also, if you are still experiencing issues with this plugin, not related to the latest version, please let us know in the comments below. 

    Thanks,

    Oxana

  • Avatar
    David Hertzberg

    Hi, great plugin !

    But it looks like it is blocking the treillis widget to work : when JAQLine is activated, the treillis widget does not appear in the drop down list when creating a widget. It is back when I deactivate the JAQLine.

    Best,

    David.

  • Avatar
    Oxana Noa Umansky

    Hi David,

    Are you using the latest version of the plugin?  

  • Avatar
    David Hertzberg

    Hi Oxana,

    thanks, you were right, version was not the lastest one ...

    You know everything ! next time I'll be more carefull ...

    Best, David.

  • Avatar
    Oxana Noa Umansky

    Glad I could help 😊

  • Avatar
    Jordy Finkers

    With Jaqline enabled we get that our filters on the right remain the same, but filtered data is date or year minus 1.

    Anyone experiencing the same? We're using the latest plugin version and Sisense version 7.1.2.11001.

     

  • Avatar
    Chris Bridges

    Hey Jordy, I just downloaded this widget. Are you still having filtering problems or any other problems related to this that you can elaborate on?

     

    -Chris

  • Avatar
    Jordy Finkers

    Hi Chris,

    We disabled JAQline and haven't used it since so I'm not sure what issues we still have.

    We couldn't get the filtering issues solved but that was the only issue we had.

  • Avatar
    Michael Becker

    In general this plugin offsets date filters by one, so by 1 year, quarter etc.

  • Avatar
    Chris Bridges

    Thanks for getting back so quickly. That is a bummer but I guess an option is to only turn it on when you've made new widgets and want to check data relationships. 

    I wonder if anyone from Sisense is working on the filtering issue considering they are now supporting this widget. 

     

  • Avatar
    David Burke

    Not sure if there are other variables at play but we were unable to email reports with the JAQLine plugin turned on in 7.2, It took some trial and error but sure enough, turning off just this plugin allowed our on demand email reports to work again.

    Just an FYI in case anyone else has an issue.

  • Avatar
    Ahuva Hazan-Fuchs (Edited )

    Hi David,

    Are you using the regular system email sending functionality?

    If so, this sounds like a bug, as the system should be fully functional, when the JAQLine plugin is enabled.  

    Can you please open a support ticket, and we'll look into this?

    Thanks,

    Ahuva

  • Avatar
    David Burke (Edited )

    Hi Ahuva,

    I had opened a ticket and added the resolution (turning off JAQLine) so the ticket was closed.

     

    https://support.sisense.com/hc/en-us/requests/84484

     

    I was using the "Send me a report now" option with embedded email. The header and footer of the email come through but the embedded report in the body gives the connection error shown below.

     

     

     

  • Avatar
    Tim Friesen

    David Burke, I just confirmed that we also experience this issue but it only actually occurs when both the JAQline plugin is enabled as well as the dashboard contains a chart from another plugin.  The charts that come in the box export fine via email even with JAQline plugin enabled.  

    I am so glad I came across this comment since I thought I was going to have to disable all of the additional chart plugins since none of the exported.  Now with the JAQline plugin disabled, I am able to export these fine.

    So for me....

    temporary solution: disable JAQline widget
    permanent solution: fix JAQline widget to work with plugin charts when emailing (obviously that is not for me to do)

Please sign in to leave a comment.