Page 1 of 2

Some questions

Posted: Mon Jan 10, 2011 7:52 am
by Edmund Andersson
Hi!

I´m quires to know if any work has been done on the Filter function, or if this function will be realized in a near future?!

Because we need our users (personal) to be able to sort data between different dates and they can´t be forced to change
the SQL query in the database connection (because they have no SQL knowledge what so ever)…

As well if anything has been done to fix the problem with tables and columns with national characters in? (Like åäö)… UTF8 support?

Apart from that your products rocks...!! :biggrin:

Regards

Edmund

Some questions

Posted: Mon Jan 10, 2011 8:55 am
by Vladimir
Hello,
I´m quires to know if any work has been done on the Filter function, or if this function will be realized in a near future?!
We had planned to include the filters in the next prerelease build on January 11.

As well if anything has been done to fix the problem with tables and columns with national characters in? (Like åäö)… UTF8 support?
Please try to add the 'charset' parameter to a connection string:

Code: Select all

server=localhost;database=test_db;user=root;charset=utf8;
Thank you.

Some questions

Posted: Mon Jan 10, 2011 9:21 am
by Edmund Andersson
Thanks for your reply...
We had planned to include the filters in the next prerelease build on January 11.
Looking foward to that :-)
Please try to add the 'charset' parameter to a connection string:

Code: Select all

server=localhost;database=test_db;user=root;charset=utf8;
I have tried that but it keeps telling me "No data found" when I try to retrive columns...

The SQL query looks like this (tried all combinations)

Code: Select all

select * from baumholder_skåpleveranser_länder
select * from baumholder_skåpleveranser_länder;
select * from 'baumholder_skåpleveranser_länder'
select * from 'baumholder_skåpleveranser_länder';
And when I chane to another column without any strange characters it works great...


Regards

Edmund

Some questions

Posted: Tue Jan 11, 2011 5:07 am
by Vladimir
Hello,

We have fixed this error. The update, including filters, will be available in prerelease build on January 11.

Thank you.

Some questions

Posted: Fri Jan 14, 2011 4:48 pm
by Edmund Andersson
Hi again guys!

Thanks for your updates.

The filter function works as it should but there is still some issues with the special characters.

It works in the connection and retrives all columns in a table that includes åäö in the name.

But when I build a report it won't fetch any data from a colum that includes åäö in the columname.

Best Regards.

Edmund

Some questions

Posted: Mon Jan 17, 2011 2:44 am
by Vladimir
Hello,

We will try to fix this error to the next prerelease build on January 18.

Thank you.

Some questions

Posted: Tue Jan 25, 2011 10:14 am
by Edmund Andersson
Hi there!

Now I´m back with some more issues about the Filter function.

I have a table with the following structure.

LogDt (DateTime, like 2010-01-20 18:50:06, 2010-01-20 18:55:06 and so on (YYYY-MM-DD)).
R11_In (varchar).
R12_Ut (varchar).

When I try to add a filter and only get the date in the timespan I keep getting Server Time Out.

First of all I tried the filter and selected Value -> DateTime -> LogDt -> Greater than -> 2010-01-18 00:00:00, but when I close the filter window and reopen it again the '2010-01-18 00:00:00' has disappeared.
Same thing if I remove the time part.

If I use the little calander function I get another time format (DD-MM-YYYY) but it still don´t work (and I cant add a time)...

I also tried the expression part with halmstad_skiftdata.LogDt > 2010-01-01%, halmstad_skiftdata.LogDt > '2010-01-01%', halmstad_skiftdata.LogDt > 2010-01-01, halmstad_skiftdata.LogDt > '2010-01-01' and so on, but nothing works.

Is this an error in the report tool or am I doing something wrong?

Regards Edmund

Some questions

Posted: Wed Jan 26, 2011 7:03 am
by Vladimir
Hello,

Unfortunately, when working with dates in filters you can only set the date. Time will not be counted. We changed the date and time functions, now they can be compared in the expressions. The update will be available in the next prerelease build on February 1. Let us know if you need a new build immediately.

Thank you.

Some questions

Posted: Wed Jan 26, 2011 9:09 am
by Edmund Andersson
Thanks Vladimir!

:feelgood:

No its´s okay, I can wait untill 1 February...

Best Regards

Edmund

Some questions

Posted: Wed Jan 26, 2011 1:59 pm
by Andrew
Ok!

Thank you for letting us know about this.