+- CoreBOSBB (https://discussions.corebos.org)
+-- Forum: Development (https://discussions.corebos.org/forumdisplay.php?fid=18)
+--- Forum: coreBOS Development (https://discussions.corebos.org/forumdisplay.php?fid=4)
+--- Thread: Webservice: when selecting records where UI10 field is empty (/showthread.php?tid=912)
Webservice: when selecting records where UI10 field is empty - Guido1982 - 02-23-2018
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.
RE: Webservice: when selecting records where UI10 field is empty - joebordes - 02-23-2018
Thanks!!
http://corebos.org/documentation/doku.php?id=en:devel:corebosws:querylanguage#searching_for_empty_relations