Repository navigation
Plot when values are NULL #513
Description
Hello,
in attached database, i perform the following query:
select * from M1 left join M2 on M1.timestamp = M2.timestamp
This delivers the below result (in CSV format):
timestamp,M1,timestamp,M2
2015-07-15 23:59:51,0.0,2015-07-15 23:59:51,10.0
2015-07-15 23:59:52,1.0,2015-07-15 23:59:52,12.0
2015-07-15 23:59:53,2.0,,
2015-07-15 23:59:54,3.0,,
2015-07-15 23:59:55,4.0,,
2015-07-15 23:59:56,5.0,2015-07-15 23:59:56,13.0
2015-07-15 23:59:57,6.0,2015-07-15 23:59:57,14.0
2015-07-15 23:59:58,7.0,2015-07-15 23:59:58,15.0
2015-07-15 23:59:59,8.0,,
But in the plot I can only select 'timestamp' and 'M1'. 'M2' is not available presumably because there are NULL values present in that column.
Is it possible to add a feature to have this column available also in the plot, and draw previous value or Nothing (plot with holes) when NULL values are present in the query result?
Best regards
Carl.
Activity
zwrmueller commentedon Feb 9, 2016
could be also related to:
Plot misses columns with NULL as first value #499
Regards Ralf
MKleusberg commentedon Oct 13, 2016
This is related to issue #822. Good news is that this is finally fixed now.
@wolfc01 If you are still interested in this, can you try tomorrow's nightly build and report back if it's working for you now? 😃
MKleusberg commentedon Jan 6, 2017
Any update on this, @wolfc01? 😃
MKleusberg commentedon Jan 27, 2017
Closing this because it's an old issue without any updates recently. If this isn't working for you as expected, please reopen this issue. 😃
justinclift commentedon May 3, 2017
@wolfc01 Carl, out of curiosity did you ever get time to check if this is fixed from your point of view?
zwrmueller commentedon May 10, 2017
Hi Justin, how can I make use of and test the nightly builds for Windows64 if I sit on a sqlitebrowser portable app version and have no administer priviledges?
Regards
Ralf
justinclift commentedon May 10, 2017
@zwrmueller Hmmm... I don't think we have a useful ongoing way to do that (yet).
If you need something to test "once off", I can grab our latest nightly, install it in a VM here, then make a .zip file of the installed files. I think if you unzip that into a place of your choosing, then that should work.
No guarantees 😁 , but worth a shot if you need a nightly to try. 😄
chrisjlocke commentedon May 10, 2017
You don't need to install in a VM and .ZIP it back up again - simply download the latest nightly and unzip that using 7zip - it'll create some 'wacky' directories, but the core files will be in one directory, then the 'platforms' directory.
justinclift commentedon May 10, 2017
@chrisjlocke Cool, didn't know that. Sounds practical then. 😄
chrisjlocke commentedon May 10, 2017
So, ignore the $PLUGINS directory, as thats the setup file's 'noise'.
...and the 'redist' directory, as that'll be installed anyway. So just replace the files into the 'APP' directory of the portable installation.
I'll write this into the Wiki, as I'm sure someone else out there has the portable version! ;) 🍫
zwrmueller commentedon May 10, 2017
Great! I checked this before but was'nt successful. But you encouraged me to hang on. And in addition to your hints, for me I needed to replace (update) the platforms directory in addition to the files mentioned by you.
...
Hm, as I see by now, you already mentioned the platforms directory by yourself.
Wiki is a good idea, cause next time I like to use a nightly, I will not remember what I've just learned here ;-)
Well, thanx
Ralf