IBM webMethods Hybrid Integration

IBM webMethods Hybrid Integration

Join this online group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.


#TechXchangePresenter
 View Only
Expand all | Collapse all

Get ALL rows of a table in table model

  • 1.  Get ALL rows of a table in table model

    Posted Sat February 27, 2016 07:03 PM

    I need to loop over all the rows in a table. For this, I used following code:

    var tableModel = CAF.model('#{caf:cid("asyncTable")}'); 
    var allRowsModel = tableModel .list();

    However, this code gives only 10 rows in the row Model list, corresponding to row numbers of the page (if I am on page 1 then rows 1 to 10 only).

    Is there a setting in table properties by which I can get all the rows from the table model?


    #MWS-CAF-Task-Engine
    #webMethods-BPMS
    #webMethods


  • 2.  RE: Get ALL rows of a table in table model

    Posted Mon February 29, 2016 01:41 PM

    The client-side model is only expected to have a slice of your table rows and user would utilize the paging controls to navigate to other slices of the dataset. This is for performance reasons when operating with very large table models.

    Generally, operations that need to evaluate against all the rows of the table would be better to do in a server-side action handler.


    #MWS-CAF-Task-Engine
    #webMethods
    #webMethods-BPMS