Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Archived » BIRT » statement return empty fields
statement return empty fields [message #1457612] Fri, 31 October 2014 14:09 Go to next message
Ihar Rubanovich is currently offline Ihar RubanovichFriend
Messages: 3
Registered: October 2014
Junior Member
Good day.
I have statment :
select public.warehouse_item_types.title, public.warehouse_item_units.code, 
 public.warehouse_document_operation_entries.amount,public.warehouse_document_operation_entries.price,
 public.warehouse_document_operation_entries.cost,public.vat_rate.value,public.warehouse_document_operation_entries.sum_vat_rate,
 public.warehouse_document_operation_entries.cost_with_vat
from public.warehouse_item_types, public.warehouse_item_units,public.warehouse_document_operation_entries,public.vat_rate
where public.warehouse_item_types.id in 
(select public.warehouse_operation_entries.warehouse_item_type_id
from public.warehouse_operation_entries 
where public.warehouse_operation_entries.warehouse_operation_id in 
(select public.warehouse_outgoing_goods_waybill.warehouse_operation_id 
from public.warehouse_outgoing_goods_waybill 
where public.warehouse_outgoing_goods_waybill.id = 493)) 
and public.warehouse_item_units.id = public.warehouse_item_types.units_id
and public.warehouse_document_operation_entries.warehouse_item_type_id = public.warehouse_item_types.id 
and public.vat_rate.id = public.warehouse_document_operation_entries.vat_rate_id 


It work , if I run it in PgAdminIII. But in Eclipse result is empty fields. How to adapt this statement for my report ?
Re: statement return empty fields [message #1460096 is a reply to message #1457612] Mon, 03 November 2014 07:26 Go to previous message
Ihar Rubanovich is currently offline Ihar RubanovichFriend
Messages: 3
Registered: October 2014
Junior Member
I found something strange.

this statement return results, if public.warehouse_outgoing_goods_waybill.id <= 455
somebody can explain, what i do wrong ?
Previous Topic:API problems
Next Topic:Can not start the design engine.
Goto Forum:
  


Current Time: Fri Apr 26 22:47:39 GMT 2024

Powered by FUDForum. Page generated in 0.02727 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top