src/org/openbravo/erpCommon/ad_forms/ShowSessionVariables_data.xsql
changeset 1605 8a0fe0193bef
parent 683 8cc2b7ffa4f4
child 1749 1dee17343a12
equal deleted inserted replaced
1604:a1c518e6ed93 1605:8a0fe0193bef
    46     <Parameter name="adLanguage"/>
    46     <Parameter name="adLanguage"/>
    47   </SqlMethod>
    47   </SqlMethod>
    48   <SqlMethod name="usuario" type="preparedStatement" return="String" default="">
    48   <SqlMethod name="usuario" type="preparedStatement" return="String" default="">
    49     <SqlMethodComment></SqlMethodComment>
    49     <SqlMethodComment></SqlMethodComment>
    50     <Sql><![CDATA[
    50     <Sql><![CDATA[
    51       SELECT USERNAME FROM AD_USER WHERE AD_USER_ID = TO_NUMBER(?)
    51       SELECT USERNAME FROM AD_USER WHERE AD_USER_ID = ?
    52     ]]></Sql>
    52     ]]></Sql>
    53     <Parameter name="adUserId"/>
    53     <Parameter name="adUserId"/>
    54   </SqlMethod>
    54   </SqlMethod>
    55   <SqlMethod name="rol" type="preparedStatement" return="String" default="">
    55   <SqlMethod name="rol" type="preparedStatement" return="String" default="">
    56     <SqlMethodComment></SqlMethodComment>
    56     <SqlMethodComment></SqlMethodComment>
    57     <Sql><![CDATA[
    57     <Sql><![CDATA[
    58       SELECT NAME FROM AD_ROLE WHERE AD_ROLE_ID = TO_NUMBER(?)
    58       SELECT NAME FROM AD_ROLE WHERE AD_ROLE_ID = ?
    59     ]]></Sql>
    59     ]]></Sql>
    60     <Parameter name="adRoleId"/>
    60     <Parameter name="adRoleId"/>
    61   </SqlMethod>
    61   </SqlMethod>
    62   <SqlMethod name="cliente" type="preparedStatement" return="String" default="">
    62   <SqlMethod name="cliente" type="preparedStatement" return="String" default="">
    63     <SqlMethodComment></SqlMethodComment>
    63     <SqlMethodComment></SqlMethodComment>
    64     <Sql><![CDATA[
    64     <Sql><![CDATA[
    65       SELECT NAME FROM AD_CLIENT WHERE AD_CLIENT_ID = TO_NUMBER(?)
    65       SELECT NAME FROM AD_CLIENT WHERE AD_CLIENT_ID = ?
    66     ]]></Sql>
    66     ]]></Sql>
    67     <Parameter name="adClientId"/>
    67     <Parameter name="adClientId"/>
    68   </SqlMethod>
    68   </SqlMethod>
    69   <SqlMethod name="organizacion" type="preparedStatement" return="String" default="">
    69   <SqlMethod name="organizacion" type="preparedStatement" return="String" default="">
    70     <SqlMethodComment></SqlMethodComment>
    70     <SqlMethodComment></SqlMethodComment>
    71     <Sql><![CDATA[
    71     <Sql><![CDATA[
    72       SELECT NAME FROM AD_ORG WHERE AD_ORG_ID = TO_NUMBER(?)
    72       SELECT NAME FROM AD_ORG WHERE AD_ORG_ID = ?
    73     ]]></Sql>
    73     ]]></Sql>
    74     <Parameter name="adOrgId"/>
    74     <Parameter name="adOrgId"/>
    75   </SqlMethod>
    75   </SqlMethod>
    76   <SqlMethod name="versionBBDD" type="preparedStatement" return="String" default="">
    76   <SqlMethod name="versionBBDD" type="preparedStatement" return="String" default="">
    77     <SqlMethodComment></SqlMethodComment>
    77     <SqlMethodComment></SqlMethodComment>
    78     <Sql><![CDATA[
    78     <Sql><![CDATA[
    79       SELECT TAD_VERSION FROM AD_SYSTEM WHERE AD_SYSTEM_ID = 0
    79       SELECT TAD_VERSION FROM AD_SYSTEM WHERE AD_SYSTEM_ID = '0'
    80     ]]></Sql>
    80     ]]></Sql>
    81   </SqlMethod>
    81   </SqlMethod>
    82   <SqlMethod name="versionVerticalBBDD" type="preparedStatement" return="String" default="">
    82   <SqlMethod name="versionVerticalBBDD" type="preparedStatement" return="String" default="">
    83     <SqlMethodComment></SqlMethodComment>
    83     <SqlMethodComment></SqlMethodComment>
    84     <Sql><![CDATA[
    84     <Sql><![CDATA[
    85       SELECT TAD_PARENT_VERSION FROM AD_SYSTEM WHERE AD_SYSTEM_ID = 0
    85       SELECT TAD_PARENT_VERSION FROM AD_SYSTEM WHERE AD_SYSTEM_ID = '0'
    86     ]]></Sql>
    86     ]]></Sql>
    87   </SqlMethod>
    87   </SqlMethod>
    88   <SqlMethod name="selectPreference" type="preparedStatement" return="String" default="">
    88   <SqlMethod name="selectPreference" type="preparedStatement" return="String" default="">
    89     <SqlMethodComment></SqlMethodComment>
    89     <SqlMethodComment></SqlMethodComment>
    90     <Sql><![CDATA[
    90     <Sql><![CDATA[
    91       SELECT AD_Preference_ID 
    91       SELECT AD_Preference_ID 
    92       FROM AD_Preference 
    92       FROM AD_Preference 
    93       WHERE AD_Client_ID IN ('1') 
    93       WHERE AD_Client_ID IN ('1') 
    94       AND AD_Org_ID IN ('2') 
    94       AND AD_Org_ID IN ('2') 
    95       AND (AD_User_ID IS NULL OR AD_User_ID=0 OR AD_User_ID = TO_NUMBER(?)) 
    95       AND (AD_User_ID IS NULL OR AD_User_ID='0' OR AD_User_ID = ?) 
    96       AND IsActive='Y' 
    96       AND IsActive='Y' 
    97       AND UPPER(Attribute) = UPPER(?)
    97       AND UPPER(Attribute) = UPPER(?)
    98       ORDER BY AD_Client_ID, AD_Org_ID, AD_User_ID
    98       ORDER BY AD_Client_ID, AD_Org_ID, AD_User_ID
    99     ]]></Sql>
    99     ]]></Sql>
   100     <Parameter name="adClientId" type="replace" optional="true" after="AD_Client_ID IN (" text="'1'"/>
   100     <Parameter name="adClientId" type="replace" optional="true" after="AD_Client_ID IN (" text="'1'"/>
   103     <Parameter name="columnname"/>
   103     <Parameter name="columnname"/>
   104   </SqlMethod>
   104   </SqlMethod>
   105   <SqlMethod name="update" type="preparedStatement" return="rowCount">
   105   <SqlMethod name="update" type="preparedStatement" return="rowCount">
   106     <SqlMethodComment></SqlMethodComment>
   106     <SqlMethodComment></SqlMethodComment>
   107     <Sql><![CDATA[
   107     <Sql><![CDATA[
   108       UPDATE AD_PREFERENCE SET UPDATED=now(), UPDATEDBY=TO_NUMBER(?), VALUE=?
   108       UPDATE AD_PREFERENCE SET UPDATED=now(), UPDATEDBY = ?, VALUE=?
   109       WHERE AD_Preference_ID = TO_NUMBER(?)
   109       WHERE AD_Preference_ID = ?
   110     ]]></Sql>
   110     ]]></Sql>
   111       <Parameter name="adUserId"/>
   111       <Parameter name="adUserId"/>
   112       <Parameter name="value"/>
   112       <Parameter name="value"/>
   113       <Parameter name="adPreferenceId"/>
   113       <Parameter name="adPreferenceId"/>
   114   </SqlMethod>
   114   </SqlMethod>
   115   <SqlMethod name="updateRange" type="preparedStatement" return="rowCount">
   115   <SqlMethod name="updateRange" type="preparedStatement" return="rowCount">
   116     <SqlMethodComment></SqlMethodComment>
   116     <SqlMethodComment></SqlMethodComment>
   117     <Sql><![CDATA[
   117     <Sql><![CDATA[
   118       UPDATE AD_SYSTEM SET UPDATED=now(), UPDATEDBY=TO_NUMBER(?), TAD_RECORDRANGE=TO_NUMBER(?), TAD_RECORDRANGE_INFO=TO_NUMBER(?), TAD_TRANSACTIONALRANGE=TO_NUMBER(?), TAD_THEME=?
   118       UPDATE AD_SYSTEM SET UPDATED=now(), UPDATEDBY = ?, TAD_RECORDRANGE=TO_NUMBER(?), TAD_RECORDRANGE_INFO=TO_NUMBER(?), TAD_TRANSACTIONALRANGE=TO_NUMBER(?), TAD_THEME=?
   119       WHERE AD_System_ID = 0
   119       WHERE AD_System_ID = '0'
   120     ]]></Sql>
   120     ]]></Sql>
   121       <Parameter name="adUserId"/>
   121       <Parameter name="adUserId"/>
   122       <Parameter name="tadRecordrange"/>
   122       <Parameter name="tadRecordrange"/>
   123       <Parameter name="tadRecordrangeInfo"/>
   123       <Parameter name="tadRecordrangeInfo"/>
   124       <Parameter name="tadTransactionalrange"/>
   124       <Parameter name="tadTransactionalrange"/>