readDataset()

This object provides read access to data from DataSet

List<Row> readDataset(Integer id)

Returns list of rows from dataset id

List<Row> readDataset(Integer id, int limit)

Returns list of rows from dataset id , where count of value is limit

List<Row> readDataset(Integer id, int limit, Filter filter)

Returns list of rows from dataset id , where count of value is limit, filtered by filter

List<Row> readDataset(Integer id, int limit, Filter filter, Sort sort)

Returns list of rows from dataset id , where count of value is limit, filtered by filter, sorted by belladatiSortObject

e.g. def rows = readDataset(123, 1, filter, com.belladati.common.sort.Sort.descending('row_uid'))

List<Row> readDataset(String datasetCode)

Returns list of rows from dataset code

List<Row> readDataset(String datasetCode, int limit)

Returns list of rows from dataset code, where count of value is limit

List<Row> readDataset(String datasetCode, int limit, Filter filter)

Returns list of rows from dataset code, where count of value is limit, filtered by filter

List<Row> readDataset(String datasetCode, int limit, Filter filter, Sort sort)

Returns list of rows from dataset idcode, where count of value is limit, filtered by filter, sorted by belladatiSortObject

e.g. def rows = readDataset(123, 1, filter, com.belladati.common.sort.Sort.descending('row_uid'))

Void readDataset(Integer id, Closure<Object> closure)

You can pass Closure to readDataset

 readDataset(123,  filter) {
// defined variables for closure are row, index, columns
row.getValues()['L_NAME']

}

Void readDataset(Integer id, int limit, Closure<Object> closure)

You can pass Closure to readDataset

readDataset(123, -1) {row.getValues()['L_NAME']}

Void readDataset(Integer id, int limit, Filter filter, Closure<Object> closure)

You can pass Closure to readDataset

readDataset(123, -1, filter) {row.getValues()['L_NAME']}

Void readDataset(Integer id, int limit, Filter filter, Sort sort, Closure<Object> closure)

You can pass Closure to readDataset

readDataset(123, -1, filter,ascSort('L_ATT')) {row.getValues()['L_NAME']}

Sort()

This object returns sort ordering

Sort ascSort(final String column)
Returns ascending sorting according to column
Sort descSort(final String column)
Returns descending sorting according to column

Row()

This function returns value of column from row

String row.getValues()[String column]
getValues function returns value of a row from selected column

storeDataset()

This object provide write and update access to DataSet

void storeDataset(Integer datasetId, List<Map<String, Object>> rows)

Stores List of Maps that contains <columnCode,value> into dataset datasetId

[['L_ID':'A','M_VAL':5],['L_ID':'B','M_VAL':9]]
void storeDataset(String datasetCode, List<Map<String, Object>> rows)

Stores List of Maps that contains <columnCode,value> into dataset datasetId

[['L_ID':'A','M_VAL':5],['L_ID':'B','M_VAL':9]]

createUser()

This object provide possibility to create new user.

Response createUser(JSONObject data)

Creates new user from  JSONObject user and returns its id

downloadFile()

This object provide possibility to create new user.

Response downloadFile(Integer id)

Returns file from mediaGalery when id is provided

Response downloadFile(Integer id, String desiredFileName)Returns renamed file from mediaGalery according to desiredFileName when id is provided


other functions

public static Object executeMlProjectWithResult(Integer projectId, Map<String, Object> variables)

Executes ML project and waits for it returns value

  • No labels