How can I set the searchable column in an IG report with JavaScript or APEX API? The default is set to All Text Columns. In the samples apps on EMP, I would like to set that column to Ename. Is there a way to limit the columns in the list?
Thanks.
Greg GrimesContributor
20.2 APEX: How can I pre-select the searchable column in an IG report
1 Answer
You must login to add an answer.
ApexPadawan
Yes you can limit the columns to search on by simply doing the following:
Navigate to a column that you don't want to the user to be able to search on, for example the EMPNO column.
Under the column properties scroll down to Enable Users To and turn off the Filter property. This will remove this column from the available list of columns to search through.
When you save and run the page you will notice that the EMPNO column no longer appears in the searchable list of columns under the magnifying glass.
Now, even with the default selection of All Columns, the search field will only search on the ENAME column.
Hope this helps!