fetchDistinctRecords method

Implementation

Future<Map<String,dynamic>> fetchDistinctRecords({String condition="",String distinctField="",String fetchMode="LIST",String limitCondition=""}) async{
    Map<String,dynamic> result={"status":"failure","message":"nothing executed","operation":"SELECT"};
    try{
        if(distinctField!=""){
            String query="SELECT DISTINCT $distinctField FROM "+getSelectQuery();
            if(condition!=""){
                query+=" WHERE "+condition;
            }
            if(limitCondition!=""){
                query+=" "+limitCondition;
            }
            Map<String,dynamic >response=await dbHandler!.fetchQueryRecords(query: query,fetchMode: fetchMode,formatColumns: getFieldFormats());
            if(response.getString("status").equalsIgnoreCase("success")){
                result["status"]="success";
                result["message"]="record(s) fetched successfully";
                result["records"]=response["records"];
            }
            else{
                result["message"]=response["message"];
            }
        }
        else{
            result["message"]="not specified distinct field";
        }
    }
    catch(ex,stack){
        result["message"]=Simplify.getExceptionMessage(ex,stack: stack);
    }
    return result;
}