Menu
Download Free Trial
  1. API reference
    1. Flexmonster
  2. Objects
    1. Report Object
    2. Slice Object
    3. Options Object
    4. Format Object
    5. Conditional Format Object
    6. Cell Data Object
  3. Methods
    1. addCalculatedMeasure
    2. addCondition
    3. addJSON
    4. clear
    5. clearFilter
    6. clearXMLACache
    7. closeFieldsList
    8. collapseAllData
    9. collapseData
    10. connectTo
    11. customizeCell
    12. dispose
    13. expandAllData
    14. expandData
    15. exportTo
    16. fullScreen
    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. sortValues
    64. updateData
  4. Events
    1. aftergriddraw
    2. beforegriddraw
    3. beforetoolbarcreated
    4. cellclick
    5. celldoubleclick
    6. datachanged
    7. dataerror
    8. datafilecancelled
    9. dataloaded
    10. exportcomplete
    11. exportstart
    12. fieldslistclose
    13. fieldslistopen
    14. filteropen
    15. loadingdata
    16. loadinglocalization
    17. loadingolapstructure
    18. loadingreportfile
    19. localizationerror
    20. localizationloaded
    21. olapstructureerror
    22. olapstructureloaded
    23. openingreportfile
    24. printcomplete
    25. printstart
    26. querycomplete
    27. queryerror
    28. ready
    29. reportchange
    30. reportcomplete
    31. reportfilecancelled
    32. reportfileerror
    33. runningquery
    34. 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 parameters: caption, uniqueName, and sort.

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"},
{caption: "Category", uniqueName: "Category", sort: "asc"}
]
*/

Check out on JSFiddle.

See also

getAllHierarchies
getRows
getReportFilters
getAllMeasures
getMeasures