2 Replies Latest reply on Oct 2, 2014 7:55 AM by justiny RSS
    justiny Explorer

    Database Service Filtering and populating a datatable from a Database Service

    I have created a basic Database service and I am returning the data (Select lot_no, item_id from table1). The data is getting populated in a grid in the mashup. Now I would like to use the data filter widget to filter the data that is returned from the service.  For instance where item_id starts with C.  It doesn't appear to filter the data after it has been returned (do I have to have a where clause on the original data that is returned, can't it filter the infotable/datatable after the full dataset has been returned? 

     

    Next question would be what is the best way to populate a datatable from a database service (for instance data the example above). 

     


     

    Thanks.