FrameAppWS

<back to all web services

EjecutaQueryRQ

Requires Authentication
The following routes are available for this service:
All Verbs/Utilidades/Consultas/Listados/Ejecucion
import java.math.*;
import java.util.*;
import net.servicestack.client.*;

public class dtos
{

    public static class EjecutaQueryRQ
    {
        public Integer IDVista = null;
        public Boolean DatosDetalles = null;
        public HashMap<String,Object> Parametros = null;
        public Lenguajes Lenguaje = null;
        public Integer RecordSkip = null;
        public Integer RecordTake = null;
        public ArrayList<Object> Filter = null;
        public gridSortOptions Sort = null;
        public gridGroupOptions Group = null;
        public ArrayList<gridSummaryOptions> SummaryGroupItems = null;
        public ArrayList<gridSummaryOptions> SummaryTotalItems = null;
        public Boolean omitirPaginacion = null;
        public Boolean multiEmpresaSel = null;
        
        public Integer getIdVista() { return IDVista; }
        public EjecutaQueryRQ setIdVista(Integer value) { this.IDVista = value; return this; }
        public Boolean isDatosDetalles() { return DatosDetalles; }
        public EjecutaQueryRQ setDatosDetalles(Boolean value) { this.DatosDetalles = value; return this; }
        public HashMap<String,Object> getParametros() { return Parametros; }
        public EjecutaQueryRQ setParametros(HashMap<String,Object> value) { this.Parametros = value; return this; }
        public Lenguajes getLenguaje() { return Lenguaje; }
        public EjecutaQueryRQ setLenguaje(Lenguajes value) { this.Lenguaje = value; return this; }
        public Integer getRecordSkip() { return RecordSkip; }
        public EjecutaQueryRQ setRecordSkip(Integer value) { this.RecordSkip = value; return this; }
        public Integer getRecordTake() { return RecordTake; }
        public EjecutaQueryRQ setRecordTake(Integer value) { this.RecordTake = value; return this; }
        public ArrayList<Object> getFilter() { return Filter; }
        public EjecutaQueryRQ setFilter(ArrayList<Object> value) { this.Filter = value; return this; }
        public gridSortOptions getSort() { return Sort; }
        public EjecutaQueryRQ setSort(gridSortOptions value) { this.Sort = value; return this; }
        public gridGroupOptions getGroup() { return Group; }
        public EjecutaQueryRQ setGroup(gridGroupOptions value) { this.Group = value; return this; }
        public ArrayList<gridSummaryOptions> getSummaryGroupItems() { return SummaryGroupItems; }
        public EjecutaQueryRQ setSummaryGroupItems(ArrayList<gridSummaryOptions> value) { this.SummaryGroupItems = value; return this; }
        public ArrayList<gridSummaryOptions> getSummaryTotalItems() { return SummaryTotalItems; }
        public EjecutaQueryRQ setSummaryTotalItems(ArrayList<gridSummaryOptions> value) { this.SummaryTotalItems = value; return this; }
        public Boolean isOmitirPaginacion() { return omitirPaginacion; }
        public EjecutaQueryRQ setOmitirPaginacion(Boolean value) { this.omitirPaginacion = value; return this; }
        public Boolean isMultiEmpresaSel() { return multiEmpresaSel; }
        public EjecutaQueryRQ setMultiEmpresaSel(Boolean value) { this.multiEmpresaSel = value; return this; }
    }

    public static enum Lenguajes
    {
        Es,
        Pt,
        En;
    }

    public static class gridSortOptions
    {
        public String selector = null;
        public Boolean desc = null;
        
        public String getSelector() { return selector; }
        public gridSortOptions setSelector(String value) { this.selector = value; return this; }
        public Boolean isDesc() { return desc; }
        public gridSortOptions setDesc(Boolean value) { this.desc = value; return this; }
    }

    public static class gridGroupOptions
    {
        public String selector = null;
        public Boolean desc = null;
        public Boolean isExpanded = null;
        
        public String getSelector() { return selector; }
        public gridGroupOptions setSelector(String value) { this.selector = value; return this; }
        public Boolean isDesc() { return desc; }
        public gridGroupOptions setDesc(Boolean value) { this.desc = value; return this; }
        public Boolean getIsExpanded() { return isExpanded; }
        public gridGroupOptions setIsExpanded(Boolean value) { this.isExpanded = value; return this; }
    }

    public static class gridSummaryOptions
    {
        public String selector = null;
        public String summaryType = null;
        
        public String getSelector() { return selector; }
        public gridSummaryOptions setSelector(String value) { this.selector = value; return this; }
        public String getSummaryType() { return summaryType; }
        public gridSummaryOptions setSummaryType(String value) { this.summaryType = value; return this; }
    }

    public static class EjecutaQueryRS
    {
        public ArrayList<HashMap<String,Object>> DatosConsulta = null;
        public Integer TotalRegistros = null;
        public Integer TotalGrupos = null;
        public ArrayList<Object> SummaryList = null;
        
        public ArrayList<HashMap<String,Object>> getDatosConsulta() { return DatosConsulta; }
        public EjecutaQueryRS setDatosConsulta(ArrayList<HashMap<String,Object>> value) { this.DatosConsulta = value; return this; }
        public Integer getTotalRegistros() { return TotalRegistros; }
        public EjecutaQueryRS setTotalRegistros(Integer value) { this.TotalRegistros = value; return this; }
        public Integer getTotalGrupos() { return TotalGrupos; }
        public EjecutaQueryRS setTotalGrupos(Integer value) { this.TotalGrupos = value; return this; }
        public ArrayList<Object> getSummaryList() { return SummaryList; }
        public EjecutaQueryRS setSummaryList(ArrayList<Object> value) { this.SummaryList = value; return this; }
    }

}

Java EjecutaQueryRQ DTOs

To override the Content-type in your clients, use the HTTP Accept Header, append the .json suffix or ?format=json

To embed the response in a jsonp callback, append ?callback=myCallback

HTTP + JSON

The following are sample HTTP requests and responses. The placeholders shown need to be replaced with actual values.

POST /Utilidades/Consultas/Listados/Ejecucion HTTP/1.1 
Host: soluser-recaudo.sgsas.co 
Accept: application/json
Content-Type: application/json
Content-Length: length

{"IDVista":0,"DatosDetalles":false,"Parametros":{"String":{}},"Lenguaje":"ES","RecordSkip":0,"RecordTake":0,"Filter":[{}],"Sort":{"selector":"String","desc":false},"Group":{"selector":"String","desc":false,"isExpanded":false},"SummaryGroupItems":[{"selector":"String","summaryType":"String"}],"SummaryTotalItems":[{"selector":"String","summaryType":"String"}],"omitirPaginacion":false,"multiEmpresaSel":false}
HTTP/1.1 200 OK
Content-Type: application/json
Content-Length: length

{"DatosConsulta":[{"String":{}}],"TotalRegistros":0,"TotalGrupos":0,"SummaryList":[{}]}