TableFilter and QueryBuilder possible bug?

Questions and answers on designing your Servoy solutions, database modelling and other 'how do I do this' that don't fit in any of the other categories

TableFilter and QueryBuilder possible bug?

Postby steve1376656734 » Thu Oct 02, 2014 6:36 pm

Hi,

I am running Servoy 7.4.1 on Mac and Linux and in my solution I have a global table filter set on organisation_id for all tables and this works with no problems when using found sets. I now have some code that uses the query builder to generate custom queries that reference tables with the global table filter applied and I am finding that the table filter seems to be ignored.

I am using a QBSelect object to build my custom query and then running databaseManager.getDataSetByQuery(qbSelectObject, -1) to populate my dataset. The Wiki implies that using this particular version of the getDataSetByQuery should honour the table filter but my experience shows that it is not.
There are only two ways to circumvent a table filter:
# by issuing a custom SQL query String through the getDataSetByQuery method of the databaseManager API. (Note: the version of getDataSetByQuery that takes a QueryBuilder object as first parameter DOES take into account applicable TableFilters

The Performance Data section of the Servoy Admin page shows the query without any reference to the fields to be filtered. Am I doing something wrong or should I report this as a bug?

Thanks
Steve
Steve
SAN Developer
There are 10 types of people in the world - those that understand binary and those that don't
steve1376656734
 
Posts: 327
Joined: Fri Aug 16, 2013 2:38 pm
Location: Ashford, UK

Re: TableFilter and QueryBuilder possible bug?

Postby Harjo » Fri Oct 03, 2014 9:32 am

If you have a reproducible sample I would file it as bug
Harjo Kompagnie
ServoyCamp
Servoy Certified Developer
Servoy Valued Professional
SAN Developer
Harjo
 
Posts: 4321
Joined: Fri Apr 25, 2003 11:42 pm
Location: DEN HAM OV, The Netherlands

Re: TableFilter and QueryBuilder possible bug?

Postby steve1376656734 » Wed Oct 08, 2014 12:10 pm

Thanks Harjo - I have filed it as SVY-7300 with a small sample project

Steve
Steve
SAN Developer
There are 10 types of people in the world - those that understand binary and those that don't
steve1376656734
 
Posts: 327
Joined: Fri Aug 16, 2013 2:38 pm
Location: Ashford, UK

Re: TableFilter and QueryBuilder possible bug?

Postby huber » Thu Jan 12, 2017 4:54 pm

Hi All

I have come across the exact same situation with Servoy Developer 7.4.4. I don't find the case number SVY-7300. Can anyone confirm in which Version this is solved?

steve1376656734 wrote:Thanks Harjo - I have filed it as SVY-7300 with a small sample project

Steve


Regards,
Robert Huber
7r AG, Switzerland
SAN Developer
http://www.seven-r.ch
User avatar
huber
 
Posts: 516
Joined: Mon May 14, 2012 11:31 pm

Re: TableFilter and QueryBuilder possible bug?

Postby steve1376656734 » Thu Jan 12, 2017 5:03 pm

Hi Robert,

I believe this is solved only in version 8 as it was considered a breaking change. You can view the support request by clicking SVY-7300

Steve
Steve
SAN Developer
There are 10 types of people in the world - those that understand binary and those that don't
steve1376656734
 
Posts: 327
Joined: Fri Aug 16, 2013 2:38 pm
Location: Ashford, UK


Return to Programming with Servoy

Who is online

Users browsing this forum: No registered users and 13 guests

cron