JAQLine Plugin - Visualize Widget’s Queries

Comments

42 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?

    0
    Comment actions Permalink
  • Avatar
    Gideon B

    Hi Mark, 

    What version of Sisense are you using? 

    0
    Comment actions Permalink
  • 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

    0
    Comment actions Permalink
  • Avatar
    Stuart Gaston

    Hi Gideon,

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

    Thanks for the plugin

    1
    Comment actions Permalink
  • Avatar
    Malinda Jepsen

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

    0
    Comment actions Permalink
  • Avatar
    Arik

    Thanks for bringing this up Malinda, I will check.

    Best,

    Arik

    0
    Comment actions Permalink
  • Avatar
    Malinda Jepsen

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

    0
    Comment actions Permalink
  • Avatar
    Ahuva Hazan-Fuchs (Edited )

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

    0
    Comment actions Permalink
  • Avatar
    Malinda Jepsen

    Thanks Ahuva!

    0
    Comment actions Permalink
  • 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?

    0
    Comment actions Permalink
  • 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 :)

    1
    Comment actions Permalink
  • 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?

    0
    Comment actions Permalink
  • 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

    0
    Comment actions Permalink
  • 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.

    0
    Comment actions Permalink
  • 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

    0
    Comment actions Permalink
  • Avatar
    Michael Sutton

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

    Any ideas what's wrong here?

    0
    Comment actions Permalink
  • 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

    0
    Comment actions Permalink
  • 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.

    0
    Comment actions Permalink
  • Avatar
    Oxana Noa Umansky

    Hi David,

    Are you using the latest version of the plugin?  

    0
    Comment actions Permalink
  • 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.

    0
    Comment actions Permalink
  • Avatar
    Oxana Noa Umansky

    Glad I could help 😊

    0
    Comment actions Permalink
  • 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.

     

    1
    Comment actions Permalink
  • 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

    0
    Comment actions Permalink
  • 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.

    0
    Comment actions Permalink
  • Avatar
    Michael Becker

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

    0
    Comment actions Permalink
  • 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. 

     

    0
    Comment actions Permalink
  • 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.

    2
    Comment actions Permalink
  • 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

    0
    Comment actions Permalink
  • 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.

     

     

     

    0
    Comment actions Permalink
  • 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)

    1
    Comment actions Permalink

Please sign in to leave a comment.