<%@page extends="com.zucchetti.PortalStudio.PortalStudioBase" %><%@ page import="com.zucchetti.SPBridge.*" %><%@ page import="com.zucchetti.PortalStudio.*" %><%@ page import="com.zucchetti.sitepainter.SPPrxycizer" %><% Sitepainter sp=new Sitepainter(request); sp.setContentType(response); if(sp.CanAccessEditor("PortalStudio") || "S".equals(sp.getGlobal("g_PortalSamples","")) || sp.CanModifyOwnQuery()) { boolean rewriteId=false; if(request.getQueryString()!=null && request.getQueryString().indexOf("filename=")==-1) rewriteId=true; boolean simplemode = sp.getParameter("simplemode",false); String item_index = sp.getParameter("for",""); String item_prop = sp.getParameter("prop",""); %> VisualQuery - Sitepainter Infinity Portalstudio "> ',<%=sp.getParameter("frontendport",0)%>,'<%=JSPLib.ToJSValue(sp.getParameter("custom",""))%>',<%=sp.getParameter("offlinemode",false)%>)" onResize="callResizeFunction()" bgcolor="#ffffff" link="#FFFFFF" vlink="#FFFFFF" alink="#FFFFFF">
Dictionary
Tables
Fields
Description Name Module
Description Name Type Idx
Relations
 
Type
Default value
Privacy
<% if("yes".equals(sp.getGlobal("IsQueryTestInstalled",""))){ %> <% } %>
Query
  • Tables
  • Fields, Group By and Order By, Pivot
  • Calculated fields
  • Join
  • Filter
  • Filter Parameters
  • Access
  • Note
DescriptionAliasTable NameTemp Table
DescriptionNameAliasType
  • Group By and Order By
  • Pivot
OrderBy Description Name
GroupBy Description Name
Pivot Field Name

Data field Name
DescriptionExpression
AliasType
DescriptionExpression
TypeTable 1Table 2
Field Name Not Criteria Example
Use filter when Logical
Field Name Description Type
Check Expression Default on Empty
RoE
  • Remote 
  • Security 
     
  • Cache 
  • Data sensibility 
<%}else{ response.sendRedirect("../jsp-system/SPLogin.jsp?m_cURL="+request.getRequestURI()+(!"".equals(JSPLib.getParametersList(request))?"&":"")+JSPLib.getParametersList(request)); } %>