Wijmo Grid evaluation

Posted by: ashuvashistha-ashish on 14 September 2017, 12:01 pm EST

Please login to follow topic

ashuvashistha-ashish
- Post Options:
- Link
  Copy
Posted 14 September 2017, 12:01 pm EST

Hi I am evaluating Wijmo grid for one of our project. I did not find any place where I can put my queries related evaluation so I am putting my query here.

Our requirement is that we have a graph component having different nodes in our project and there is data associated with every graph component. When user clicks on graph component then we need to show the data in a grid in a separate tab. Like for each component we need to open a separate tab in that tab we need to open a separate grid in that we want all the functionality like sorting filtering row editing a so can we do it by using Wijmo grid. Can you give me link where this kind of functionality is done?

Thanks

Ashish
manish-gupta1
- Post Options:
- Link
  Copy
Posted 14 September 2017, 12:01 pm EST

Hello,

As per understanding, you have graph component bind to data source and now you would like to open new tab with clicked graph data source in a FlexGrid.

If yes, you can achieve this using angular routing if you are using angular. On click on graph component, pass data source as query string for routed page.

Second way,

You can use local storage for saving data on graph click. And open new tab and show FlexGrid using saved data in local storage.

If you share the technology you are using, we can provide sample accordingly.

Thanks,

Manish Kumar Gupta
ashuvashistha-ashish
- Post Options:
- Link
  Copy
Posted 14 September 2017, 12:01 pm EST

Hi Manish,

We are done with that now we have two more requirements I am posting these here. These are very critical requirement for us. If wijmo is able to fulfill these then we will order a new license as our japan team already bought licenses for wijmo and we will buy one more for india team as well.

First requirement is We want to filter data on server, can we do it in wijmo grid? If yes then can you give us a sample where filtering is done on server side? We can not use OdataCollectionView class of wijmo, because our database tables are generated programmatically so we do not have definite entities for writing the Odata service.

Without using the OData service can we do paging and filtering on server using wijmo grid?

Second requirement is that we are showing 200 records at a time on the grid and by scrolling the grid, we are loading more data in to the grid. but when user click on filter icon on grid, while showing the unique value to the user, we want to the all the unique values for the column to should be shown to user. like in grid we have only 200 records but on server table we have 40000 unique values for that column then we want to show all 40000 values in the filter popup. So can we do this in Wijmo grid. If yes then can you provide the example or source code to achieve these two requirements

These two are our very critical requirements.

Thanks in advance for your help
manish-gupta1
- Post Options:
- Link
  Copy
Posted 14 September 2017, 12:01 pm EST

Hi Ashish,

For server side filtering and paging, ODataCollectionView is efficient. However, you cannot use OData service so we will suggest you to go with ServerCollectionView that provide functionality of server side paging and filtering.

For your reference, please refer to the following demo sample that implements the same.

http://demos.wijmo.com/5/Angular2/ServerCollectionView/ServerCollectionView/

Demo sample can be found in sample folder that shipped along with downloaded build folder. You can found sample at following location:

Folder_Path\C1Wijmo-Eval_5.20171.293\Samples\TS\Angular2\ServerCollectionView

You can also set unique values for filter popup by setting uniqueValues property of valueFilter. This issue has been discussed on the forum and can be found here:

http://wijmo.com/topic/populating-flexgridfilter-uniquevalues/

Hope it helps you !

If you are willing to purchase license for India branch, you can contact to India sales team at sales.india@grapecity.com

Thanks,

Manish Kumar Gupta
ashuvashistha-ashish
- Post Options:
- Link
  Copy
Posted 14 September 2017, 12:01 pm EST

Hi Manish,

Thanks for your help

We have take a look to servercollectionview class which you have mentioned above and it is working for us but our requirement is slight different. Right now severcollectionview having API call inbuilt in it so it is fired on the filters apply button. But our requirement is that we need to sent the server call on different button which is outside of grid so can we do it in wijmo.

For second requirement we are able to show the unique values from sever but we have huge amount of data in filter unique values around 10 lacs to 1 carore records for each column so when we try to show the records in filter popup the page is crashed. So can you tell is there any to handle this situation in wijmo grid.
manish-gupta1
- Post Options:
- Link
  Copy
Posted 14 September 2017, 12:01 pm EST

Hi Ashish,

We are sorry for the delayed response.

Regarding your first query, as we understand, you would like to apply the filter on button clicked placed outside FlexGrid. If yes, you can call filter API on button click and assign data to FlexGrid when you get a response from API.

