Hello, Using grid filter functionality, how to get query with all filter parameters ? Or how to get columns name with a set filtering value ? I use grid with a filter funcionality. When i printing info from datagrid with a api_component.printToExcel(...). Is all ok, for me exporting in excel only filtered rows. But if i want make self report which starting from another oracle session, i can't prepare sql for this. Thanks |
Hi AlfAbetas, There are several API's which may help you. api_datasource.getQuery, api_datasource.getFilterWhereClause and api_datasource.getDefaultQuery. If you are using a Grid's buiult-in functionality to perform a search in a datasource, api_component.getGridState may also contain the where clause fragments. I'd recommend you experimenting with these API's to get the result you want. Kind Regards, |