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.


asked 04 Feb '16, 04:19

AlfAbetas's gravatar image

accept rate: 11%

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,


answered 12 Feb '16, 03:23

Yalim's gravatar image

Yalim ♦♦
accept rate: 20%

Thanks ,

I solve this proble. I'm using api_component.getGridState . If for something interesting a can send code


answered 12 Feb '16, 03:36

AlfAbetas's gravatar image

accept rate: 11%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported



Asked: 04 Feb '16, 04:19

Seen: 1,718 times

Last updated: 12 Feb '16, 03:36

© Copyright Gerger 2017