Thread Rating:
  • 1 Vote(s) - 5 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Webservice: when selecting records where UI10 field is empty
#1
When you have a webservice query, and you want to select records from a module where a certain UI10 field is empty use:

PHP Code:
select from purchaseorder where po_related_soid 15x0 

Where 15 is the webservice ID for the module of the UI10 field (in this case salesorders). Then use the 'x', and add a 0.
'po_related_soid' is a placeholder for the fieldname you want to check on, replace that with your own. Of course also replace the module name with your own.
Reply
#2
Thanks!!

http://corebos.org/documentation/doku.php?id=en:devel:corebosws:querylanguage#searching_for_empty_relations
Joe
TSolucio
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)