1. API reference
    1. Introduction
    2. Flexmonster()
  2. Objects
    1. All objects
    2. Report Object
    3. Slice Object
    4. Options Object
    5. Format Object
    6. Conditional Format Object
    7. Cell Data Object
  3. Methods
    1. All methods
    2. addCalculatedMeasure
    3. addCondition
    4. clear
    5. clearFilter
    6. clearXMLACache
    7. closeFieldsList
    8. collapseAllData
    9. collapseData
    10. connectTo
    11. customizeCell
    12. customizeContextMenu
    13. dispose
    14. expandAllData
    15. expandData
    16. exportTo
    17. getAllConditions
    18. getAllHierarchies
    19. getAllMeasures
    20. getCell
    21. getColumns
    22. getCondition
    23. getData
    24. getFilter
    25. getFilterProperties
    26. getFormat
    27. getMeasures
    28. getMembers
    29. getOptions
    30. getReport
    31. getReportFilters
    32. getRows
    33. getSelectedCell
    34. getSort
    35. getXMLACatalogs
    36. getXMLACubes
    37. getXMLADataSources
    38. getXMLAProviderName
    39. load
    40. off
    41. on
    42. open
    43. openFieldsList
    44. print
    45. refresh
    46. removeAllCalculatedMeasures
    47. removeAllConditions
    48. removeCalculatedMeasure
    49. removeCondition
    50. removeSelection
    51. runQuery
    52. save
    53. setBottomX
    54. setFilter
    55. setFormat
    56. setOptions
    57. setReport
    58. setSort
    59. setTopX
    60. showCharts
    61. showGrid
    62. showGridAndCharts
    63. sortingMethod
    64. sortValues
    65. updateData
  4. Events
    1. All events
    2. aftergriddraw
    3. beforegriddraw
    4. beforetoolbarcreated
    5. cellclick
    6. celldoubleclick
    7. datachanged
    8. dataerror
    9. datafilecancelled
    10. dataloaded
    11. exportcomplete
    12. exportstart
    13. fieldslistclose
    14. fieldslistopen
    15. filteropen
    16. loadingdata
    17. loadinglocalization
    18. loadingolapstructure
    19. loadingreportfile
    20. localizationerror
    21. localizationloaded
    22. olapstructureerror
    23. olapstructureloaded
    24. openingreportfile
    25. printcomplete
    26. printstart
    27. querycomplete
    28. queryerror
    29. ready
    30. reportchange
    31. reportcomplete
    32. reportfilecancelled
    33. reportfileerror
    34. runningquery
    35. update
Table of contents

getColumns

getColumns():Array

[starting from version: 1.4]

Returns a list of hierarchies selected in the report slice for columns.

Returns

Array of objects. Each object in array contains the following properties:

  • caption – String. Hierarchy caption.
  • uniqueName – String. Unique hierarchy name.
  • sort – String. Sorting type ("asc" or "desc").
  • type – String. Hierarchy type. The following types are supported: "string", "number", "date", "date string", "year/month/day", "year/quarter/month/day", "datetime", "time", "level".

If data load is in progress an empty array is returned.

Example

flexmonster.getColumns();

/* method returns array of objects
[
{caption: "Business Type", uniqueName: "Business Type", sort: "desc", type: "string"},
{caption: "Category", uniqueName: "Category", sort: "asc", type: "string"}
]
*/

Check out on JSFiddle.

See also

getAllHierarchies
getRows
getReportFilters
getAllMeasures
getMeasures