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 .xml suffix or ?format=xml

HTTP + XML

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/xml
Content-Type: application/xml
Content-Length: length

<EjecutaQueryRQ xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/Administrador.Modelo.Tipos">
  <DatosDetalles>false</DatosDetalles>
  <Filter xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:anyType />
  </Filter>
  <Group xmlns:d2p1="http://schemas.datacontract.org/2004/07/Administrador.Modelo.DevExtreme">
    <d2p1:desc>false</d2p1:desc>
    <d2p1:isExpanded>false</d2p1:isExpanded>
    <d2p1:selector>String</d2p1:selector>
  </Group>
  <IDVista>0</IDVista>
  <Lenguaje>ES</Lenguaje>
  <Parametros xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:KeyValueOfstringanyType>
      <d2p1:Key>String</d2p1:Key>
      <d2p1:Value />
    </d2p1:KeyValueOfstringanyType>
  </Parametros>
  <RecordSkip>0</RecordSkip>
  <RecordTake>0</RecordTake>
  <Sort xmlns:d2p1="http://schemas.datacontract.org/2004/07/Administrador.Modelo.DevExtreme">
    <d2p1:desc>false</d2p1:desc>
    <d2p1:selector>String</d2p1:selector>
  </Sort>
  <SummaryGroupItems xmlns:d2p1="http://schemas.datacontract.org/2004/07/Administrador.Modelo.DevExtreme">
    <d2p1:gridSummaryOptions>
      <d2p1:selector>String</d2p1:selector>
      <d2p1:summaryType>String</d2p1:summaryType>
    </d2p1:gridSummaryOptions>
  </SummaryGroupItems>
  <SummaryTotalItems xmlns:d2p1="http://schemas.datacontract.org/2004/07/Administrador.Modelo.DevExtreme">
    <d2p1:gridSummaryOptions>
      <d2p1:selector>String</d2p1:selector>
      <d2p1:summaryType>String</d2p1:summaryType>
    </d2p1:gridSummaryOptions>
  </SummaryTotalItems>
  <multiEmpresaSel>false</multiEmpresaSel>
  <omitirPaginacion>false</omitirPaginacion>
</EjecutaQueryRQ>
HTTP/1.1 200 OK
Content-Type: application/xml
Content-Length: length

<EjecutaQueryRS xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/Administrador.Modelo.Tipos">
  <DatosConsulta xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:ArrayOfKeyValueOfstringanyType>
      <d2p1:KeyValueOfstringanyType>
        <d2p1:Key>String</d2p1:Key>
        <d2p1:Value />
      </d2p1:KeyValueOfstringanyType>
    </d2p1:ArrayOfKeyValueOfstringanyType>
  </DatosConsulta>
  <SummaryList xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:anyType />
  </SummaryList>
  <TotalGrupos>0</TotalGrupos>
  <TotalRegistros>0</TotalRegistros>
</EjecutaQueryRS>