details: /erp/devel/pi/rev/91555b05f01d changeset: 10349:91555b05f01d user: Mikel Irurita <mikel.irurita <at> openbravo.com> date: Thu Feb 03 09:31:31 2011 +0100 summary: [OBCQL] Included org filter, org optional parameter and currency column. Include filtering for only readable organizations and the organization column in max view. Include a new organization optional paratmeter. Include currency column in widget view at last position.
diffstat: modules/org.openbravo.client.querylist/src-db/database/sourcedata/OBCQL_QUERY_COLUMN.xml | 188 ++++++++- modules/org.openbravo.client.querylist/src-db/database/sourcedata/OBCQL_WIDGET_QUERY.xml | 24 +- modules/org.openbravo.client.querylist/src-db/database/sourcedata/OBUIAPP_PARAMETER.xml | 176 +++++++++ 3 files changed, 354 insertions(+), 34 deletions(-) diffs (truncated from 723 to 300 lines): diff -r b5b9025d652d -r 91555b05f01d modules/org.openbravo.client.querylist/src-db/database/sourcedata/OBCQL_QUERY_COLUMN.xml --- a/modules/org.openbravo.client.querylist/src-db/database/sourcedata/OBCQL_QUERY_COLUMN.xml Thu Feb 03 09:21:58 2011 +0100 +++ b/modules/org.openbravo.client.querylist/src-db/database/sourcedata/OBCQL_QUERY_COLUMN.xml Thu Feb 03 09:31:31 2011 +0100 @@ -9,7 +9,7 @@ <!--01AA894DAA8040218F90CC3B9E73344B--> <DISPLAY_EXPRESSION><![CDATA[outstandingAmount]]></DISPLAY_EXPRESSION> <!--01AA894DAA8040218F90CC3B9E73344B--> <NAME><![CDATA[Outstanding amount]]></NAME> <!--01AA894DAA8040218F90CC3B9E73344B--> <WIDTH><![CDATA[20]]></WIDTH> -<!--01AA894DAA8040218F90CC3B9E73344B--> <SEQNO><![CDATA[60]]></SEQNO> +<!--01AA894DAA8040218F90CC3B9E73344B--> <SEQNO><![CDATA[80]]></SEQNO> <!--01AA894DAA8040218F90CC3B9E73344B--> <AD_REFERENCE_ID><![CDATA[12]]></AD_REFERENCE_ID> <!--01AA894DAA8040218F90CC3B9E73344B--> <INCLUDE_IN><![CDATA[M]]></INCLUDE_IN> <!--01AA894DAA8040218F90CC3B9E73344B--> <HAS_LINK><![CDATA[N]]></HAS_LINK> @@ -17,6 +17,23 @@ <!--01AA894DAA8040218F90CC3B9E73344B--> <WHERECLAUSE_LEFT_PART><![CDATA[inv.outstandingAmount]]></WHERECLAUSE_LEFT_PART> <!--01AA894DAA8040218F90CC3B9E73344B--></OBCQL_QUERY_COLUMN> +<!--0600761021A34EB3BE58351A91A9EA14--><OBCQL_QUERY_COLUMN> +<!--0600761021A34EB3BE58351A91A9EA14--> <OBCQL_QUERY_COLUMN_ID><![CDATA[0600761021A34EB3BE58351A91A9EA14]]></OBCQL_QUERY_COLUMN_ID> +<!--0600761021A34EB3BE58351A91A9EA14--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--0600761021A34EB3BE58351A91A9EA14--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--0600761021A34EB3BE58351A91A9EA14--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--0600761021A34EB3BE58351A91A9EA14--> <OBCQL_WIDGET_QUERY_ID><![CDATA[1EF87E8E961A4E5BA3B41E1AB772B47C]]></OBCQL_WIDGET_QUERY_ID> +<!--0600761021A34EB3BE58351A91A9EA14--> <DISPLAY_EXPRESSION><![CDATA[currency]]></DISPLAY_EXPRESSION> +<!--0600761021A34EB3BE58351A91A9EA14--> <NAME><![CDATA[Currency]]></NAME> +<!--0600761021A34EB3BE58351A91A9EA14--> <WIDTH><![CDATA[12]]></WIDTH> +<!--0600761021A34EB3BE58351A91A9EA14--> <SEQNO><![CDATA[60]]></SEQNO> +<!--0600761021A34EB3BE58351A91A9EA14--> <AD_REFERENCE_ID><![CDATA[10]]></AD_REFERENCE_ID> +<!--0600761021A34EB3BE58351A91A9EA14--> <INCLUDE_IN><![CDATA[W]]></INCLUDE_IN> +<!--0600761021A34EB3BE58351A91A9EA14--> <HAS_LINK><![CDATA[N]]></HAS_LINK> +<!--0600761021A34EB3BE58351A91A9EA14--> <CAN_BE_FILTERED><![CDATA[Y]]></CAN_BE_FILTERED> +<!--0600761021A34EB3BE58351A91A9EA14--> <WHERECLAUSE_LEFT_PART><![CDATA[inv.currency.iSOCode]]></WHERECLAUSE_LEFT_PART> +<!--0600761021A34EB3BE58351A91A9EA14--></OBCQL_QUERY_COLUMN> + <!--15817E30D88A4E04ACA56D1E92D24FD7--><OBCQL_QUERY_COLUMN> <!--15817E30D88A4E04ACA56D1E92D24FD7--> <OBCQL_QUERY_COLUMN_ID><![CDATA[15817E30D88A4E04ACA56D1E92D24FD7]]></OBCQL_QUERY_COLUMN_ID> <!--15817E30D88A4E04ACA56D1E92D24FD7--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> @@ -26,7 +43,7 @@ <!--15817E30D88A4E04ACA56D1E92D24FD7--> <DISPLAY_EXPRESSION><![CDATA[paymentDate]]></DISPLAY_EXPRESSION> <!--15817E30D88A4E04ACA56D1E92D24FD7--> <NAME><![CDATA[Date]]></NAME> <!--15817E30D88A4E04ACA56D1E92D24FD7--> <WIDTH><![CDATA[20]]></WIDTH> -<!--15817E30D88A4E04ACA56D1E92D24FD7--> <SEQNO><![CDATA[30]]></SEQNO> +<!--15817E30D88A4E04ACA56D1E92D24FD7--> <SEQNO><![CDATA[40]]></SEQNO> <!--15817E30D88A4E04ACA56D1E92D24FD7--> <AD_REFERENCE_ID><![CDATA[15]]></AD_REFERENCE_ID> <!--15817E30D88A4E04ACA56D1E92D24FD7--> <INCLUDE_IN><![CDATA[W]]></INCLUDE_IN> <!--15817E30D88A4E04ACA56D1E92D24FD7--> <HAS_LINK><![CDATA[N]]></HAS_LINK> @@ -34,6 +51,40 @@ <!--15817E30D88A4E04ACA56D1E92D24FD7--> <WHERECLAUSE_LEFT_PART><![CDATA[p.paymentDate]]></WHERECLAUSE_LEFT_PART> <!--15817E30D88A4E04ACA56D1E92D24FD7--></OBCQL_QUERY_COLUMN> +<!--19E44CB31B56433593B192089455EBBE--><OBCQL_QUERY_COLUMN> +<!--19E44CB31B56433593B192089455EBBE--> <OBCQL_QUERY_COLUMN_ID><![CDATA[19E44CB31B56433593B192089455EBBE]]></OBCQL_QUERY_COLUMN_ID> +<!--19E44CB31B56433593B192089455EBBE--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--19E44CB31B56433593B192089455EBBE--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--19E44CB31B56433593B192089455EBBE--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--19E44CB31B56433593B192089455EBBE--> <OBCQL_WIDGET_QUERY_ID><![CDATA[E5A0DC8536134185AC8B1897F15DB816]]></OBCQL_WIDGET_QUERY_ID> +<!--19E44CB31B56433593B192089455EBBE--> <DISPLAY_EXPRESSION><![CDATA[organizationName]]></DISPLAY_EXPRESSION> +<!--19E44CB31B56433593B192089455EBBE--> <NAME><![CDATA[Organization]]></NAME> +<!--19E44CB31B56433593B192089455EBBE--> <WIDTH><![CDATA[30]]></WIDTH> +<!--19E44CB31B56433593B192089455EBBE--> <SEQNO><![CDATA[10]]></SEQNO> +<!--19E44CB31B56433593B192089455EBBE--> <AD_REFERENCE_ID><![CDATA[10]]></AD_REFERENCE_ID> +<!--19E44CB31B56433593B192089455EBBE--> <INCLUDE_IN><![CDATA[M]]></INCLUDE_IN> +<!--19E44CB31B56433593B192089455EBBE--> <HAS_LINK><![CDATA[N]]></HAS_LINK> +<!--19E44CB31B56433593B192089455EBBE--> <CAN_BE_FILTERED><![CDATA[Y]]></CAN_BE_FILTERED> +<!--19E44CB31B56433593B192089455EBBE--> <WHERECLAUSE_LEFT_PART><![CDATA[p.organization.name]]></WHERECLAUSE_LEFT_PART> +<!--19E44CB31B56433593B192089455EBBE--></OBCQL_QUERY_COLUMN> + +<!--1B141EDF4FEC40218AE4443460BA3F67--><OBCQL_QUERY_COLUMN> +<!--1B141EDF4FEC40218AE4443460BA3F67--> <OBCQL_QUERY_COLUMN_ID><![CDATA[1B141EDF4FEC40218AE4443460BA3F67]]></OBCQL_QUERY_COLUMN_ID> +<!--1B141EDF4FEC40218AE4443460BA3F67--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--1B141EDF4FEC40218AE4443460BA3F67--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--1B141EDF4FEC40218AE4443460BA3F67--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--1B141EDF4FEC40218AE4443460BA3F67--> <OBCQL_WIDGET_QUERY_ID><![CDATA[E5A0DC8536134185AC8B1897F15DB816]]></OBCQL_WIDGET_QUERY_ID> +<!--1B141EDF4FEC40218AE4443460BA3F67--> <DISPLAY_EXPRESSION><![CDATA[currency]]></DISPLAY_EXPRESSION> +<!--1B141EDF4FEC40218AE4443460BA3F67--> <NAME><![CDATA[Currency]]></NAME> +<!--1B141EDF4FEC40218AE4443460BA3F67--> <WIDTH><![CDATA[12]]></WIDTH> +<!--1B141EDF4FEC40218AE4443460BA3F67--> <SEQNO><![CDATA[60]]></SEQNO> +<!--1B141EDF4FEC40218AE4443460BA3F67--> <AD_REFERENCE_ID><![CDATA[10]]></AD_REFERENCE_ID> +<!--1B141EDF4FEC40218AE4443460BA3F67--> <INCLUDE_IN><![CDATA[W]]></INCLUDE_IN> +<!--1B141EDF4FEC40218AE4443460BA3F67--> <HAS_LINK><![CDATA[N]]></HAS_LINK> +<!--1B141EDF4FEC40218AE4443460BA3F67--> <CAN_BE_FILTERED><![CDATA[Y]]></CAN_BE_FILTERED> +<!--1B141EDF4FEC40218AE4443460BA3F67--> <WHERECLAUSE_LEFT_PART><![CDATA[p.currency.iSOCode]]></WHERECLAUSE_LEFT_PART> +<!--1B141EDF4FEC40218AE4443460BA3F67--></OBCQL_QUERY_COLUMN> + <!--1FCFFA0840074019BF84BBD9E507CB91--><OBCQL_QUERY_COLUMN> <!--1FCFFA0840074019BF84BBD9E507CB91--> <OBCQL_QUERY_COLUMN_ID><![CDATA[1FCFFA0840074019BF84BBD9E507CB91]]></OBCQL_QUERY_COLUMN_ID> <!--1FCFFA0840074019BF84BBD9E507CB91--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> @@ -43,7 +94,7 @@ <!--1FCFFA0840074019BF84BBD9E507CB91--> <DISPLAY_EXPRESSION><![CDATA[invoiceDate]]></DISPLAY_EXPRESSION> <!--1FCFFA0840074019BF84BBD9E507CB91--> <NAME><![CDATA[Date]]></NAME> <!--1FCFFA0840074019BF84BBD9E507CB91--> <WIDTH><![CDATA[20]]></WIDTH> -<!--1FCFFA0840074019BF84BBD9E507CB91--> <SEQNO><![CDATA[30]]></SEQNO> +<!--1FCFFA0840074019BF84BBD9E507CB91--> <SEQNO><![CDATA[40]]></SEQNO> <!--1FCFFA0840074019BF84BBD9E507CB91--> <AD_REFERENCE_ID><![CDATA[15]]></AD_REFERENCE_ID> <!--1FCFFA0840074019BF84BBD9E507CB91--> <INCLUDE_IN><![CDATA[W]]></INCLUDE_IN> <!--1FCFFA0840074019BF84BBD9E507CB91--> <HAS_LINK><![CDATA[N]]></HAS_LINK> @@ -78,7 +129,7 @@ <!--379830F53AF44639B79DB5AB113A575F--> <NAME><![CDATA[Document Number]]></NAME> <!--379830F53AF44639B79DB5AB113A575F--> <WIDTH><![CDATA[20]]></WIDTH> <!--379830F53AF44639B79DB5AB113A575F--> <LINK_EXPRESSION><![CDATA[invoiceId]]></LINK_EXPRESSION> -<!--379830F53AF44639B79DB5AB113A575F--> <SEQNO><![CDATA[10]]></SEQNO> +<!--379830F53AF44639B79DB5AB113A575F--> <SEQNO><![CDATA[20]]></SEQNO> <!--379830F53AF44639B79DB5AB113A575F--> <AD_REFERENCE_ID><![CDATA[10]]></AD_REFERENCE_ID> <!--379830F53AF44639B79DB5AB113A575F--> <INCLUDE_IN><![CDATA[W]]></INCLUDE_IN> <!--379830F53AF44639B79DB5AB113A575F--> <HAS_LINK><![CDATA[Y]]></HAS_LINK> @@ -114,7 +165,7 @@ <!--3C3DBC6021C94CFFA82AF855A7AF6C2F--> <NAME><![CDATA[Business Partner]]></NAME> <!--3C3DBC6021C94CFFA82AF855A7AF6C2F--> <WIDTH><![CDATA[40]]></WIDTH> <!--3C3DBC6021C94CFFA82AF855A7AF6C2F--> <LINK_EXPRESSION><![CDATA[businessPartnerId]]></LINK_EXPRESSION> -<!--3C3DBC6021C94CFFA82AF855A7AF6C2F--> <SEQNO><![CDATA[20]]></SEQNO> +<!--3C3DBC6021C94CFFA82AF855A7AF6C2F--> <SEQNO><![CDATA[30]]></SEQNO> <!--3C3DBC6021C94CFFA82AF855A7AF6C2F--> <AD_REFERENCE_ID><![CDATA[10]]></AD_REFERENCE_ID> <!--3C3DBC6021C94CFFA82AF855A7AF6C2F--> <INCLUDE_IN><![CDATA[W]]></INCLUDE_IN> <!--3C3DBC6021C94CFFA82AF855A7AF6C2F--> <HAS_LINK><![CDATA[Y]]></HAS_LINK> @@ -123,6 +174,23 @@ <!--3C3DBC6021C94CFFA82AF855A7AF6C2F--> <WHERECLAUSE_LEFT_PART><![CDATA[inv.businessPartner.name]]></WHERECLAUSE_LEFT_PART> <!--3C3DBC6021C94CFFA82AF855A7AF6C2F--></OBCQL_QUERY_COLUMN> +<!--45C959E0C3B54D7BBD1244DF35F852B9--><OBCQL_QUERY_COLUMN> +<!--45C959E0C3B54D7BBD1244DF35F852B9--> <OBCQL_QUERY_COLUMN_ID><![CDATA[45C959E0C3B54D7BBD1244DF35F852B9]]></OBCQL_QUERY_COLUMN_ID> +<!--45C959E0C3B54D7BBD1244DF35F852B9--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--45C959E0C3B54D7BBD1244DF35F852B9--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--45C959E0C3B54D7BBD1244DF35F852B9--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--45C959E0C3B54D7BBD1244DF35F852B9--> <OBCQL_WIDGET_QUERY_ID><![CDATA[F94AEB4680AD4AD48255071903000A43]]></OBCQL_WIDGET_QUERY_ID> +<!--45C959E0C3B54D7BBD1244DF35F852B9--> <DISPLAY_EXPRESSION><![CDATA[organizationName]]></DISPLAY_EXPRESSION> +<!--45C959E0C3B54D7BBD1244DF35F852B9--> <NAME><![CDATA[Organization]]></NAME> +<!--45C959E0C3B54D7BBD1244DF35F852B9--> <WIDTH><![CDATA[30]]></WIDTH> +<!--45C959E0C3B54D7BBD1244DF35F852B9--> <SEQNO><![CDATA[10]]></SEQNO> +<!--45C959E0C3B54D7BBD1244DF35F852B9--> <AD_REFERENCE_ID><![CDATA[10]]></AD_REFERENCE_ID> +<!--45C959E0C3B54D7BBD1244DF35F852B9--> <INCLUDE_IN><![CDATA[M]]></INCLUDE_IN> +<!--45C959E0C3B54D7BBD1244DF35F852B9--> <HAS_LINK><![CDATA[N]]></HAS_LINK> +<!--45C959E0C3B54D7BBD1244DF35F852B9--> <CAN_BE_FILTERED><![CDATA[Y]]></CAN_BE_FILTERED> +<!--45C959E0C3B54D7BBD1244DF35F852B9--> <WHERECLAUSE_LEFT_PART><![CDATA[p.organization.name]]></WHERECLAUSE_LEFT_PART> +<!--45C959E0C3B54D7BBD1244DF35F852B9--></OBCQL_QUERY_COLUMN> + <!--493479BFB7D94915889AA9BDD6BB3EA8--><OBCQL_QUERY_COLUMN> <!--493479BFB7D94915889AA9BDD6BB3EA8--> <OBCQL_QUERY_COLUMN_ID><![CDATA[493479BFB7D94915889AA9BDD6BB3EA8]]></OBCQL_QUERY_COLUMN_ID> <!--493479BFB7D94915889AA9BDD6BB3EA8--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> @@ -132,7 +200,7 @@ <!--493479BFB7D94915889AA9BDD6BB3EA8--> <DISPLAY_EXPRESSION><![CDATA[daysTillDue]]></DISPLAY_EXPRESSION> <!--493479BFB7D94915889AA9BDD6BB3EA8--> <NAME><![CDATA[Days till due]]></NAME> <!--493479BFB7D94915889AA9BDD6BB3EA8--> <WIDTH><![CDATA[20]]></WIDTH> -<!--493479BFB7D94915889AA9BDD6BB3EA8--> <SEQNO><![CDATA[70]]></SEQNO> +<!--493479BFB7D94915889AA9BDD6BB3EA8--> <SEQNO><![CDATA[90]]></SEQNO> <!--493479BFB7D94915889AA9BDD6BB3EA8--> <AD_REFERENCE_ID><![CDATA[11]]></AD_REFERENCE_ID> <!--493479BFB7D94915889AA9BDD6BB3EA8--> <INCLUDE_IN><![CDATA[M]]></INCLUDE_IN> <!--493479BFB7D94915889AA9BDD6BB3EA8--> <HAS_LINK><![CDATA[N]]></HAS_LINK> @@ -150,7 +218,7 @@ <!--4FE8DE4D7CF94B128CBA09973BD21C1D--> <NAME><![CDATA[Document Number]]></NAME> <!--4FE8DE4D7CF94B128CBA09973BD21C1D--> <WIDTH><![CDATA[20]]></WIDTH> <!--4FE8DE4D7CF94B128CBA09973BD21C1D--> <LINK_EXPRESSION><![CDATA[finpaymentId]]></LINK_EXPRESSION> -<!--4FE8DE4D7CF94B128CBA09973BD21C1D--> <SEQNO><![CDATA[10]]></SEQNO> +<!--4FE8DE4D7CF94B128CBA09973BD21C1D--> <SEQNO><![CDATA[20]]></SEQNO> <!--4FE8DE4D7CF94B128CBA09973BD21C1D--> <AD_REFERENCE_ID><![CDATA[10]]></AD_REFERENCE_ID> <!--4FE8DE4D7CF94B128CBA09973BD21C1D--> <INCLUDE_IN><![CDATA[W]]></INCLUDE_IN> <!--4FE8DE4D7CF94B128CBA09973BD21C1D--> <HAS_LINK><![CDATA[Y]]></HAS_LINK> @@ -169,7 +237,7 @@ <!--51429339D294475986634D7E876F4A53--> <NAME><![CDATA[Document Number]]></NAME> <!--51429339D294475986634D7E876F4A53--> <WIDTH><![CDATA[20]]></WIDTH> <!--51429339D294475986634D7E876F4A53--> <LINK_EXPRESSION><![CDATA[invoiceId]]></LINK_EXPRESSION> -<!--51429339D294475986634D7E876F4A53--> <SEQNO><![CDATA[10]]></SEQNO> +<!--51429339D294475986634D7E876F4A53--> <SEQNO><![CDATA[20]]></SEQNO> <!--51429339D294475986634D7E876F4A53--> <AD_REFERENCE_ID><![CDATA[10]]></AD_REFERENCE_ID> <!--51429339D294475986634D7E876F4A53--> <INCLUDE_IN><![CDATA[W]]></INCLUDE_IN> <!--51429339D294475986634D7E876F4A53--> <HAS_LINK><![CDATA[Y]]></HAS_LINK> @@ -187,7 +255,7 @@ <!--5410706611F04069A9326D70425EAD22--> <DISPLAY_EXPRESSION><![CDATA[dueAmount]]></DISPLAY_EXPRESSION> <!--5410706611F04069A9326D70425EAD22--> <NAME><![CDATA[Due amount]]></NAME> <!--5410706611F04069A9326D70425EAD22--> <WIDTH><![CDATA[20]]></WIDTH> -<!--5410706611F04069A9326D70425EAD22--> <SEQNO><![CDATA[80]]></SEQNO> +<!--5410706611F04069A9326D70425EAD22--> <SEQNO><![CDATA[100]]></SEQNO> <!--5410706611F04069A9326D70425EAD22--> <AD_REFERENCE_ID><![CDATA[12]]></AD_REFERENCE_ID> <!--5410706611F04069A9326D70425EAD22--> <INCLUDE_IN><![CDATA[M]]></INCLUDE_IN> <!--5410706611F04069A9326D70425EAD22--> <HAS_LINK><![CDATA[N]]></HAS_LINK> @@ -203,9 +271,8 @@ <!--56DC401F52BF4BE593C782240AE4AB67--> <OBCQL_WIDGET_QUERY_ID><![CDATA[E5A0DC8536134185AC8B1897F15DB816]]></OBCQL_WIDGET_QUERY_ID> <!--56DC401F52BF4BE593C782240AE4AB67--> <DISPLAY_EXPRESSION><![CDATA[amount]]></DISPLAY_EXPRESSION> <!--56DC401F52BF4BE593C782240AE4AB67--> <NAME><![CDATA[Amount]]></NAME> -<!--56DC401F52BF4BE593C782240AE4AB67--> <SUMMARIZE_TYPE><![CDATA[sum]]></SUMMARIZE_TYPE> <!--56DC401F52BF4BE593C782240AE4AB67--> <WIDTH><![CDATA[20]]></WIDTH> -<!--56DC401F52BF4BE593C782240AE4AB67--> <SEQNO><![CDATA[40]]></SEQNO> +<!--56DC401F52BF4BE593C782240AE4AB67--> <SEQNO><![CDATA[50]]></SEQNO> <!--56DC401F52BF4BE593C782240AE4AB67--> <AD_REFERENCE_ID><![CDATA[12]]></AD_REFERENCE_ID> <!--56DC401F52BF4BE593C782240AE4AB67--> <INCLUDE_IN><![CDATA[W]]></INCLUDE_IN> <!--56DC401F52BF4BE593C782240AE4AB67--> <HAS_LINK><![CDATA[N]]></HAS_LINK> @@ -213,6 +280,23 @@ <!--56DC401F52BF4BE593C782240AE4AB67--> <WHERECLAUSE_LEFT_PART><![CDATA[p.amount]]></WHERECLAUSE_LEFT_PART> <!--56DC401F52BF4BE593C782240AE4AB67--></OBCQL_QUERY_COLUMN> +<!--5C4E31EC2ACC4F60951D135BABD8F691--><OBCQL_QUERY_COLUMN> +<!--5C4E31EC2ACC4F60951D135BABD8F691--> <OBCQL_QUERY_COLUMN_ID><![CDATA[5C4E31EC2ACC4F60951D135BABD8F691]]></OBCQL_QUERY_COLUMN_ID> +<!--5C4E31EC2ACC4F60951D135BABD8F691--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--5C4E31EC2ACC4F60951D135BABD8F691--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--5C4E31EC2ACC4F60951D135BABD8F691--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--5C4E31EC2ACC4F60951D135BABD8F691--> <OBCQL_WIDGET_QUERY_ID><![CDATA[1EF87E8E961A4E5BA3B41E1AB772B47C]]></OBCQL_WIDGET_QUERY_ID> +<!--5C4E31EC2ACC4F60951D135BABD8F691--> <DISPLAY_EXPRESSION><![CDATA[organizationName]]></DISPLAY_EXPRESSION> +<!--5C4E31EC2ACC4F60951D135BABD8F691--> <NAME><![CDATA[Organization]]></NAME> +<!--5C4E31EC2ACC4F60951D135BABD8F691--> <WIDTH><![CDATA[30]]></WIDTH> +<!--5C4E31EC2ACC4F60951D135BABD8F691--> <SEQNO><![CDATA[10]]></SEQNO> +<!--5C4E31EC2ACC4F60951D135BABD8F691--> <AD_REFERENCE_ID><![CDATA[10]]></AD_REFERENCE_ID> +<!--5C4E31EC2ACC4F60951D135BABD8F691--> <INCLUDE_IN><![CDATA[M]]></INCLUDE_IN> +<!--5C4E31EC2ACC4F60951D135BABD8F691--> <HAS_LINK><![CDATA[N]]></HAS_LINK> +<!--5C4E31EC2ACC4F60951D135BABD8F691--> <CAN_BE_FILTERED><![CDATA[Y]]></CAN_BE_FILTERED> +<!--5C4E31EC2ACC4F60951D135BABD8F691--> <WHERECLAUSE_LEFT_PART><![CDATA[inv.organization.name]]></WHERECLAUSE_LEFT_PART> +<!--5C4E31EC2ACC4F60951D135BABD8F691--></OBCQL_QUERY_COLUMN> + <!--6B151041105E4DD0805AC2F709A7A81E--><OBCQL_QUERY_COLUMN> <!--6B151041105E4DD0805AC2F709A7A81E--> <OBCQL_QUERY_COLUMN_ID><![CDATA[6B151041105E4DD0805AC2F709A7A81E]]></OBCQL_QUERY_COLUMN_ID> <!--6B151041105E4DD0805AC2F709A7A81E--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> @@ -222,7 +306,7 @@ <!--6B151041105E4DD0805AC2F709A7A81E--> <DISPLAY_EXPRESSION><![CDATA[paymentDate]]></DISPLAY_EXPRESSION> <!--6B151041105E4DD0805AC2F709A7A81E--> <NAME><![CDATA[Date]]></NAME> <!--6B151041105E4DD0805AC2F709A7A81E--> <WIDTH><![CDATA[20]]></WIDTH> -<!--6B151041105E4DD0805AC2F709A7A81E--> <SEQNO><![CDATA[30]]></SEQNO> +<!--6B151041105E4DD0805AC2F709A7A81E--> <SEQNO><![CDATA[40]]></SEQNO> <!--6B151041105E4DD0805AC2F709A7A81E--> <AD_REFERENCE_ID><![CDATA[15]]></AD_REFERENCE_ID> <!--6B151041105E4DD0805AC2F709A7A81E--> <INCLUDE_IN><![CDATA[W]]></INCLUDE_IN> <!--6B151041105E4DD0805AC2F709A7A81E--> <HAS_LINK><![CDATA[N]]></HAS_LINK> @@ -240,7 +324,7 @@ <!--70CEB497CA254F3C892AE0B68920897D--> <NAME><![CDATA[Business Partner]]></NAME> <!--70CEB497CA254F3C892AE0B68920897D--> <WIDTH><![CDATA[40]]></WIDTH> <!--70CEB497CA254F3C892AE0B68920897D--> <LINK_EXPRESSION><![CDATA[businessPartnerId]]></LINK_EXPRESSION> -<!--70CEB497CA254F3C892AE0B68920897D--> <SEQNO><![CDATA[20]]></SEQNO> +<!--70CEB497CA254F3C892AE0B68920897D--> <SEQNO><![CDATA[30]]></SEQNO> <!--70CEB497CA254F3C892AE0B68920897D--> <AD_REFERENCE_ID><![CDATA[10]]></AD_REFERENCE_ID> <!--70CEB497CA254F3C892AE0B68920897D--> <INCLUDE_IN><![CDATA[W]]></INCLUDE_IN> <!--70CEB497CA254F3C892AE0B68920897D--> <HAS_LINK><![CDATA[Y]]></HAS_LINK> @@ -259,7 +343,7 @@ <!--742D993ADF7444318F8CAF38DDCB1997--> <NAME><![CDATA[Business Partner]]></NAME> <!--742D993ADF7444318F8CAF38DDCB1997--> <WIDTH><![CDATA[40]]></WIDTH> <!--742D993ADF7444318F8CAF38DDCB1997--> <LINK_EXPRESSION><![CDATA[businessPartnerId]]></LINK_EXPRESSION> -<!--742D993ADF7444318F8CAF38DDCB1997--> <SEQNO><![CDATA[20]]></SEQNO> +<!--742D993ADF7444318F8CAF38DDCB1997--> <SEQNO><![CDATA[30]]></SEQNO> <!--742D993ADF7444318F8CAF38DDCB1997--> <AD_REFERENCE_ID><![CDATA[10]]></AD_REFERENCE_ID> <!--742D993ADF7444318F8CAF38DDCB1997--> <INCLUDE_IN><![CDATA[W]]></INCLUDE_IN> <!--742D993ADF7444318F8CAF38DDCB1997--> <HAS_LINK><![CDATA[Y]]></HAS_LINK> @@ -294,7 +378,7 @@ <!--7EFCCE042B4841D0B9377B54F11973E7--> <DISPLAY_EXPRESSION><![CDATA[daysTillDue]]></DISPLAY_EXPRESSION> <!--7EFCCE042B4841D0B9377B54F11973E7--> <NAME><![CDATA[Days till due]]></NAME> <!--7EFCCE042B4841D0B9377B54F11973E7--> <WIDTH><![CDATA[20]]></WIDTH> -<!--7EFCCE042B4841D0B9377B54F11973E7--> <SEQNO><![CDATA[70]]></SEQNO> +<!--7EFCCE042B4841D0B9377B54F11973E7--> <SEQNO><![CDATA[90]]></SEQNO> <!--7EFCCE042B4841D0B9377B54F11973E7--> <AD_REFERENCE_ID><![CDATA[11]]></AD_REFERENCE_ID> <!--7EFCCE042B4841D0B9377B54F11973E7--> <INCLUDE_IN><![CDATA[M]]></INCLUDE_IN> <!--7EFCCE042B4841D0B9377B54F11973E7--> <HAS_LINK><![CDATA[N]]></HAS_LINK> @@ -302,6 +386,23 @@ <!--7EFCCE042B4841D0B9377B54F11973E7--> <WHERECLAUSE_LEFT_PART><![CDATA[inv.daysTillDue]]></WHERECLAUSE_LEFT_PART> <!--7EFCCE042B4841D0B9377B54F11973E7--></OBCQL_QUERY_COLUMN> +<!--879667D64C66466297E4113CBABEACA5--><OBCQL_QUERY_COLUMN> +<!--879667D64C66466297E4113CBABEACA5--> <OBCQL_QUERY_COLUMN_ID><![CDATA[879667D64C66466297E4113CBABEACA5]]></OBCQL_QUERY_COLUMN_ID> +<!--879667D64C66466297E4113CBABEACA5--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--879667D64C66466297E4113CBABEACA5--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--879667D64C66466297E4113CBABEACA5--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--879667D64C66466297E4113CBABEACA5--> <OBCQL_WIDGET_QUERY_ID><![CDATA[58BCB96595FA45678CC1423402238309]]></OBCQL_WIDGET_QUERY_ID> +<!--879667D64C66466297E4113CBABEACA5--> <DISPLAY_EXPRESSION><![CDATA[currency]]></DISPLAY_EXPRESSION> +<!--879667D64C66466297E4113CBABEACA5--> <NAME><![CDATA[Currency]]></NAME> +<!--879667D64C66466297E4113CBABEACA5--> <WIDTH><![CDATA[12]]></WIDTH> +<!--879667D64C66466297E4113CBABEACA5--> <SEQNO><![CDATA[60]]></SEQNO> +<!--879667D64C66466297E4113CBABEACA5--> <AD_REFERENCE_ID><![CDATA[10]]></AD_REFERENCE_ID> +<!--879667D64C66466297E4113CBABEACA5--> <INCLUDE_IN><![CDATA[W]]></INCLUDE_IN> +<!--879667D64C66466297E4113CBABEACA5--> <HAS_LINK><![CDATA[N]]></HAS_LINK> +<!--879667D64C66466297E4113CBABEACA5--> <CAN_BE_FILTERED><![CDATA[Y]]></CAN_BE_FILTERED> +<!--879667D64C66466297E4113CBABEACA5--> <WHERECLAUSE_LEFT_PART><![CDATA[inv.currency.iSOCode]]></WHERECLAUSE_LEFT_PART> +<!--879667D64C66466297E4113CBABEACA5--></OBCQL_QUERY_COLUMN> + <!--88104CDF6CC2418FB405A4B5BA74265D--><OBCQL_QUERY_COLUMN> <!--88104CDF6CC2418FB405A4B5BA74265D--> <OBCQL_QUERY_COLUMN_ID><![CDATA[88104CDF6CC2418FB405A4B5BA74265D]]></OBCQL_QUERY_COLUMN_ID> <!--88104CDF6CC2418FB405A4B5BA74265D--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> @@ -346,7 +447,7 @@ <!--94B1051270614629B02531C5F894BCF1--> <NAME><![CDATA[Business Partner]]></NAME> <!--94B1051270614629B02531C5F894BCF1--> <WIDTH><![CDATA[40]]></WIDTH> <!--94B1051270614629B02531C5F894BCF1--> <LINK_EXPRESSION><![CDATA[businessPartnerId]]></LINK_EXPRESSION> -<!--94B1051270614629B02531C5F894BCF1--> <SEQNO><![CDATA[20]]></SEQNO> +<!--94B1051270614629B02531C5F894BCF1--> <SEQNO><![CDATA[30]]></SEQNO> <!--94B1051270614629B02531C5F894BCF1--> <AD_REFERENCE_ID><![CDATA[10]]></AD_REFERENCE_ID> <!--94B1051270614629B02531C5F894BCF1--> <INCLUDE_IN><![CDATA[W]]></INCLUDE_IN> <!--94B1051270614629B02531C5F894BCF1--> <HAS_LINK><![CDATA[Y]]></HAS_LINK> @@ -355,6 +456,23 @@ <!--94B1051270614629B02531C5F894BCF1--> <WHERECLAUSE_LEFT_PART><![CDATA[p.businessPartner.name]]></WHERECLAUSE_LEFT_PART> <!--94B1051270614629B02531C5F894BCF1--></OBCQL_QUERY_COLUMN> +<!--99076BD44F06465DACC0C4BAE01773DC--><OBCQL_QUERY_COLUMN> +<!--99076BD44F06465DACC0C4BAE01773DC--> <OBCQL_QUERY_COLUMN_ID><![CDATA[99076BD44F06465DACC0C4BAE01773DC]]></OBCQL_QUERY_COLUMN_ID> +<!--99076BD44F06465DACC0C4BAE01773DC--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--99076BD44F06465DACC0C4BAE01773DC--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--99076BD44F06465DACC0C4BAE01773DC--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--99076BD44F06465DACC0C4BAE01773DC--> <OBCQL_WIDGET_QUERY_ID><![CDATA[58BCB96595FA45678CC1423402238309]]></OBCQL_WIDGET_QUERY_ID> +<!--99076BD44F06465DACC0C4BAE01773DC--> <DISPLAY_EXPRESSION><![CDATA[organizationName]]></DISPLAY_EXPRESSION> +<!--99076BD44F06465DACC0C4BAE01773DC--> <NAME><![CDATA[Organization]]></NAME> +<!--99076BD44F06465DACC0C4BAE01773DC--> <WIDTH><![CDATA[30]]></WIDTH> +<!--99076BD44F06465DACC0C4BAE01773DC--> <SEQNO><![CDATA[10]]></SEQNO> +<!--99076BD44F06465DACC0C4BAE01773DC--> <AD_REFERENCE_ID><![CDATA[10]]></AD_REFERENCE_ID> +<!--99076BD44F06465DACC0C4BAE01773DC--> <INCLUDE_IN><![CDATA[M]]></INCLUDE_IN> +<!--99076BD44F06465DACC0C4BAE01773DC--> <HAS_LINK><![CDATA[N]]></HAS_LINK> +<!--99076BD44F06465DACC0C4BAE01773DC--> <CAN_BE_FILTERED><![CDATA[Y]]></CAN_BE_FILTERED> +<!--99076BD44F06465DACC0C4BAE01773DC--> <WHERECLAUSE_LEFT_PART><![CDATA[inv.organization.name]]></WHERECLAUSE_LEFT_PART> +<!--99076BD44F06465DACC0C4BAE01773DC--></OBCQL_QUERY_COLUMN> + <!--9F88542C3F944CDF867298D292C8113C--><OBCQL_QUERY_COLUMN> <!--9F88542C3F944CDF867298D292C8113C--> <OBCQL_QUERY_COLUMN_ID><![CDATA[9F88542C3F944CDF867298D292C8113C]]></OBCQL_QUERY_COLUMN_ID> ------------------------------------------------------------------------------ Special Offer-- Download ArcSight Logger for FREE (a $49 USD value)! Finally, a world-class log management solution at an even better price-free! Download using promo code Free_Logger_4_Dev2Dev. Offer expires February 28th, so secure your free ArcSight Logger TODAY! http://p.sf.net/sfu/arcsight-sfd2d _______________________________________________ Openbravo-commits mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/openbravo-commits