For the second requirement,

It would take a little while to show new data in Filter and there would be some delay in displaying records, as it depends on the count of records. We have escalated this issue to the concerned team for further investigation with tracking id 261358. We will let you know as soon as we get any update on this.

Thanks,

Manish Kumar Gupta
ashuvashistha-ashish
- Post Options:
- Link
  Copy
Posted 14 September 2017, 12:01 pm EST

Thank you Manish for your reply. At the moment we are in the process of finalizing the licensing requirements of the current application.

Anyways, I have one more query. Is there a way through which I can get the reference of a control by the DOM element id? I tried wijmo.Control.getControl(‘’) method but it returns an object of type “wijmo.Control” whereas I want the reference of the actual control.

For example:

var elementId = ‘someId’;

var grid = new wijmo.grid.FlexGrid(“#” + elementId); // object of type wijmo.grid.FlexGrid

var ctrl = wijmo.Control.getControl(“#” + elementId); // returns wijmo.Control type object

here ctrl is of type wijmo.Control but I want to get the reference of the original grid (an object of type wijmo.grid.FlexGrid)

manish-gupta1

Post Options:
Link
Copy

Posted 14 September 2017, 12:01 pm EST

Hi Ashish,

We are sorry, we are able to get Control reference by using

wijmo.Control.getControl('#theGrid');

For your reference, please see the plunker that implements the same.

Since you are using Angular 2, you can get reference using ElementRef. Please refer to the following code snippet:

<wj-flex-grid #flex></wj-flex-grid>
// TS
import * as wjGrid from 'wijmo/wijmo.grid';
class AppCmp{
   @ViewChild('flex') flex:wjGrid.FlexGrid;
  ngAfterViewInit(){
     console.log(this.flex);
  }
}

Thanks,

Manish Kumar Gupta

ashuvashistha-ashish
- Post Options:
- Link
  Copy
Posted 14 September 2017, 12:01 pm EST

Hi Manish

Can you tell me the pricing of wijmo and from where we can buy it online.

Thanks

Ashish
manish-gupta1
- Post Options:
- Link
  Copy
Posted 14 September 2017, 12:01 pm EST

Hi Ashish,

You can refer to the following page for Wijmo Pricing. For further details regarding licensing and purchasing, please feel free to contact our sales team at sales.india@grapecity.com or you can call at:

Tel 120.2470111 | 120.2470123

Fax 120.2470124

You can also share your email id, our sales team will contact you.

Thanks,

Manish Kumar Gupta
manish-gupta1
- Post Options:
- Link
  Copy
Posted 14 September 2017, 12:01 pm EST

Hi Ashish,

Sorry for the inconvenience due to missing page link. Please find the Wijmo pricing page link in this thread.

http://wijmo.com/purchase/

Regards,

Manish Kumar Gupta
ashuvashistha-ashish
- Post Options:
- Link
  Copy
Posted 14 September 2017, 12:01 pm EST

Hi Manish,

Sorry to disturb you again. We send the mail to sales.india@grapecity.com but they are not replying. I am sharing my email id with you which is ashuvashistha.ashish@gmail.com

Thanks

Ashish
manish-gupta1
- Post Options:
- Link
  Copy
Posted 14 September 2017, 12:01 pm EST

Hi Ashish,

We are sorry for the inconvenience and thank you for additional information.

We reached to our sales team with information provided by you and got to know that your email was ended up in spam. Hence, we are sorry for the delay. Our sales team will contact you soon.

Thanks,

Manish Kumar Gupta
ashuvashistha-ashish
- Post Options:
- Link
  Copy
Posted 14 September 2017, 12:01 pm EST

Hi Manish,

I was wondering if the flex grid differentiates between empty strings and null values. The issue that I now have is, my datasource table has both type of values in a varchar field i.e NULL as well as empty strings and I want to able to filter on both type of values but looks like the filter popup shows only (nothing) in unique values checkbox list. On applying the filter for (nothing) the filter sent to the server is like “[FieldName] IN (‘’)”. Can you please suggest a workaround?

and one more thing we are mailing at sales.india@grapecity.com from e-mail nakatani@diva.co.jp for purchasing the license

Thanks
manish-gupta1
- Post Options:
- Link
  Copy
Posted 14 September 2017, 12:01 pm EST

Hi Ashish,

We are sorry, currently, there is no workaround for THIS. This issue has been escalated to the concerned team for further investigation with tracking id 262187. We will let you know as soon as we get any update on this.

Thanks,

Manish Kumar Gupta
ashuvashistha-ashish
- Post Options:
- Link
  Copy
Posted 14 September 2017, 12:01 pm EST

HI Manish

We have a requirement where we need to show close button like X on filter search text box and clicking on that button the value on filter text will be cleared can we do this in wijmo grid and if yes then how can we do this .

Thanks

Ashish
manish-gupta1
- Post Options:
- Link
  Copy
Posted 14 September 2017, 12:01 pm EST
Hello Ashish,

For this, you need to add Button in filter editor inside filterChanging event by DOM manipulating.

You can get/set search box value using following code snippet:

document.querySelector('input[wj-part="input"]:not([style="display: none;"])').value

Filter dialog can be get using the following code snippet:

document.querySelector('div.wj-columnfiltereditor')

Maybe you need to use setTimeout method for manipulating DOM.

Thanks,

Manish Kumar Gupta

ashuvashistha-ashish

Post Options:
Link
Copy

Posted 14 September 2017, 12:01 pm EST

Hi Manish

This solution is not working for me. Please have a look at my code

self._filter.filterChanging.addHandler(function (s: wijmo.grid.filter.FlexGridFilter, e: wijmo.grid.CellRangeEventArgs) {

e.cancel;

debugger;

var Y = document.querySelector(‘div.wj-columnfiltereditor’);

            const cf = s.getColumnFilter(e.col);
           
            if ('undefined' == typeof cf.valueFilter.uniqueValues) {
               
            }
        });

I am always getting Y as null.

Can you tell if I am doing anything wrong.

ashuvashistha-ashish
- Post Options:
- Link
  Copy
Posted 14 September 2017, 12:01 pm EST

Hi Manish,

I have applied your solution and success fully implement the X button on filter list.

But when I click the X button then value of text box is cleared but the filter list is not reset as it does in case of deleting the value in text box by key board.

like initially i have have 200 rows in filter list by searching in remains 3 when I hit X button it sticks to 3 but it should be reset to 200 as initial

Can you suggest the way by which we can reproduce the same functionality on X button.

Thanks

Ashish
manish-gupta1
- Post Options:
- Link
  Copy
Posted 14 September 2017, 12:01 pm EST

Hello Ashish,

We need to reset uniqueValues on clear button click for showing values again.

For your reference, please see the attached sample that implements the same.

Thanks,

Manish Kumar Gupta

2017/06/FlexGrid_filter_input_clear.zip
ashuvashistha-ashish
- Post Options:
- Link
  Copy
Posted 14 September 2017, 12:01 pm EST

Hi Manish

Any progress on this

We are sorry, currently, there is no workaround for THIS. This issue has been escalated to the concerned team for further investigation with tracking id 262187. We will let you know as soon as we get any update on this.

It would take a little while to show new data in Filter and there would be some delay in displaying records, as it depends on the count of records. We have escalated this issue to the concerned team for further investigation with tracking id 261358. We will let you know as soon as we get any update on this.

Thanks

Ashish
manish-gupta1
- Post Options:
- Link
  Copy
Posted 14 September 2017, 12:01 pm EST

Hello Ashish,

We are sorry, these issues are still with the concerned team. We have requested for an update on this issue.

We will let you know as soon as we get any update on this.

Thanks,

Manish Kumar Gupta
manish.gupta
- Post Options:
- Link
  Copy
Posted 8 January 2018, 8:05 am EST

Hi Ashish,

The developer make a process a little faster and we need to use setTimeout with 0 delay to get columnfilter HTML. Please refer to the fiddle:

http://jsfiddle.net/mkgupta911/6GB66/886/

~Manish

Please login to reply to thread

Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels

ComponentOne

Forums for all current editions of the ComponentOne .NET UI control product line, including ComponentOne Studio and ComponentOne Studio for Xamarin.
ActiveReports

Forums for all versions of ActiveReports and ActiveReports Server
Spread

Forums for all current versions of Spread .NET spreadsheets, SpreadJS JavaScript spreadsheets, and SpreadCOM spreadsheets.
Wijmo

Forums for all Wijmo products, including Wijmo Core, FinancialChart, FlexSheet, MultiRow, OLAP, and ReportViewer
- General Discussion
Document Solutions

Forums for all Document Solutions products, including Document Solutions for PDF, Word, Excel (.NET and Java), and Imaging.