details: /erp/devel/pi/rev/1c94ebed6ca1 changeset: 9319:1c94ebed6ca1 user: Mikel Irurita <mikel.irurita <at> openbravo.com> date: Thu Dec 23 10:54:19 2010 +0100 summary: [OBCQL] Added 2 examples of Widgets: Invoices to pay and collect
diffstat: modules/org.openbravo.client.querylist/src-db/database/sourcedata/OBCQL_QUERY_COLUMN.xml | 138 +++++++++ modules/org.openbravo.client.querylist/src-db/database/sourcedata/OBCQL_WIDGET_QUERY.xml | 38 ++ modules/org.openbravo.client.querylist/src-db/database/sourcedata/OBKMO_WIDGET_CLASS.xml | 30 + modules/org.openbravo.client.querylist/src-db/database/sourcedata/OBUIAPP_PARAMETER.xml | 152 ++++++++++ 4 files changed, 358 insertions(+), 0 deletions(-) diffs (truncated from 440 to 300 lines): diff -r 72dc1aa74756 -r 1c94ebed6ca1 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 Dec 23 10:22:43 2010 +0100 +++ b/modules/org.openbravo.client.querylist/src-db/database/sourcedata/OBCQL_QUERY_COLUMN.xml Thu Dec 23 10:54:19 2010 +0100 @@ -33,6 +33,23 @@ <!--1B0F7BAEABF54A8EAB2CAA5A04A107DB--> <AD_TAB_ID><![CDATA[106]]></AD_TAB_ID> <!--1B0F7BAEABF54A8EAB2CAA5A04A107DB--></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> +<!--1FCFFA0840074019BF84BBD9E507CB91--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--1FCFFA0840074019BF84BBD9E507CB91--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--1FCFFA0840074019BF84BBD9E507CB91--> <OBCQL_WIDGET_QUERY_ID><![CDATA[58BCB96595FA45678CC1423402238309]]></OBCQL_WIDGET_QUERY_ID> +<!--1FCFFA0840074019BF84BBD9E507CB91--> <DISPLAY_EXPRESSION><![CDATA[invoiceDate]]></DISPLAY_EXPRESSION> +<!--1FCFFA0840074019BF84BBD9E507CB91--> <NAME><![CDATA[Date]]></NAME> +<!--1FCFFA0840074019BF84BBD9E507CB91--> <WIDTH><![CDATA[100.0000]]></WIDTH> +<!--1FCFFA0840074019BF84BBD9E507CB91--> <LINK_EXPRESSION><![CDATA[invoiceId]]></LINK_EXPRESSION> +<!--1FCFFA0840074019BF84BBD9E507CB91--> <SEQNO><![CDATA[30.0000]]></SEQNO> +<!--1FCFFA0840074019BF84BBD9E507CB91--> <AD_REFERENCE_ID><![CDATA[10]]></AD_REFERENCE_ID> +<!--1FCFFA0840074019BF84BBD9E507CB91--> <INCLUDE_IN><![CDATA[W]]></INCLUDE_IN> +<!--1FCFFA0840074019BF84BBD9E507CB91--> <HAS_LINK><![CDATA[Y]]></HAS_LINK> +<!--1FCFFA0840074019BF84BBD9E507CB91--> <AD_TAB_ID><![CDATA[290]]></AD_TAB_ID> +<!--1FCFFA0840074019BF84BBD9E507CB91--></OBCQL_QUERY_COLUMN> + <!--21C941CEA93D4E5D839470FE1F9D9AB2--><OBCQL_QUERY_COLUMN> <!--21C941CEA93D4E5D839470FE1F9D9AB2--> <OBCQL_QUERY_COLUMN_ID><![CDATA[21C941CEA93D4E5D839470FE1F9D9AB2]]></OBCQL_QUERY_COLUMN_ID> <!--21C941CEA93D4E5D839470FE1F9D9AB2--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> @@ -48,6 +65,57 @@ <!--21C941CEA93D4E5D839470FE1F9D9AB2--> <HAS_LINK><![CDATA[N]]></HAS_LINK> <!--21C941CEA93D4E5D839470FE1F9D9AB2--></OBCQL_QUERY_COLUMN> +<!--379830F53AF44639B79DB5AB113A575F--><OBCQL_QUERY_COLUMN> +<!--379830F53AF44639B79DB5AB113A575F--> <OBCQL_QUERY_COLUMN_ID><![CDATA[379830F53AF44639B79DB5AB113A575F]]></OBCQL_QUERY_COLUMN_ID> +<!--379830F53AF44639B79DB5AB113A575F--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--379830F53AF44639B79DB5AB113A575F--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--379830F53AF44639B79DB5AB113A575F--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--379830F53AF44639B79DB5AB113A575F--> <OBCQL_WIDGET_QUERY_ID><![CDATA[1EF87E8E961A4E5BA3B41E1AB772B47C]]></OBCQL_WIDGET_QUERY_ID> +<!--379830F53AF44639B79DB5AB113A575F--> <DISPLAY_EXPRESSION><![CDATA[documentNo]]></DISPLAY_EXPRESSION> +<!--379830F53AF44639B79DB5AB113A575F--> <NAME><![CDATA[Document Number]]></NAME> +<!--379830F53AF44639B79DB5AB113A575F--> <WIDTH><![CDATA[100.0000]]></WIDTH> +<!--379830F53AF44639B79DB5AB113A575F--> <LINK_EXPRESSION><![CDATA[invoiceId]]></LINK_EXPRESSION> +<!--379830F53AF44639B79DB5AB113A575F--> <SEQNO><![CDATA[10.0000]]></SEQNO> +<!--379830F53AF44639B79DB5AB113A575F--> <AD_REFERENCE_ID><![CDATA[10]]></AD_REFERENCE_ID> +<!--379830F53AF44639B79DB5AB113A575F--> <INCLUDE_IN><![CDATA[W]]></INCLUDE_IN> +<!--379830F53AF44639B79DB5AB113A575F--> <HAS_LINK><![CDATA[Y]]></HAS_LINK> +<!--379830F53AF44639B79DB5AB113A575F--> <AD_TAB_ID><![CDATA[263]]></AD_TAB_ID> +<!--379830F53AF44639B79DB5AB113A575F--></OBCQL_QUERY_COLUMN> + +<!--3C3DBC6021C94CFFA82AF855A7AF6C2F--><OBCQL_QUERY_COLUMN> +<!--3C3DBC6021C94CFFA82AF855A7AF6C2F--> <OBCQL_QUERY_COLUMN_ID><![CDATA[3C3DBC6021C94CFFA82AF855A7AF6C2F]]></OBCQL_QUERY_COLUMN_ID> +<!--3C3DBC6021C94CFFA82AF855A7AF6C2F--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--3C3DBC6021C94CFFA82AF855A7AF6C2F--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--3C3DBC6021C94CFFA82AF855A7AF6C2F--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--3C3DBC6021C94CFFA82AF855A7AF6C2F--> <OBCQL_WIDGET_QUERY_ID><![CDATA[1EF87E8E961A4E5BA3B41E1AB772B47C]]></OBCQL_WIDGET_QUERY_ID> +<!--3C3DBC6021C94CFFA82AF855A7AF6C2F--> <DISPLAY_EXPRESSION><![CDATA[businessPartnerName]]></DISPLAY_EXPRESSION> +<!--3C3DBC6021C94CFFA82AF855A7AF6C2F--> <NAME><![CDATA[Business Partner]]></NAME> +<!--3C3DBC6021C94CFFA82AF855A7AF6C2F--> <WIDTH><![CDATA[100.0000]]></WIDTH> +<!--3C3DBC6021C94CFFA82AF855A7AF6C2F--> <LINK_EXPRESSION><![CDATA[invoiceId]]></LINK_EXPRESSION> +<!--3C3DBC6021C94CFFA82AF855A7AF6C2F--> <SEQNO><![CDATA[20.0000]]></SEQNO> +<!--3C3DBC6021C94CFFA82AF855A7AF6C2F--> <AD_REFERENCE_ID><![CDATA[10]]></AD_REFERENCE_ID> +<!--3C3DBC6021C94CFFA82AF855A7AF6C2F--> <INCLUDE_IN><![CDATA[W]]></INCLUDE_IN> +<!--3C3DBC6021C94CFFA82AF855A7AF6C2F--> <HAS_LINK><![CDATA[Y]]></HAS_LINK> +<!--3C3DBC6021C94CFFA82AF855A7AF6C2F--> <AD_TAB_ID><![CDATA[263]]></AD_TAB_ID> +<!--3C3DBC6021C94CFFA82AF855A7AF6C2F--></OBCQL_QUERY_COLUMN> + +<!--51429339D294475986634D7E876F4A53--><OBCQL_QUERY_COLUMN> +<!--51429339D294475986634D7E876F4A53--> <OBCQL_QUERY_COLUMN_ID><![CDATA[51429339D294475986634D7E876F4A53]]></OBCQL_QUERY_COLUMN_ID> +<!--51429339D294475986634D7E876F4A53--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--51429339D294475986634D7E876F4A53--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--51429339D294475986634D7E876F4A53--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--51429339D294475986634D7E876F4A53--> <OBCQL_WIDGET_QUERY_ID><![CDATA[58BCB96595FA45678CC1423402238309]]></OBCQL_WIDGET_QUERY_ID> +<!--51429339D294475986634D7E876F4A53--> <DISPLAY_EXPRESSION><![CDATA[documentNo]]></DISPLAY_EXPRESSION> +<!--51429339D294475986634D7E876F4A53--> <NAME><![CDATA[Document Number]]></NAME> +<!--51429339D294475986634D7E876F4A53--> <WIDTH><![CDATA[100.0000]]></WIDTH> +<!--51429339D294475986634D7E876F4A53--> <LINK_EXPRESSION><![CDATA[invoiceId]]></LINK_EXPRESSION> +<!--51429339D294475986634D7E876F4A53--> <SEQNO><![CDATA[10.0000]]></SEQNO> +<!--51429339D294475986634D7E876F4A53--> <AD_REFERENCE_ID><![CDATA[10]]></AD_REFERENCE_ID> +<!--51429339D294475986634D7E876F4A53--> <INCLUDE_IN><![CDATA[W]]></INCLUDE_IN> +<!--51429339D294475986634D7E876F4A53--> <HAS_LINK><![CDATA[Y]]></HAS_LINK> +<!--51429339D294475986634D7E876F4A53--> <AD_TAB_ID><![CDATA[290]]></AD_TAB_ID> +<!--51429339D294475986634D7E876F4A53--></OBCQL_QUERY_COLUMN> + <!--538673CEF1D04E71B0D27DF9A3C34594--><OBCQL_QUERY_COLUMN> <!--538673CEF1D04E71B0D27DF9A3C34594--> <OBCQL_QUERY_COLUMN_ID><![CDATA[538673CEF1D04E71B0D27DF9A3C34594]]></OBCQL_QUERY_COLUMN_ID> <!--538673CEF1D04E71B0D27DF9A3C34594--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> @@ -63,4 +131,74 @@ <!--538673CEF1D04E71B0D27DF9A3C34594--> <HAS_LINK><![CDATA[N]]></HAS_LINK> <!--538673CEF1D04E71B0D27DF9A3C34594--></OBCQL_QUERY_COLUMN> +<!--742D993ADF7444318F8CAF38DDCB1997--><OBCQL_QUERY_COLUMN> +<!--742D993ADF7444318F8CAF38DDCB1997--> <OBCQL_QUERY_COLUMN_ID><![CDATA[742D993ADF7444318F8CAF38DDCB1997]]></OBCQL_QUERY_COLUMN_ID> +<!--742D993ADF7444318F8CAF38DDCB1997--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--742D993ADF7444318F8CAF38DDCB1997--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--742D993ADF7444318F8CAF38DDCB1997--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--742D993ADF7444318F8CAF38DDCB1997--> <OBCQL_WIDGET_QUERY_ID><![CDATA[58BCB96595FA45678CC1423402238309]]></OBCQL_WIDGET_QUERY_ID> +<!--742D993ADF7444318F8CAF38DDCB1997--> <DISPLAY_EXPRESSION><![CDATA[businessPartnerName]]></DISPLAY_EXPRESSION> +<!--742D993ADF7444318F8CAF38DDCB1997--> <NAME><![CDATA[Business Partner]]></NAME> +<!--742D993ADF7444318F8CAF38DDCB1997--> <WIDTH><![CDATA[100.0000]]></WIDTH> +<!--742D993ADF7444318F8CAF38DDCB1997--> <LINK_EXPRESSION><![CDATA[invoiceId]]></LINK_EXPRESSION> +<!--742D993ADF7444318F8CAF38DDCB1997--> <SEQNO><![CDATA[20.0000]]></SEQNO> +<!--742D993ADF7444318F8CAF38DDCB1997--> <AD_REFERENCE_ID><![CDATA[10]]></AD_REFERENCE_ID> +<!--742D993ADF7444318F8CAF38DDCB1997--> <INCLUDE_IN><![CDATA[W]]></INCLUDE_IN> +<!--742D993ADF7444318F8CAF38DDCB1997--> <HAS_LINK><![CDATA[Y]]></HAS_LINK> +<!--742D993ADF7444318F8CAF38DDCB1997--> <AD_TAB_ID><![CDATA[290]]></AD_TAB_ID> +<!--742D993ADF7444318F8CAF38DDCB1997--></OBCQL_QUERY_COLUMN> + +<!--BBBF2F44391C43F98B4FDEAF62BE81D1--><OBCQL_QUERY_COLUMN> +<!--BBBF2F44391C43F98B4FDEAF62BE81D1--> <OBCQL_QUERY_COLUMN_ID><![CDATA[BBBF2F44391C43F98B4FDEAF62BE81D1]]></OBCQL_QUERY_COLUMN_ID> +<!--BBBF2F44391C43F98B4FDEAF62BE81D1--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--BBBF2F44391C43F98B4FDEAF62BE81D1--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--BBBF2F44391C43F98B4FDEAF62BE81D1--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--BBBF2F44391C43F98B4FDEAF62BE81D1--> <OBCQL_WIDGET_QUERY_ID><![CDATA[1EF87E8E961A4E5BA3B41E1AB772B47C]]></OBCQL_WIDGET_QUERY_ID> +<!--BBBF2F44391C43F98B4FDEAF62BE81D1--> <DISPLAY_EXPRESSION><![CDATA[invoiceDate]]></DISPLAY_EXPRESSION> +<!--BBBF2F44391C43F98B4FDEAF62BE81D1--> <NAME><![CDATA[Date]]></NAME> +<!--BBBF2F44391C43F98B4FDEAF62BE81D1--> <WIDTH><![CDATA[100.0000]]></WIDTH> +<!--BBBF2F44391C43F98B4FDEAF62BE81D1--> <LINK_EXPRESSION><![CDATA[invoiceId]]></LINK_EXPRESSION> +<!--BBBF2F44391C43F98B4FDEAF62BE81D1--> <SEQNO><![CDATA[30.0000]]></SEQNO> +<!--BBBF2F44391C43F98B4FDEAF62BE81D1--> <AD_REFERENCE_ID><![CDATA[10]]></AD_REFERENCE_ID> +<!--BBBF2F44391C43F98B4FDEAF62BE81D1--> <INCLUDE_IN><![CDATA[W]]></INCLUDE_IN> +<!--BBBF2F44391C43F98B4FDEAF62BE81D1--> <HAS_LINK><![CDATA[Y]]></HAS_LINK> +<!--BBBF2F44391C43F98B4FDEAF62BE81D1--> <AD_TAB_ID><![CDATA[263]]></AD_TAB_ID> +<!--BBBF2F44391C43F98B4FDEAF62BE81D1--></OBCQL_QUERY_COLUMN> + +<!--CDC05CE5642E4327BA12FEA50597A8A3--><OBCQL_QUERY_COLUMN> +<!--CDC05CE5642E4327BA12FEA50597A8A3--> <OBCQL_QUERY_COLUMN_ID><![CDATA[CDC05CE5642E4327BA12FEA50597A8A3]]></OBCQL_QUERY_COLUMN_ID> +<!--CDC05CE5642E4327BA12FEA50597A8A3--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--CDC05CE5642E4327BA12FEA50597A8A3--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--CDC05CE5642E4327BA12FEA50597A8A3--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--CDC05CE5642E4327BA12FEA50597A8A3--> <OBCQL_WIDGET_QUERY_ID><![CDATA[1EF87E8E961A4E5BA3B41E1AB772B47C]]></OBCQL_WIDGET_QUERY_ID> +<!--CDC05CE5642E4327BA12FEA50597A8A3--> <DISPLAY_EXPRESSION><![CDATA[grandTotalAmount]]></DISPLAY_EXPRESSION> +<!--CDC05CE5642E4327BA12FEA50597A8A3--> <NAME><![CDATA[Amount]]></NAME> +<!--CDC05CE5642E4327BA12FEA50597A8A3--> <SUMMARIZE_TYPE><![CDATA[sum]]></SUMMARIZE_TYPE> +<!--CDC05CE5642E4327BA12FEA50597A8A3--> <WIDTH><![CDATA[100.0000]]></WIDTH> +<!--CDC05CE5642E4327BA12FEA50597A8A3--> <LINK_EXPRESSION><![CDATA[invoiceId]]></LINK_EXPRESSION> +<!--CDC05CE5642E4327BA12FEA50597A8A3--> <SEQNO><![CDATA[40.0000]]></SEQNO> +<!--CDC05CE5642E4327BA12FEA50597A8A3--> <AD_REFERENCE_ID><![CDATA[12]]></AD_REFERENCE_ID> +<!--CDC05CE5642E4327BA12FEA50597A8A3--> <INCLUDE_IN><![CDATA[W]]></INCLUDE_IN> +<!--CDC05CE5642E4327BA12FEA50597A8A3--> <HAS_LINK><![CDATA[Y]]></HAS_LINK> +<!--CDC05CE5642E4327BA12FEA50597A8A3--> <AD_TAB_ID><![CDATA[263]]></AD_TAB_ID> +<!--CDC05CE5642E4327BA12FEA50597A8A3--></OBCQL_QUERY_COLUMN> + +<!--FAB0DB1A67D948DB85AD5918B7845ABF--><OBCQL_QUERY_COLUMN> +<!--FAB0DB1A67D948DB85AD5918B7845ABF--> <OBCQL_QUERY_COLUMN_ID><![CDATA[FAB0DB1A67D948DB85AD5918B7845ABF]]></OBCQL_QUERY_COLUMN_ID> +<!--FAB0DB1A67D948DB85AD5918B7845ABF--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--FAB0DB1A67D948DB85AD5918B7845ABF--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--FAB0DB1A67D948DB85AD5918B7845ABF--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--FAB0DB1A67D948DB85AD5918B7845ABF--> <OBCQL_WIDGET_QUERY_ID><![CDATA[58BCB96595FA45678CC1423402238309]]></OBCQL_WIDGET_QUERY_ID> +<!--FAB0DB1A67D948DB85AD5918B7845ABF--> <DISPLAY_EXPRESSION><![CDATA[grandTotalAmount]]></DISPLAY_EXPRESSION> +<!--FAB0DB1A67D948DB85AD5918B7845ABF--> <NAME><![CDATA[Amount]]></NAME> +<!--FAB0DB1A67D948DB85AD5918B7845ABF--> <SUMMARIZE_TYPE><![CDATA[sum]]></SUMMARIZE_TYPE> +<!--FAB0DB1A67D948DB85AD5918B7845ABF--> <WIDTH><![CDATA[100.0000]]></WIDTH> +<!--FAB0DB1A67D948DB85AD5918B7845ABF--> <LINK_EXPRESSION><![CDATA[invoiceId]]></LINK_EXPRESSION> +<!--FAB0DB1A67D948DB85AD5918B7845ABF--> <SEQNO><![CDATA[40.0000]]></SEQNO> +<!--FAB0DB1A67D948DB85AD5918B7845ABF--> <AD_REFERENCE_ID><![CDATA[12]]></AD_REFERENCE_ID> +<!--FAB0DB1A67D948DB85AD5918B7845ABF--> <INCLUDE_IN><![CDATA[W]]></INCLUDE_IN> +<!--FAB0DB1A67D948DB85AD5918B7845ABF--> <HAS_LINK><![CDATA[Y]]></HAS_LINK> +<!--FAB0DB1A67D948DB85AD5918B7845ABF--> <AD_TAB_ID><![CDATA[290]]></AD_TAB_ID> +<!--FAB0DB1A67D948DB85AD5918B7845ABF--></OBCQL_QUERY_COLUMN> + </data> diff -r 72dc1aa74756 -r 1c94ebed6ca1 modules/org.openbravo.client.querylist/src-db/database/sourcedata/OBCQL_WIDGET_QUERY.xml --- a/modules/org.openbravo.client.querylist/src-db/database/sourcedata/OBCQL_WIDGET_QUERY.xml Thu Dec 23 10:22:43 2010 +0100 +++ b/modules/org.openbravo.client.querylist/src-db/database/sourcedata/OBCQL_WIDGET_QUERY.xml Thu Dec 23 10:54:19 2010 +0100 @@ -1,5 +1,43 @@ <?xml version='1.0' encoding='UTF-8'?> <data> +<!--1EF87E8E961A4E5BA3B41E1AB772B47C--><OBCQL_WIDGET_QUERY> +<!--1EF87E8E961A4E5BA3B41E1AB772B47C--> <OBCQL_WIDGET_QUERY_ID><![CDATA[1EF87E8E961A4E5BA3B41E1AB772B47C]]></OBCQL_WIDGET_QUERY_ID> +<!--1EF87E8E961A4E5BA3B41E1AB772B47C--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--1EF87E8E961A4E5BA3B41E1AB772B47C--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--1EF87E8E961A4E5BA3B41E1AB772B47C--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--1EF87E8E961A4E5BA3B41E1AB772B47C--> <OBKMO_WIDGET_CLASS_ID><![CDATA[147D825456D54D0486C3D7072531C5C9]]></OBKMO_WIDGET_CLASS_ID> +<!--1EF87E8E961A4E5BA3B41E1AB772B47C--> <HQL><![CDATA[select inv.id as invoiceId, inv.documentNo as documentNo, + inv.businessPartner.name as businessPartnerName, + inv.invoiceDate as invoiceDate, inv.grandTotalAmount as grandTotalAmount +from Invoice as inv +where inv.businessPartner.name like :businessPartnerName + and inv.documentNo like :documentNo + and inv.processed = true + and inv.paymentComplete = false + and inv.salesTransaction = true + and inv.client.id = :client +order by inv.invoiceDate]]></HQL> +<!--1EF87E8E961A4E5BA3B41E1AB772B47C--></OBCQL_WIDGET_QUERY> + +<!--58BCB96595FA45678CC1423402238309--><OBCQL_WIDGET_QUERY> +<!--58BCB96595FA45678CC1423402238309--> <OBCQL_WIDGET_QUERY_ID><![CDATA[58BCB96595FA45678CC1423402238309]]></OBCQL_WIDGET_QUERY_ID> +<!--58BCB96595FA45678CC1423402238309--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--58BCB96595FA45678CC1423402238309--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--58BCB96595FA45678CC1423402238309--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--58BCB96595FA45678CC1423402238309--> <OBKMO_WIDGET_CLASS_ID><![CDATA[34F279BBB85945519DC38F21573106C0]]></OBKMO_WIDGET_CLASS_ID> +<!--58BCB96595FA45678CC1423402238309--> <HQL><![CDATA[select inv.id as invoiceId, inv.documentNo as documentNo, + inv.businessPartner.name as businessPartnerName, + inv.invoiceDate as invoiceDate, inv.grandTotalAmount as grandTotalAmount +from Invoice as inv +where inv.businessPartner.name like :businessPartnerName + and inv.documentNo like :documentNo + and inv.processed = true + and inv.paymentComplete = false + and inv.salesTransaction = false + and inv.client.id = :client +order by inv.invoiceDate]]></HQL> +<!--58BCB96595FA45678CC1423402238309--></OBCQL_WIDGET_QUERY> + <!--C0A8491CDB43466D9F2645018473588B--><OBCQL_WIDGET_QUERY> <!--C0A8491CDB43466D9F2645018473588B--> <OBCQL_WIDGET_QUERY_ID><![CDATA[C0A8491CDB43466D9F2645018473588B]]></OBCQL_WIDGET_QUERY_ID> <!--C0A8491CDB43466D9F2645018473588B--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> diff -r 72dc1aa74756 -r 1c94ebed6ca1 modules/org.openbravo.client.querylist/src-db/database/sourcedata/OBKMO_WIDGET_CLASS.xml --- a/modules/org.openbravo.client.querylist/src-db/database/sourcedata/OBKMO_WIDGET_CLASS.xml Thu Dec 23 10:22:43 2010 +0100 +++ b/modules/org.openbravo.client.querylist/src-db/database/sourcedata/OBKMO_WIDGET_CLASS.xml Thu Dec 23 10:54:19 2010 +0100 @@ -1,5 +1,20 @@ <?xml version='1.0' encoding='UTF-8'?> <data> +<!--147D825456D54D0486C3D7072531C5C9--><OBKMO_WIDGET_CLASS> +<!--147D825456D54D0486C3D7072531C5C9--> <OBKMO_WIDGET_CLASS_ID><![CDATA[147D825456D54D0486C3D7072531C5C9]]></OBKMO_WIDGET_CLASS_ID> +<!--147D825456D54D0486C3D7072531C5C9--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--147D825456D54D0486C3D7072531C5C9--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--147D825456D54D0486C3D7072531C5C9--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--147D825456D54D0486C3D7072531C5C9--> <AD_MODULE_ID><![CDATA[0A060B2AF1974E8EAA8DB61388E9AECC]]></AD_MODULE_ID> +<!--147D825456D54D0486C3D7072531C5C9--> <TITLE><![CDATA[Invoices to collect]]></TITLE> +<!--147D825456D54D0486C3D7072531C5C9--> <HEIGHT><![CDATA[300]]></HEIGHT> +<!--147D825456D54D0486C3D7072531C5C9--> <DESCRIPTION><![CDATA[List of invoices to collect.]]></DESCRIPTION> +<!--147D825456D54D0486C3D7072531C5C9--> <ALLOW_ANONYMOUS_ACCESS><![CDATA[Y]]></ALLOW_ANONYMOUS_ACCESS> +<!--147D825456D54D0486C3D7072531C5C9--> <ISSUPERCLASS><![CDATA[N]]></ISSUPERCLASS> +<!--147D825456D54D0486C3D7072531C5C9--> <WIDGET_SUPERCLASS_ID><![CDATA[2A32CF26F3F64FE39C7F94E9D82497D1]]></WIDGET_SUPERCLASS_ID> +<!--147D825456D54D0486C3D7072531C5C9--> <CAN_MAXIMIZE><![CDATA[N]]></CAN_MAXIMIZE> +<!--147D825456D54D0486C3D7072531C5C9--></OBKMO_WIDGET_CLASS> + <!--2A32CF26F3F64FE39C7F94E9D82497D1--><OBKMO_WIDGET_CLASS> <!--2A32CF26F3F64FE39C7F94E9D82497D1--> <OBKMO_WIDGET_CLASS_ID><![CDATA[2A32CF26F3F64FE39C7F94E9D82497D1]]></OBKMO_WIDGET_CLASS_ID> <!--2A32CF26F3F64FE39C7F94E9D82497D1--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> @@ -14,6 +29,21 @@ <!--2A32CF26F3F64FE39C7F94E9D82497D1--> <CAN_MAXIMIZE><![CDATA[Y]]></CAN_MAXIMIZE> <!--2A32CF26F3F64FE39C7F94E9D82497D1--></OBKMO_WIDGET_CLASS> +<!--34F279BBB85945519DC38F21573106C0--><OBKMO_WIDGET_CLASS> +<!--34F279BBB85945519DC38F21573106C0--> <OBKMO_WIDGET_CLASS_ID><![CDATA[34F279BBB85945519DC38F21573106C0]]></OBKMO_WIDGET_CLASS_ID> +<!--34F279BBB85945519DC38F21573106C0--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--34F279BBB85945519DC38F21573106C0--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--34F279BBB85945519DC38F21573106C0--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--34F279BBB85945519DC38F21573106C0--> <AD_MODULE_ID><![CDATA[0A060B2AF1974E8EAA8DB61388E9AECC]]></AD_MODULE_ID> +<!--34F279BBB85945519DC38F21573106C0--> <TITLE><![CDATA[Invoices to pay]]></TITLE> +<!--34F279BBB85945519DC38F21573106C0--> <HEIGHT><![CDATA[300]]></HEIGHT> +<!--34F279BBB85945519DC38F21573106C0--> <DESCRIPTION><![CDATA[List of invoices to pay.]]></DESCRIPTION> +<!--34F279BBB85945519DC38F21573106C0--> <ALLOW_ANONYMOUS_ACCESS><![CDATA[Y]]></ALLOW_ANONYMOUS_ACCESS> +<!--34F279BBB85945519DC38F21573106C0--> <ISSUPERCLASS><![CDATA[N]]></ISSUPERCLASS> +<!--34F279BBB85945519DC38F21573106C0--> <WIDGET_SUPERCLASS_ID><![CDATA[2A32CF26F3F64FE39C7F94E9D82497D1]]></WIDGET_SUPERCLASS_ID> +<!--34F279BBB85945519DC38F21573106C0--> <CAN_MAXIMIZE><![CDATA[Y]]></CAN_MAXIMIZE> +<!--34F279BBB85945519DC38F21573106C0--></OBKMO_WIDGET_CLASS> + <!--D1E4261099AE4095B2F2DAEE0F7E7784--><OBKMO_WIDGET_CLASS> <!--D1E4261099AE4095B2F2DAEE0F7E7784--> <OBKMO_WIDGET_CLASS_ID><![CDATA[D1E4261099AE4095B2F2DAEE0F7E7784]]></OBKMO_WIDGET_CLASS_ID> <!--D1E4261099AE4095B2F2DAEE0F7E7784--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> diff -r 72dc1aa74756 -r 1c94ebed6ca1 modules/org.openbravo.client.querylist/src-db/database/sourcedata/OBUIAPP_PARAMETER.xml --- a/modules/org.openbravo.client.querylist/src-db/database/sourcedata/OBUIAPP_PARAMETER.xml Thu Dec 23 10:22:43 2010 +0100 +++ b/modules/org.openbravo.client.querylist/src-db/database/sourcedata/OBUIAPP_PARAMETER.xml Thu Dec 23 10:54:19 2010 +0100 @@ -1,5 +1,24 @@ <?xml version='1.0' encoding='UTF-8'?> <data> +<!--2961D075BBA04BC09FF763BA94B5D0C6--><OBUIAPP_PARAMETER> +<!--2961D075BBA04BC09FF763BA94B5D0C6--> <OBUIAPP_PARAMETER_ID><![CDATA[2961D075BBA04BC09FF763BA94B5D0C6]]></OBUIAPP_PARAMETER_ID> +<!--2961D075BBA04BC09FF763BA94B5D0C6--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--2961D075BBA04BC09FF763BA94B5D0C6--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--2961D075BBA04BC09FF763BA94B5D0C6--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--2961D075BBA04BC09FF763BA94B5D0C6--> <AD_MODULE_ID><![CDATA[0A060B2AF1974E8EAA8DB61388E9AECC]]></AD_MODULE_ID> +<!--2961D075BBA04BC09FF763BA94B5D0C6--> <NAME><![CDATA[Number of Rows]]></NAME> +<!--2961D075BBA04BC09FF763BA94B5D0C6--> <SEQNO><![CDATA[0]]></SEQNO> +<!--2961D075BBA04BC09FF763BA94B5D0C6--> <AD_REFERENCE_ID><![CDATA[12]]></AD_REFERENCE_ID> +<!--2961D075BBA04BC09FF763BA94B5D0C6--> <COLUMNNAME><![CDATA[rowsNumber]]></COLUMNNAME> +<!--2961D075BBA04BC09FF763BA94B5D0C6--> <ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED> +<!--2961D075BBA04BC09FF763BA94B5D0C6--> <FIELDLENGTH><![CDATA[10]]></FIELDLENGTH> +<!--2961D075BBA04BC09FF763BA94B5D0C6--> <ISMANDATORY><![CDATA[Y]]></ISMANDATORY> +<!--2961D075BBA04BC09FF763BA94B5D0C6--> <DEFAULTVALUE><![CDATA[10]]></DEFAULTVALUE> +<!--2961D075BBA04BC09FF763BA94B5D0C6--> <ISFIXED><![CDATA[N]]></ISFIXED> +<!--2961D075BBA04BC09FF763BA94B5D0C6--> <EVALUATEFIXEDVALUE><![CDATA[N]]></EVALUATEFIXEDVALUE> +<!--2961D075BBA04BC09FF763BA94B5D0C6--> <EM_OBKMO_WIDGET_CLASS_ID><![CDATA[34F279BBB85945519DC38F21573106C0]]></EM_OBKMO_WIDGET_CLASS_ID> +<!--2961D075BBA04BC09FF763BA94B5D0C6--></OBUIAPP_PARAMETER> + <!--3A93E12C289149CCB2CD1ECA2643469C--><OBUIAPP_PARAMETER> <!--3A93E12C289149CCB2CD1ECA2643469C--> <OBUIAPP_PARAMETER_ID><![CDATA[3A93E12C289149CCB2CD1ECA2643469C]]></OBUIAPP_PARAMETER_ID> <!--3A93E12C289149CCB2CD1ECA2643469C--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> @@ -39,6 +58,44 @@ <!--3C7A51E5281F418589AEBA8EE8659A1C--> <EM_OBKMO_WIDGET_CLASS_ID><![CDATA[D1E4261099AE4095B2F2DAEE0F7E7784]]></EM_OBKMO_WIDGET_CLASS_ID> <!--3C7A51E5281F418589AEBA8EE8659A1C--></OBUIAPP_PARAMETER> +<!--7DF9ECB3B365453AB0F18978049477C1--><OBUIAPP_PARAMETER> +<!--7DF9ECB3B365453AB0F18978049477C1--> <OBUIAPP_PARAMETER_ID><![CDATA[7DF9ECB3B365453AB0F18978049477C1]]></OBUIAPP_PARAMETER_ID> +<!--7DF9ECB3B365453AB0F18978049477C1--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--7DF9ECB3B365453AB0F18978049477C1--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--7DF9ECB3B365453AB0F18978049477C1--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--7DF9ECB3B365453AB0F18978049477C1--> <AD_MODULE_ID><![CDATA[0A060B2AF1974E8EAA8DB61388E9AECC]]></AD_MODULE_ID> +<!--7DF9ECB3B365453AB0F18978049477C1--> <NAME><![CDATA[Document Number]]></NAME> +<!--7DF9ECB3B365453AB0F18978049477C1--> <SEQNO><![CDATA[10]]></SEQNO> +<!--7DF9ECB3B365453AB0F18978049477C1--> <AD_REFERENCE_ID><![CDATA[10]]></AD_REFERENCE_ID> +<!--7DF9ECB3B365453AB0F18978049477C1--> <COLUMNNAME><![CDATA[documentNo]]></COLUMNNAME> +<!--7DF9ECB3B365453AB0F18978049477C1--> <ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED> +<!--7DF9ECB3B365453AB0F18978049477C1--> <FIELDLENGTH><![CDATA[60]]></FIELDLENGTH> +<!--7DF9ECB3B365453AB0F18978049477C1--> <ISMANDATORY><![CDATA[Y]]></ISMANDATORY> +<!--7DF9ECB3B365453AB0F18978049477C1--> <DEFAULTVALUE><![CDATA[%]]></DEFAULTVALUE> +<!--7DF9ECB3B365453AB0F18978049477C1--> <ISFIXED><![CDATA[N]]></ISFIXED> ------------------------------------------------------------------------------ Learn how Oracle Real Application Clusters (RAC) One Node allows customers to consolidate database storage, standardize their database environment, and, should the need arise, upgrade to a full multi-node Oracle RAC database without downtime or disruption http://p.sf.net/sfu/oracle-sfdevnl _______________________________________________ Openbravo-commits mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/openbravo-commits
