{"id":15382,"date":"2020-03-31T08:28:54","date_gmt":"2020-03-31T15:28:54","guid":{"rendered":"http:\/\/clartechsolutions.com\/?p=15382"},"modified":"2023-03-01T18:20:00","modified_gmt":"2023-03-01T18:20:00","slug":"elemento-de-tipo-numerico-que-depende-de-un-elemento-de-tipo-lista-de-seleccion","status":"publish","type":"post","link":"https:\/\/kiusi.com\/en\/elemento-de-tipo-numerico-que-depende-de-un-elemento-de-tipo-lista-de-seleccion\/","title":{"rendered":"Elemento de tipo num\u00e9rico que depende de un elemento de tipo lista de selecci\u00f3n"},"content":{"rendered":"<p>En \u00e9sta ocasi\u00f3n voy a contestar una duda que me lleg\u00f3, el cual necesitaban saber c\u00f3mo obtener el valor de un elemento de tipo num\u00e9rico que dependa del valor seleccionado desde una lista de selecci\u00f3n.<\/p>\n<p>Para contestar esto he creado una p\u00e1gina en blanco y una regi\u00f3n de contenido est\u00e1tico con dos elementos, uno de ellos de tipo campo num\u00e9rico y el otro de tipo lista de selecci\u00f3n.<\/p>\n<p><img data-recalc-dims=\"1\" fetchpriority=\"high\" decoding=\"async\" data-attachment-id=\"16383\" data-permalink=\"https:\/\/kiusi.com\/en\/elemento-de-tipo-numerico-que-depende-de-un-elemento-de-tipo-lista-de-seleccion\/img1-1-4\/\" data-orig-file=\"https:\/\/i0.wp.com\/kiusi.com\/wp-content\/uploads\/2020\/03\/img1-1.jpg?fit=666%2C340&amp;ssl=1\" data-orig-size=\"666,340\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;Clarisa Maman Orfali&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;1590741504&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"img1-1\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/kiusi.com\/wp-content\/uploads\/2020\/03\/img1-1.jpg?fit=666%2C340&amp;ssl=1\" class=\"alignnone wp-image-16383 size-full\" src=\"https:\/\/i0.wp.com\/kiusi.com\/wp-content\/uploads\/2020\/03\/img1-1.jpg?resize=666%2C340&#038;ssl=1\" alt=\"\" width=\"666\" height=\"340\" srcset=\"https:\/\/i0.wp.com\/kiusi.com\/wp-content\/uploads\/2020\/03\/img1-1.jpg?w=666&amp;ssl=1 666w, https:\/\/i0.wp.com\/kiusi.com\/wp-content\/uploads\/2020\/03\/img1-1.jpg?resize=300%2C153&amp;ssl=1 300w, https:\/\/i0.wp.com\/kiusi.com\/wp-content\/uploads\/2020\/03\/img1-1.jpg?resize=18%2C9&amp;ssl=1 18w\" sizes=\"(max-width: 666px) 100vw, 666px\" \/><\/p>\n<p>Para el primer elemento de tipo <strong>Lista de Selecci\u00f3n<\/strong>, configuramos:<\/p>\n<p>Secci\u00f3n Apariencia:<\/p>\n<ul>\n<li>Nombre: PX_EMPLEADO<\/li>\n<li>Tipo: Lista de Selecci\u00f3n<\/li>\n<\/ul>\n<p>Secci\u00f3n Etiqueta:<\/p>\n<ul>\n<li>Etiqueta: Empleado<\/li>\n<\/ul>\n<p>Secci\u00f3n Configuraci\u00f3n:<\/p>\n<ul>\n<li>Acci\u00f3n de P\u00e1gina al Seleccionar: Submit Page<\/li>\n<\/ul>\n<p>Secci\u00f3n Lista de Valores<\/p>\n<ul>\n<li>Tipo: Consulta SQL<\/li>\n<li>Consulta SQL: select ename, empno from emp order by 1<\/li>\n<\/ul>\n<p>Para el segundo elemento de <strong>Campo Num\u00e9rico<\/strong>, configuramos:<\/p>\n<p>Secci\u00f3n Apariencia:<\/p>\n<ul>\n<li>Nombre: PX_SALARIO<\/li>\n<li>Tipo: Campo Num\u00e9rico<\/li>\n<\/ul>\n<p>Secci\u00f3n Etiqueta:<\/p>\n<ul>\n<li>Etiqueta: Salario<\/li>\n<\/ul>\n<p>Secci\u00f3n Origen<\/p>\n<ul>\n<li>Tipo: Consulta SQL (devuelve valor \u00fanico)<\/li>\n<li>Consulta SQL: select sal from emp where empno = :PX_EMPLEADO<\/li>\n<li>Usado: Siempre, sustituyendo cualquier valor existente en el estado de sesi\u00f3n<\/li>\n<\/ul>\n<p>Ejecutamos la aplicaci\u00f3n y vemos que cuando cambiamos la selecci\u00f3n del primer elemento se muestra el salario en el campo num\u00e9rico.<\/p>\n<p>Ahora bien, como podemos ver cada vez que se selecciona un nuevo elemento de la lista toda la p\u00e1gina se recarga la p\u00e1gina y si tenemos innumerables elementos y regiones eso puede hacer que la aplicaci\u00f3n decaiga en performance.<\/p>\n<p>Para evitar que se recargue toda la p\u00e1gina podemos usar Acciones Din\u00e1micas para que cuando cambie el elemento seleccionado de la lista solo se refresque la regi\u00f3n est\u00e1tica contenedora de los dos elementos de p\u00e1gina.<\/p>\n<p>Desde el Dise\u00f1ador de P\u00e1ginas de la p\u00e1gina que contiene nuestros elementos de p\u00e1gina, hacemos clic en el elemento PX_SALARIO y en la secci\u00f3n Origen, configuramos que el tipo sea Nulo.<\/p>\n<p>Luego, hacemos clic sobre el Elemento PX_EMPLEADO con el bot\u00f3n derecho del mouse y seleccionamos Crear Acci\u00f3n Din\u00e1mica.<\/p>\n<ul>\n<li>Secci\u00f3n Identificaci\u00f3n\n<ul>\n<li>Nombre: Mostrar Salario<\/li>\n<\/ul>\n<\/li>\n<li>Secci\u00f3n Cuando\n<ul>\n<li>Evento: Cambiar<\/li>\n<li>Tipo de Selecci\u00f3n: Elementos<\/li>\n<li>Elementos: PX_EMPLEADO<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p>Hacemos clic en la acci\u00f3n Verdadera \u201cMostrar\u201d y configuramos:<\/p>\n<ul>\n<li>Secci\u00f3n Identificaci\u00f3n\n<ul>\n<li>Acci\u00f3n: Definir Valor<\/li>\n<\/ul>\n<\/li>\n<li>Secci\u00f3n Configuraci\u00f3n\n<ul>\n<li>Definir Tipo: SQL Statement<\/li>\n<li>Sentencia SQL: select sal from emp where empno = :PX_EMPLEADO<\/li>\n<li>Elementos de P\u00e1gina a Ejecutar: :PX_EMPLEADO<\/li>\n<li>Caracteres Especiales de Identificaci\u00f3n: Si<\/li>\n<li>Suprimir Evento de Cambio: No<\/li>\n<\/ul>\n<\/li>\n<li>Secci\u00f3n Elementos Afectados\n<ul>\n<li>Tipo de Selecci\u00f3n : Elementos<\/li>\n<li>Elementos: PX:SALARIO<\/li>\n<\/ul>\n<\/li>\n<li>Opciones de Ejecuci\u00f3n:\n<ul>\n<li>Evento: Mostrar Salario<\/li>\n<li>Arrancar Cuando el Resultado de Evento Sea: Verdadero<\/li>\n<li>Disparar al Inicializar: Verdadero<\/li>\n<\/ul>\n<\/li>\n<li>Guardamos los cambios<\/li>\n<\/ul>\n<p><img data-recalc-dims=\"1\" decoding=\"async\" data-attachment-id=\"16384\" data-permalink=\"https:\/\/kiusi.com\/en\/elemento-de-tipo-numerico-que-depende-de-un-elemento-de-tipo-lista-de-seleccion\/img2-1-8\/\" data-orig-file=\"https:\/\/i0.wp.com\/kiusi.com\/wp-content\/uploads\/2020\/03\/img2-1.jpg?fit=1904%2C814&amp;ssl=1\" data-orig-size=\"1904,814\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"img2-1\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/kiusi.com\/wp-content\/uploads\/2020\/03\/img2-1.jpg?fit=750%2C321&amp;ssl=1\" class=\"alignnone wp-image-16384 size-full\" src=\"https:\/\/i0.wp.com\/kiusi.com\/wp-content\/uploads\/2020\/03\/img2-1.jpg?resize=750%2C321&#038;ssl=1\" alt=\"\" width=\"750\" height=\"321\" srcset=\"https:\/\/i0.wp.com\/kiusi.com\/wp-content\/uploads\/2020\/03\/img2-1.jpg?w=1904&amp;ssl=1 1904w, https:\/\/i0.wp.com\/kiusi.com\/wp-content\/uploads\/2020\/03\/img2-1.jpg?resize=300%2C128&amp;ssl=1 300w, https:\/\/i0.wp.com\/kiusi.com\/wp-content\/uploads\/2020\/03\/img2-1.jpg?resize=1024%2C438&amp;ssl=1 1024w, https:\/\/i0.wp.com\/kiusi.com\/wp-content\/uploads\/2020\/03\/img2-1.jpg?resize=768%2C328&amp;ssl=1 768w, https:\/\/i0.wp.com\/kiusi.com\/wp-content\/uploads\/2020\/03\/img2-1.jpg?resize=1536%2C657&amp;ssl=1 1536w, https:\/\/i0.wp.com\/kiusi.com\/wp-content\/uploads\/2020\/03\/img2-1.jpg?resize=18%2C8&amp;ssl=1 18w, https:\/\/i0.wp.com\/kiusi.com\/wp-content\/uploads\/2020\/03\/img2-1.jpg?resize=1200%2C513&amp;ssl=1 1200w, https:\/\/i0.wp.com\/kiusi.com\/wp-content\/uploads\/2020\/03\/img2-1.jpg?resize=1568%2C670&amp;ssl=1 1568w\" sizes=\"(max-width: 750px) 100vw, 750px\" \/><\/p>\n<p>Seleccionamos el elemento PX_EMPLEADO y en la secci\u00f3n de configuraci\u00f3n configuramos la opci\u00f3n Acci\u00f3n de P\u00e1gina al Seleccionar = None.<\/p>\n<p>De ese modo s\u00f3lo se refresca la regi\u00f3n cuando se cambia la selecci\u00f3n en la lista, no afectando las dem\u00e1s regiones y elementos que tiene nuestra p\u00e1gina.<\/p>\n<p><img data-recalc-dims=\"1\" decoding=\"async\" data-attachment-id=\"16386\" data-permalink=\"https:\/\/kiusi.com\/en\/elemento-de-tipo-numerico-que-depende-de-un-elemento-de-tipo-lista-de-seleccion\/img3-11\/\" data-orig-file=\"https:\/\/i0.wp.com\/kiusi.com\/wp-content\/uploads\/2020\/03\/img3.jpg?fit=652%2C269&amp;ssl=1\" data-orig-size=\"652,269\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;Clarisa Maman Orfali&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;1590742717&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"img3\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/kiusi.com\/wp-content\/uploads\/2020\/03\/img3.jpg?fit=652%2C269&amp;ssl=1\" class=\"alignnone wp-image-16386 size-full\" src=\"https:\/\/i0.wp.com\/kiusi.com\/wp-content\/uploads\/2020\/03\/img3.jpg?resize=652%2C269&#038;ssl=1\" alt=\"\" width=\"652\" height=\"269\" srcset=\"https:\/\/i0.wp.com\/kiusi.com\/wp-content\/uploads\/2020\/03\/img3.jpg?w=652&amp;ssl=1 652w, https:\/\/i0.wp.com\/kiusi.com\/wp-content\/uploads\/2020\/03\/img3.jpg?resize=300%2C124&amp;ssl=1 300w, https:\/\/i0.wp.com\/kiusi.com\/wp-content\/uploads\/2020\/03\/img3.jpg?resize=18%2C7&amp;ssl=1 18w\" sizes=\"(max-width: 652px) 100vw, 652px\" \/><\/p>\n<p>Hasta pronto!<\/p>","protected":false},"excerpt":{"rendered":"<p>En \u00e9sta ocasi\u00f3n voy a contestar una duda que me lleg\u00f3, el cual necesitaban saber c\u00f3mo obtener el valor de un elemento de tipo num\u00e9rico que dependa del valor seleccionado desde una lista de selecci\u00f3n. Para contestar esto he creado una p\u00e1gina en blanco y una regi\u00f3n de contenido est\u00e1tico con dos elementos, uno de<a class=\"more-link\" href=\"https:\/\/kiusi.com\/en\/elemento-de-tipo-numerico-que-depende-de-un-elemento-de-tipo-lista-de-seleccion\/\">Continue reading <span class=\"screen-reader-text\">&#8220;Elemento de tipo num\u00e9rico que depende de un elemento de tipo lista de selecci\u00f3n&#8221;<\/span><\/a><\/p>","protected":false},"author":132749711,"featured_media":16533,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_coblocks_attr":"","_coblocks_dimensions":"","_coblocks_responsive_height":"","_coblocks_accordion_ie_support":"","advanced_seo_description":"","jetpack_seo_html_title":"","jetpack_seo_noindex":false,"jetpack_seo_schema_type":"","_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_wpcom_ai_launchpad_first_post":false,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"{title}\n\n{excerpt}\n\n{url}","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"_wpas_customize_per_network":false,"jetpack_post_was_ever_published":true},"categories":[121913,122053],"tags":[122058,121903,122059,122060,121904],"class_list":["post-15382","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-blog","category-oracle-apex-20-1","tag-acciones-dinamicas","tag-apex","tag-campo-numerico","tag-lista-de-seleccion","tag-oracle-apex","entry"],"jetpack_publicize_connections":[],"jetpack_likes_enabled":true,"jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/paMvMS-406","amp_enabled":true,"jetpack_featured_media_url":"https:\/\/i0.wp.com\/kiusi.com\/wp-content\/uploads\/2020\/03\/Destacada-Elemento-de-tipo-numerico-que-depende-de-un-elemento-de-tipo-lista-de-seleccion.jpg?fit=2949%2C1735&ssl=1","_links":{"self":[{"href":"https:\/\/kiusi.com\/en\/wp-json\/wp\/v2\/posts\/15382","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/kiusi.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kiusi.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kiusi.com\/en\/wp-json\/wp\/v2\/users\/132749711"}],"replies":[{"embeddable":true,"href":"https:\/\/kiusi.com\/en\/wp-json\/wp\/v2\/comments?post=15382"}],"version-history":[{"count":3,"href":"https:\/\/kiusi.com\/en\/wp-json\/wp\/v2\/posts\/15382\/revisions"}],"predecessor-version":[{"id":16534,"href":"https:\/\/kiusi.com\/en\/wp-json\/wp\/v2\/posts\/15382\/revisions\/16534"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/kiusi.com\/en\/wp-json\/wp\/v2\/media\/16533"}],"wp:attachment":[{"href":"https:\/\/kiusi.com\/en\/wp-json\/wp\/v2\/media?parent=15382"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kiusi.com\/en\/wp-json\/wp\/v2\/categories?post=15382"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kiusi.com\/en\/wp-json\/wp\/v2\/tags?post=15382"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}