Plantilla:Hylocereus query - Historial de revisiones

Admin: Página creada con «This is the 'Item query' template. It should be called via the Form:Hylocereus (Pitaya) form.

Form:Hylocereus (Pitaya) form. </noinclude><includeonly><div class="form-tag-area"> <p class="…»

Página nueva
<noinclude>This is the 'Item query' template. It should be called via the [[Form:Hylocereus (Pitaya)]] form.
</noinclude><includeonly><div class="form-tag-area">
<p class="form-tag-title">Filtros:</p> {{#if: {{{Socio|}}} |<p class="form-tag">Socio: {{{Socio|}}}</p>|}}{{#if: {{{Coleccion|}}} |<p class="form-tag">Colección: {{{Coleccion|}}}</p>|}}{{#if: {{{Ubicacion|}}} |<p class="form-tag">Ubicación: {{{Ubicacion|}}}</p>|}}{{#if: {{{upov1|}}} |<p class="form-tag">Color rojizo del tallo joven (UPOV 1): {{{upov1|}}}</p>|}}{{#if: {{{upov6|}}} |<p class="form-tag">Distancia entre las aréolas (UPOV 6): {{{upov6|}}}</p>|}}{{#if: {{{upov7|}}} |<p class="form-tag">Altura del arco (UPOV 7): {{{upov7|}}}</p>|}}{{#if: {{{upov8|}}} |<p class="form-tag">Borde de la costilla (UPOV 8): {{{upov8|}}}</p>|}}{{#if: {{{upov19|}}} |<p class="form-tag">Intensidad del color rojo de la bráctea (UPOV 19): {{{upov19|}}}</p>|}}{{#if: {{{upov27|}}} |<p class="form-tag">Longitud (UPOV 27): {{{upov27|}}}</p>|}}{{#if: {{{upov28|}}} |<p class="form-tag">Anchura (UPOV 28): {{{upov28|}}}</p>|}}{{#if: {{{upov29|}}} |<p class="form-tag">Relación longitud/anchura (UPOV 29): {{{upov29|}}}</p>|}}{{#if: {{{upov33|}}} |<p class="form-tag">Color principal de las brácteas medias (UPOV 33): {{{upov33|}}}</p>|}}{{#if: {{{upov35|}}} |<p class="form-tag">Grosor de la piel (UPOV 35): {{{upov35|}}}</p>|}}{{#if: {{{upov36|}}} |<p class="form-tag">Color de la piel (sin las brácteas) (UPOV 36): {{{upov36|}}}</p>|}}{{#if: {{{upov37|}}} |<p class="form-tag">Color de la pulpa (UPOV 37): {{{upov37|}}}</p>|}}{{#if: {{{fechaFhyl01Inicio|}}} |<p class="form-tag">Fecha de inicio de floración (FHYL01) (Inicio): {{{fechaFhyl01Inicio|}}}</p>|}}{{#if: {{{fechaFhyl01Fin|}}} |<p class="form-tag">Fecha de inicio de floración (FHYL01) (Fin): {{{fechaFhyl01Fin|}}}</p>|}}{{#if: {{{fechaFhyl02Inicio|}}} |<p class="form-tag">Fecha fin de floración (FHYL02) (Inicio): {{{fechaFhyl02Inicio|}}}</p>|}}{{#if: {{{fechaFhyl02Fin|}}} |<p class="form-tag">Fecha fin de floración (FHYL02) (Fin): {{{fechaFhyl02Fin|}}}</p>|}}{{#if: {{{fhyl03|}}} |<p class="form-tag">Duración de floración (días) (FHYL03): {{{fhyl03|}}}</p>|}}{{#if: {{{fechaFhyl04Inicio|}}} |<p class="form-tag">Fecha de la 1ª etapa productiva (FHYL04) (Inicio): {{{fechaFhyl04Inicio|}}}</p>|}}{{#if: {{{fechaFhyl04Fin|}}} |<p class="form-tag">Fecha de la 1ª etapa productiva (FHYL04) (Fin): {{{fechaFhyl04Fin|}}}</p>|}}{{#if: {{{fhyl05|}}} |<p class="form-tag">Duración de la 1ª etapa productiva (días) (FHYL05): {{{fhyl05|}}}</p>|}}{{#if: {{{fhyl06|}}} |<p class="form-tag">Peso del fruto en la 1ª etapa productiva (g) (FHYL06): {{{fhyl06|}}}</p>|}}{{#if: {{{fhyl07|}}} |<p class="form-tag">Peso de la pulpa en la 1ª etapa productiva (g) (FHYL07): {{{fhyl07|}}}</p>|}}{{#if: {{{fechaFhyl08Inicio|}}} |<p class="form-tag">Fecha de la 2ª etapa productiva (FHYL08) (Inicio): {{{fechaFhyl08Inicio|}}}</p>|}}{{#if: {{{fechaFhyl08Fin|}}} |<p class="form-tag">Fecha de la 2ª etapa productiva (FHYL08) (Fin): {{{fechaFhyl08Fin|}}}</p>|}}{{#if: {{{fhyl09|}}} |<p class="form-tag">Duración de la 2ª etapa productiva (días) (FHYL09): {{{fhyl09|}}}</p>|}}{{#if: {{{fhyl10|}}} |<p class="form-tag">Peso del fruto en la 2ª etapa productiva (g) (FHYL10): {{{fhyl10|}}}</p>|}}{{#if: {{{fhyl11|}}} |<p class="form-tag">Peso de la pulpa en la 2ª etapa productiva (g) (FHYL11): {{{fhyl11|}}}</p>|}}{{#if: {{{fhyl12|}}} |<p class="form-tag">Ojo de pescado (FHYL12): {{{fhyl12|}}}</p>|}}
</div>

<div class="query-result query-page-version">
{{#cargo_query:table=Pitayas
|fields=enlaceWiki=Nombre, Codigo=Código, Socio=Socio, Coleccion=Colección, Ubicacion=Ubicación
|where={{#if: {{{Socio|}}} | Socio = "{{{Socio|}}}" | (Socio LIKE "%%" OR Socio IS NULL) }}
AND {{#if: {{{Coleccion|}}} | Coleccion = "{{{Coleccion|}}}" | (Coleccion LIKE "%%" OR Coleccion IS NULL) }}
AND {{#if: {{{Ubicacion|}}} | Ubicacion LIKE "%{{{Ubicacion|}}}%" | (Ubicacion LIKE "%%" OR Ubicacion IS NULL) }}
AND {{#if: {{{upov1|}}} | upov1 = "{{{upov1|}}}" | (upov1 LIKE "%%" OR upov1 IS NULL) }}
AND {{#if: {{{upov6|}}} | upov6 = "{{{upov6|}}}" | (upov6 LIKE "%%" OR upov6 IS NULL) }}
AND {{#if: {{{upov7|}}} | upov7 = "{{{upov7|}}}" | (upov7 LIKE "%%" OR upov7 IS NULL) }}
AND {{#if: {{{upov8|}}} | upov8 = "{{{upov8|}}}" | (upov8 LIKE "%%" OR upov8 IS NULL) }}
AND {{#if: {{{upov19|}}} | upov19 = "{{{upov19|}}}" | (upov19 LIKE "%%" OR upov19 IS NULL) }}
AND {{#if: {{{upov27|}}} | upov27 = "{{{upov27|}}}" | (upov27 LIKE "%%" OR upov27 IS NULL) }}
AND {{#if: {{{upov28|}}} | upov28 = "{{{upov28|}}}" | (upov28 LIKE "%%" OR upov28 IS NULL) }}
AND {{#if: {{{upov29|}}} | upov29 = "{{{upov29|}}}" | (upov29 LIKE "%%" OR upov29 IS NULL) }}
AND {{#if: {{{upov33|}}} | upov33 = "{{{upov33|}}}" | (upov33 LIKE "%%" OR upov33 IS NULL) }}
AND {{#if: {{{upov35|}}} | upov35 = "{{{upov35|}}}" | (upov35 LIKE "%%" OR upov35 IS NULL) }}
AND {{#if: {{{upov36|}}} | upov36 = "{{{upov36|}}}" | (upov36 LIKE "%%" OR upov36 IS NULL) }}
AND {{#if: {{{upov37|}}} | upov37 = "{{{upov37|}}}" | (upov37 LIKE "%%" OR upov37 IS NULL) }}
AND {{#if: {{{fechaFhyl01Inicio|}}} | fechaFhyl01 >= "{{{fechaFhyl01Inicio|}}}" {{#if: {{{fechaFhyl01Fin|}}} | AND fechaFhyl01 <= "{{{fechaFhyl01Fin|}}}" | }} | {{#if: {{{fechaFhyl01Fin|}}} | fechaFhyl01 <= "{{{fechaFhyl01Fin|}}}" | (fechaFhyl01 LIKE "%%" OR fechaFhyl01 IS NULL) }}}}
AND {{#if: {{{fechaFhyl02Inicio|}}} | fechaFhyl02 >= "{{{fechaFhyl02Inicio|}}}" {{#if: {{{fechaFhyl02Fin|}}} | AND fechaFhyl02 <= "{{{fechaFhyl02Fin|}}}" | }} | {{#if: {{{fechaFhyl02Fin|}}} | fechaFhyl02 <= "{{{fechaFhyl02Fin|}}}" | (fechaFhyl02 LIKE "%%" OR fechaFhyl02 IS NULL) }}}}
AND {{#if: {{{fhyl03|}}} | fhyl03 = "{{{fhyl03|}}}" | (fhyl03 LIKE "%%" OR fhyl03 IS NULL) }}
AND {{#if: {{{fechaFhyl04Inicio|}}} | fechaFhyl04 >= "{{{fechaFhyl04Inicio|}}}" {{#if: {{{fechaFhyl04Fin|}}} | AND fechaFhyl04 <= "{{{fechaFhyl04Fin|}}}" | }} | {{#if: {{{fechaFhyl04Fin|}}} | fechaFhyl04 <= "{{{fechaFhyl04Fin|}}}" | (fechaFhyl04 LIKE "%%" OR fechaFhyl04 IS NULL) }}}}
AND {{#if: {{{fhyl05|}}} | fhyl05 = "{{{fhyl05|}}}" | (fhyl05 LIKE "%%" OR fhyl05 IS NULL) }}
AND {{#if: {{{fhyl06|}}} | fhyl06 = "{{{fhyl06|}}}" | (fhyl06 LIKE "%%" OR fhyl06 IS NULL) }}
AND {{#if: {{{fhyl07|}}} | fhyl07 = "{{{fhyl07|}}}" | (fhyl07 LIKE "%%" OR fhyl07 IS NULL) }}
AND {{#if: {{{fechaFhyl08Inicio|}}} | fechaFhyl08 >= "{{{fechaFhyl08Inicio|}}}" {{#if: {{{fechaFhyl08Fin|}}} | AND fechaFhyl08 <= "{{{fechaFhyl08Fin|}}}" | }} | {{#if: {{{fechaFhyl08Fin|}}} | fechaFhyl08 <= "{{{fechaFhyl08Fin|}}}" | (fechaFhyl08 LIKE "%%" OR fechaFhyl08 IS NULL) }}}}
AND {{#if: {{{fhyl09|}}} | fhyl09 = "{{{fhyl09|}}}" | (fhyl09 LIKE "%%" OR fhyl09 IS NULL) }}
AND {{#if: {{{fhyl10|}}} | fhyl10 = "{{{fhyl10|}}}" | (fhyl10 LIKE "%%" OR fhyl10 IS NULL) }}
AND {{#if: {{{fhyl11|}}} | fhyl11 = "{{{fhyl11|}}}" | (fhyl11 LIKE "%%" OR fhyl11 IS NULL) }}
AND {{#if: {{{fhyl12|}}} | fhyl12 = "{{{fhyl12|}}}" | (fhyl12 LIKE "%%" OR fhyl12 IS NULL) }}
|format=dynamic table
|named args=yes
}}
</div>
<div class="export-result-button"><span class="mw-ui-button form-button" role="button" aria-disabled="false"">{{#cargo_query:table=Pitayas
|fields=Nombre=NOMBRE, Codigo=CODIGO, Socio=SOCIO, Coleccion=COLECCION, Ubicacion=UBICACION
|where={{#if: {{{Socio|}}} | Socio = "{{{Socio|}}}" | (Socio LIKE "%%" OR Socio IS NULL) }}
AND {{#if: {{{Coleccion|}}} | Coleccion = "{{{Coleccion|}}}" | (Coleccion LIKE "%%" OR Coleccion IS NULL) }}
AND {{#if: {{{Ubicacion|}}} | Ubicacion LIKE "%{{{Ubicacion|}}}%" | (Ubicacion LIKE "%%" OR Ubicacion IS NULL) }}
AND {{#if: {{{upov1|}}} | upov1 = "{{{upov1|}}}" | (upov1 LIKE "%%" OR upov1 IS NULL) }}
AND {{#if: {{{upov6|}}} | upov6 = "{{{upov6|}}}" | (upov6 LIKE "%%" OR upov6 IS NULL) }}
AND {{#if: {{{upov7|}}} | upov7 = "{{{upov7|}}}" | (upov7 LIKE "%%" OR upov7 IS NULL) }}
AND {{#if: {{{upov8|}}} | upov8 = "{{{upov8|}}}" | (upov8 LIKE "%%" OR upov8 IS NULL) }}
AND {{#if: {{{upov19|}}} | upov19 = "{{{upov19|}}}" | (upov19 LIKE "%%" OR upov19 IS NULL) }}
AND {{#if: {{{upov27|}}} | upov27 = "{{{upov27|}}}" | (upov27 LIKE "%%" OR upov27 IS NULL) }}
AND {{#if: {{{upov28|}}} | upov28 = "{{{upov28|}}}" | (upov28 LIKE "%%" OR upov28 IS NULL) }}
AND {{#if: {{{upov29|}}} | upov29 = "{{{upov29|}}}" | (upov29 LIKE "%%" OR upov29 IS NULL) }}
AND {{#if: {{{upov33|}}} | upov33 = "{{{upov33|}}}" | (upov33 LIKE "%%" OR upov33 IS NULL) }}
AND {{#if: {{{upov35|}}} | upov35 = "{{{upov35|}}}" | (upov35 LIKE "%%" OR upov35 IS NULL) }}
AND {{#if: {{{upov36|}}} | upov36 = "{{{upov36|}}}" | (upov36 LIKE "%%" OR upov36 IS NULL) }}
AND {{#if: {{{upov37|}}} | upov37 = "{{{upov37|}}}" | (upov37 LIKE "%%" OR upov37 IS NULL) }}
AND {{#if: {{{fechaFhyl01Inicio|}}} | fechaFhyl01 >= "{{{fechaFhyl01Inicio|}}}" {{#if: {{{fechaFhyl01Fin|}}} | AND fechaFhyl01 <= "{{{fechaFhyl01Fin|}}}" | }} | {{#if: {{{fechaFhyl01Fin|}}} | fechaFhyl01 <= "{{{fechaFhyl01Fin|}}}" | (fechaFhyl01 LIKE "%%" OR fechaFhyl01 IS NULL) }}}}
AND {{#if: {{{fechaFhyl02Inicio|}}} | fechaFhyl02 >= "{{{fechaFhyl02Inicio|}}}" {{#if: {{{fechaFhyl02Fin|}}} | AND fechaFhyl02 <= "{{{fechaFhyl02Fin|}}}" | }} | {{#if: {{{fechaFhyl02Fin|}}} | fechaFhyl02 <= "{{{fechaFhyl02Fin|}}}" | (fechaFhyl02 LIKE "%%" OR fechaFhyl02 IS NULL) }}}}
AND {{#if: {{{fhyl03|}}} | fhyl03 = "{{{fhyl03|}}}" | (fhyl03 LIKE "%%" OR fhyl03 IS NULL) }}
AND {{#if: {{{fechaFhyl04Inicio|}}} | fechaFhyl04 >= "{{{fechaFhyl04Inicio|}}}" {{#if: {{{fechaFhyl04Fin|}}} | AND fechaFhyl04 <= "{{{fechaFhyl04Fin|}}}" | }} | {{#if: {{{fechaFhyl04Fin|}}} | fechaFhyl04 <= "{{{fechaFhyl04Fin|}}}" | (fechaFhyl04 LIKE "%%" OR fechaFhyl04 IS NULL) }}}}
AND {{#if: {{{fhyl05|}}} | fhyl05 = "{{{fhyl05|}}}" | (fhyl05 LIKE "%%" OR fhyl05 IS NULL) }}
AND {{#if: {{{fhyl06|}}} | fhyl06 = "{{{fhyl06|}}}" | (fhyl06 LIKE "%%" OR fhyl06 IS NULL) }}
AND {{#if: {{{fhyl07|}}} | fhyl07 = "{{{fhyl07|}}}" | (fhyl07 LIKE "%%" OR fhyl07 IS NULL) }}
AND {{#if: {{{fechaFhyl08Inicio|}}} | fechaFhyl08 >= "{{{fechaFhyl08Inicio|}}}" {{#if: {{{fechaFhyl08Fin|}}} | AND fechaFhyl08 <= "{{{fechaFhyl08Fin|}}}" | }} | {{#if: {{{fechaFhyl08Fin|}}} | fechaFhyl08 <= "{{{fechaFhyl08Fin|}}}" | (fechaFhyl08 LIKE "%%" OR fechaFhyl08 IS NULL) }}}}
AND {{#if: {{{fhyl09|}}} | fhyl09 = "{{{fhyl09|}}}" | (fhyl09 LIKE "%%" OR fhyl09 IS NULL) }}
AND {{#if: {{{fhyl10|}}} | fhyl10 = "{{{fhyl10|}}}" | (fhyl10 LIKE "%%" OR fhyl10 IS NULL) }}
AND {{#if: {{{fhyl11|}}} | fhyl11 = "{{{fhyl11|}}}" | (fhyl11 LIKE "%%" OR fhyl11 IS NULL) }}
AND {{#if: {{{fhyl12|}}} | fhyl12 = "{{{fhyl12|}}}" | (fhyl12 LIKE "%%" OR fhyl12 IS NULL) }}
|format=csv
|delimiter=;
|named args=yes
|link text=Exportar resultado
}}
</span>
</div>
<div class="query-result query-print-version">
{{#cargo_query:table=Pitayas
|fields=enlaceWiki=Nombre, Codigo=Código, Socio=Socio, Coleccion=Colección, Ubicacion=Ubicación
|where={{#if: {{{Socio|}}} | Socio = "{{{Socio|}}}" | (Socio LIKE "%%" OR Socio IS NULL) }}
AND {{#if: {{{Coleccion|}}} | Coleccion = "{{{Coleccion|}}}" | (Coleccion LIKE "%%" OR Coleccion IS NULL) }}
AND {{#if: {{{Ubicacion|}}} | Ubicacion LIKE "%{{{Ubicacion|}}}%" | (Ubicacion LIKE "%%" OR Ubicacion IS NULL) }}
AND {{#if: {{{upov1|}}} | upov1 = "{{{upov1|}}}" | (upov1 LIKE "%%" OR upov1 IS NULL) }}
AND {{#if: {{{upov6|}}} | upov6 = "{{{upov6|}}}" | (upov6 LIKE "%%" OR upov6 IS NULL) }}
AND {{#if: {{{upov7|}}} | upov7 = "{{{upov7|}}}" | (upov7 LIKE "%%" OR upov7 IS NULL) }}
AND {{#if: {{{upov8|}}} | upov8 = "{{{upov8|}}}" | (upov8 LIKE "%%" OR upov8 IS NULL) }}
AND {{#if: {{{upov19|}}} | upov19 = "{{{upov19|}}}" | (upov19 LIKE "%%" OR upov19 IS NULL) }}
AND {{#if: {{{upov27|}}} | upov27 = "{{{upov27|}}}" | (upov27 LIKE "%%" OR upov27 IS NULL) }}
AND {{#if: {{{upov28|}}} | upov28 = "{{{upov28|}}}" | (upov28 LIKE "%%" OR upov28 IS NULL) }}
AND {{#if: {{{upov29|}}} | upov29 = "{{{upov29|}}}" | (upov29 LIKE "%%" OR upov29 IS NULL) }}
AND {{#if: {{{upov33|}}} | upov33 = "{{{upov33|}}}" | (upov33 LIKE "%%" OR upov33 IS NULL) }}
AND {{#if: {{{upov35|}}} | upov35 = "{{{upov35|}}}" | (upov35 LIKE "%%" OR upov35 IS NULL) }}
AND {{#if: {{{upov36|}}} | upov36 = "{{{upov36|}}}" | (upov36 LIKE "%%" OR upov36 IS NULL) }}
AND {{#if: {{{upov37|}}} | upov37 = "{{{upov37|}}}" | (upov37 LIKE "%%" OR upov37 IS NULL) }}
AND {{#if: {{{fechaFhyl01Inicio|}}} | fechaFhyl01 >= "{{{fechaFhyl01Inicio|}}}" {{#if: {{{fechaFhyl01Fin|}}} | AND fechaFhyl01 <= "{{{fechaFhyl01Fin|}}}" | }} | {{#if: {{{fechaFhyl01Fin|}}} | fechaFhyl01 <= "{{{fechaFhyl01Fin|}}}" | (fechaFhyl01 LIKE "%%" OR fechaFhyl01 IS NULL) }}}}
AND {{#if: {{{fechaFhyl02Inicio|}}} | fechaFhyl02 >= "{{{fechaFhyl02Inicio|}}}" {{#if: {{{fechaFhyl02Fin|}}} | AND fechaFhyl02 <= "{{{fechaFhyl02Fin|}}}" | }} | {{#if: {{{fechaFhyl02Fin|}}} | fechaFhyl02 <= "{{{fechaFhyl02Fin|}}}" | (fechaFhyl02 LIKE "%%" OR fechaFhyl02 IS NULL) }}}}
AND {{#if: {{{fhyl03|}}} | fhyl03 = "{{{fhyl03|}}}" | (fhyl03 LIKE "%%" OR fhyl03 IS NULL) }}
AND {{#if: {{{fechaFhyl04Inicio|}}} | fechaFhyl04 >= "{{{fechaFhyl04Inicio|}}}" {{#if: {{{fechaFhyl04Fin|}}} | AND fechaFhyl04 <= "{{{fechaFhyl04Fin|}}}" | }} | {{#if: {{{fechaFhyl04Fin|}}} | fechaFhyl04 <= "{{{fechaFhyl04Fin|}}}" | (fechaFhyl04 LIKE "%%" OR fechaFhyl04 IS NULL) }}}}
AND {{#if: {{{fhyl05|}}} | fhyl05 = "{{{fhyl05|}}}" | (fhyl05 LIKE "%%" OR fhyl05 IS NULL) }}
AND {{#if: {{{fhyl06|}}} | fhyl06 = "{{{fhyl06|}}}" | (fhyl06 LIKE "%%" OR fhyl06 IS NULL) }}
AND {{#if: {{{fhyl07|}}} | fhyl07 = "{{{fhyl07|}}}" | (fhyl07 LIKE "%%" OR fhyl07 IS NULL) }}
AND {{#if: {{{fechaFhyl08Inicio|}}} | fechaFhyl08 >= "{{{fechaFhyl08Inicio|}}}" {{#if: {{{fechaFhyl08Fin|}}} | AND fechaFhyl08 <= "{{{fechaFhyl08Fin|}}}" | }} | {{#if: {{{fechaFhyl08Fin|}}} | fechaFhyl08 <= "{{{fechaFhyl08Fin|}}}" | (fechaFhyl08 LIKE "%%" OR fechaFhyl08 IS NULL) }}}}
AND {{#if: {{{fhyl09|}}} | fhyl09 = "{{{fhyl09|}}}" | (fhyl09 LIKE "%%" OR fhyl09 IS NULL) }}
AND {{#if: {{{fhyl10|}}} | fhyl10 = "{{{fhyl10|}}}" | (fhyl10 LIKE "%%" OR fhyl10 IS NULL) }}
AND {{#if: {{{fhyl11|}}} | fhyl11 = "{{{fhyl11|}}}" | (fhyl11 LIKE "%%" OR fhyl11 IS NULL) }}
AND {{#if: {{{fhyl12|}}} | fhyl12 = "{{{fhyl12|}}}" | (fhyl12 LIKE "%%" OR fhyl12 IS NULL) }}
|format=table
|named args=yes
}}
</div>

[[File:Logo.jpg|class=logo]]
</includeonly>