Search found 19 matches

by s.wieczorek
Tue Oct 24, 2017 7:34 am
Forum: Stimulsoft Reports.JS
Topic: OData and dynamic filters
Replies: 7
Views: 3100

Re: OData and dynamic filters

So there is no possibility to dynamically add variables to filters for OData requests.... Will it be added in the future? It would be good to make Datasource requests the server with addition of filters. Now it will pull all data from DB(which can cause performance problems) or hardcoded set only.
by s.wieczorek
Mon Oct 23, 2017 6:03 am
Forum: Stimulsoft Reports.JS
Topic: OData and dynamic filters
Replies: 7
Views: 3100

Re: OData and dynamic filters

But will this send filters to OData server or will it filter data on the clients side?
by s.wieczorek
Fri Oct 20, 2017 7:12 am
Forum: Stimulsoft Reports.JS
Topic: OData and dynamic filters
Replies: 7
Views: 3100

OData and dynamic filters

Hi,
Can i add dynamic filters to OData requests just like for sql commands (using @<VariableName>)? If not, how to make component send requests with /$filter=fieldName eq '<var from stimulsoft>'
by s.wieczorek
Fri Oct 20, 2017 7:10 am
Forum: Stimulsoft Reports.JS
Topic: Count based on previous column value
Replies: 5
Views: 2456

Re: Count based on previous column value

I've solved it by adding another view to mongo that is returning grouped results
by s.wieczorek
Thu Oct 19, 2017 5:40 am
Forum: Stimulsoft Reports.JS
Topic: Count based on previous column value
Replies: 5
Views: 2456

Re: Count based on previous column value

Yes, I've seen it. But how to use it with some kind of parameter from the value of the previous column? For example, I need Count where language == ENGLISH (dynamically). I'm connecting to OData service that is pulling data from MongoDB
by s.wieczorek
Wed Oct 18, 2017 1:13 pm
Forum: Stimulsoft Reports.JS
Topic: Count based on previous column value
Replies: 5
Views: 2456

Count based on previous column value

Hi,
How can i do distinct count based on a value from a previous column?
by s.wieczorek
Tue Oct 10, 2017 12:03 pm
Forum: Stimulsoft Reports.JS
Topic: Programmatically add OData datasource
Replies: 7
Views: 4551

Re: Programmatically add OData datasource

Thank you. Another question is how to set a datatype to certain column? For example to have a StiDataColumn being a boolean type...
by s.wieczorek
Thu Oct 05, 2017 1:59 pm
Forum: Stimulsoft Reports.JS
Topic: Programmatically add OData datasource
Replies: 7
Views: 4551

Re: Programmatically add OData datasource

Thank you. It's working well. Another question is that we need to add some relations between tables (due to your component doesn't support complex types we will be working on mongodb views with flat structure). How can we add relations programmatically?
by s.wieczorek
Wed Oct 04, 2017 9:32 am
Forum: Stimulsoft Reports.JAVA
Topic: Reports.Java 2017.1.11 + MongoDB
Replies: 15
Views: 10547

Re: Reports.Java 2017.1.11 + MongoDB

How can I use jdbc connection to mongodb? I tried some third party commercial products like http://www.unityjdbc.com. Bug generally I'm having many issues with it (exceptions, tables in designer are quite ugly - i mean nested objects as relation tables)
by s.wieczorek
Wed Oct 04, 2017 8:26 am
Forum: Stimulsoft Reports.JS
Topic: Programmatically add OData datasource
Replies: 7
Views: 4551

Re: Programmatically add OData datasource

Could you specify more information? Or at least indicate where to find a similar example? How to connect to OData service from within StiDataTableSource? i'm getting an error with the following code snippet: function init() { var options = new window.Stimulsoft.Designer.StiDesignerOptions(); options...