Skip to Content
Oct 16, 2018 at 12:14 PM

Need a help on a query using user defined fields UDFs and the main formtype

111 Views Last edit Oct 16, 2018 at 12:15 PM 2 rev

Dear Experts

I need a help to write a query. I'm not a developper but an implementation consultant.

This my problem

I'm working on the Table: OWOR

Formtype 1: 65211, Item $[$10.0.0] (Is a combobox also with 'Planned' and 'Released' as options.

Formtype 2: -65211; item $[$U_MRP.0.0] (A user defined filds combobox : 'Pending'; 'QC'; PTL' as options

I want to write a query in SBO 9.2 that block user to change the statut Planned into Released if the statut in the UDFs is deferent from 'QC'

Please give a help

Best regards / My email