Beas - QC Measurement Blockage Reason

Answered

Ashvin Hargovind

• December 22, 2020 10:11
• Edited

Hi

I'm hoping someone can help me out here.

i have a few measurements setup with min and max ranges in the QC Inspection Plan.

When i work on a QC Order and If the value entered in the measurement is outside the range, i want the Blockage Reason field to be auto-populated.  There is only one blockage reason setup called OOR - Out of Range.

I am new to scripting and am not sure which command to use here.

Thank you.

Kind Regards
Ashvin

 

Vote

0

• Official comment

  

  Yaremi Miranda Lopez

  • January 12, 2021 14:38

  Hello Ashvin,

  As Martin mentioned, this can be achieved with beas script, he provided an example. If more assistance is needed, please feel free to send this request to your local partner.

  Best regards,
• 

  Martin Heigl

  • December 22, 2020 11:26

  I think, you speak about this field:

  

   

  Here the code

  global function dw_2_item_messwertc_itemchanged
  setvar=lc_value=<dw_2.item.messwertc.value,#.000000>
  // Delete block reason
  dw_2.item.sperrgrundid.setvalue=
  // check if outside the rang
  if <lc_value,#.000000> n< <dw_1.item.minimal.value,#.000000> or <lc_value,#.000000> n> <dw_1.item.maximal.value,#.000000> then
    // check only, if minimal not 0 and value not 9
    if <lc_value,#.000000> n> 0 and <dw_1.item.minimal.value,#.000000> <> 0 then
      dw_2.item.sperrgrundid.setvalue=OOR
    end if
  end if
  end global

   

   
• 

  Ashvin Hargovind

  • December 22, 2020 23:39

  Hi Martin

  Thank you so much.  That is great and works.

  Only issue is that the first measurement where i enter the value, the OOR doesnt get set in the Blockage reason field.  If i change the value again, it works. 

  It then also works on other measurements.

  Kind Regards
  Ashvin
• 

  Martin Heigl

  • December 23, 2020 04:19

  Hi Ashvin,

  on my side it's working fine. 
  Minimum must be not 0 and the value > 0, otherwise it doesn't work

  Can you insert the debug log?

   

  regards

   
• 

  Ashvin Hargovind

  • December 23, 2020 08:57

  Hi Martin

  here is the log text

  the first value entered was 5.40.  The blockage reason value didnt populate.  Then i changed it to 5.45 and it worked.

  0||||||command for closing stack (1-step)...||||||qs_qsftpos_edit###
  0|||BeasUsabilityPackage|||validation Click for dw_2.messwertc in window qs_qsftpos_edit||||||qs_qsftpos_edit###
  0|||globalfunction|||dw_2_click()|||qs_qsftpos_edit|||qs_qsftpos_edit###
  0|||globalfunction|||dw_2_item_messwertc_click()|||qs_qsftpos_edit|||qs_qsftpos_edit###
  0|||key|||5||||||qs_qsftpos_edit###
  0||||||syskeyclicked()|||qs_qsftpos_edit|||qs_qsftpos_edit###
  0|||key|||54||||||qs_qsftpos_edit###
  0||||||syskeyclicked()|||qs_qsftpos_edit|||qs_qsftpos_edit###
  0|||key|||540||||||qs_qsftpos_edit###
  0||||||syskeyclicked()|||qs_qsftpos_edit|||qs_qsftpos_edit###
  0|||key|||540TAB||||||qs_qsftpos_edit###
  0||||||syskeyclicked()|||qs_qsftpos_edit|||qs_qsftpos_edit###
  0||||||button redraw in program\qs_qsftpos_edit.psr||||||qs_qsftpos_edit###
  0|||.messwertc.itemchange event editstart|||if=N=J => nein:goto ||||||qs_qsftpos_edit###
  0|||.messwertc.itemchange event editstart|||goto=true||||||qs_qsftpos_edit###
  0|||tracing|||itemchanged dw_2.messwertc (<strong>Value</strong>) = <kbd>5.40</kbd>||||||qs_qsftpos_edit###
  0||||||sysitemchanged|||qs_qsftpos_edit|||qs_qsftpos_edit###
  0|||globalfunction|||dw_2_itemchanged()|||qs_qsftpos_edit|||qs_qsftpos_edit###
  0|||globalfunction|||dw_2_item_messwertc_itemchanged()|||qs_qsftpos_edit|||qs_qsftpos_edit###
  0|||BeasUsabilityPackage|||validation Validate for dw_2.messwertc in window qs_qsftpos_edit executed||||||qs_qsftpos_edit###
  1|||.itemchanged qs_qsftpos_edit.messwertc[1]|||universalfunction=beasUF-030|||qs_qsftpos_edit|||qs_qsftpos_edit###
  0|||.itemchanged qs_qsftpos_edit.messwertc[1]|||setvar=dwo-row=<il_dw1row>|||qs_qsftpos_edit|||qs_qsftpos_edit###
  0|||insertinfo:setvar=||| [[-dwo-row="5"-]] ||||||qs_qsftpos_edit###
  0|||.itemchanged qs_qsftpos_edit.messwertc[1]|||dw_1.item.messwertc:[il_dw1row].setvalue=<dw_2.item.messwertc.value>|||qs_qsftpos_edit|||qs_qsftpos_edit###
  0|||form|||setitem messwertc row 5 to 5.40||||||qs_qsftpos_edit###
  0|||globalfunction|||dw_1_itemchanged()|||qs_qsftpos_edit|||qs_qsftpos_edit###
  0|||globalfunction|||dw_1_item_messwertc_itemchanged()|||qs_qsftpos_edit|||qs_qsftpos_edit###
  0|||BeasUsabilityPackage|||validation Validate for dw_1.messwertc in window qs_qsftpos_edit||||||qs_qsftpos_edit###
  0|||.itemchanged qs_qsftpos_edit.messwertc[1]|||setmesswert()||||||qs_qsftpos_edit###
  0|||.itemchanged qs_qsftpos_edit.messwertc[1]|||goto=setmesswert()||||||qs_qsftpos_edit###
  0|||...itemchanged qs_qsftpos_edit.messwertc[1]:setmesswert|||setvar=ls_result=%len(<dw_1.item.messwertc:[il_dw1row].value>)|||qs_qsftpos_edit|||qs_qsftpos_edit###
  0||||||len([5.40],]||||||qs_qsftpos_edit###
  0|||insertinfo:setvar=||| [[-ls_result="4"-]] ||||||qs_qsftpos_edit###
  0|||...itemchanged qs_qsftpos_edit.messwertc[1]:setmesswert|||if <ls_result> n> 13 then||||||qs_qsftpos_edit###
  0|||insertinfo:if <ls_re||| [[-( "4" n> "13" ) = [[rfalse-]]-]]||||||qs_qsftpos_edit###
  0|||...itemchanged qs_qsftpos_edit.messwertc[1]:setmesswert|||else||||||qs_qsftpos_edit###
  0|||...itemchanged qs_qsftpos_edit.messwertc[1]:setmesswert|||dw_1.item.messwert:[il_dw1row].value=<dw_1.item.messwertc:[il_dw1row].value,#0.000000>|||qs_qsftpos_edit|||qs_qsftpos_edit###
  0|||...itemchanged qs_qsftpos_edit.messwertc[1]:setmesswert|||setmeasurement()||||||qs_qsftpos_edit###
  0|||...itemchanged qs_qsftpos_edit.messwertc[1]:setmesswert|||goto=setmeasurement()||||||qs_qsftpos_edit###
  0|||..nged qs_qsftpos_edit.messwertc[1]:setmesswert:setmeasurement|||dw_1.item.measurementpersid:[il_dw1row].value=<currentpers_id>|||qs_qsftpos_edit|||qs_qsftpos_edit###
  0|||form|||setitem measurementpersid row 5 to 3||||||qs_qsftpos_edit###
  0|||..nged qs_qsftpos_edit.messwertc[1]:setmesswert:setmeasurement|||dw_1.item.measurementstationid:[il_dw1row].value=<stationname>|||qs_qsftpos_edit|||qs_qsftpos_edit###
  0|||form|||setitem measurementstationid row 5 to SAPAdmin||||||qs_qsftpos_edit###
  0|||..nged qs_qsftpos_edit.messwertc[1]:setmesswert:setmeasurement|||dw_1.item.measurementdate:[il_dw1row].value=<today> <now>|||qs_qsftpos_edit|||qs_qsftpos_edit###
  0|||..nged qs_qsftpos_edit.messwertc[1]:setmesswert:setmeasurement|||dw_1.item.measurementpersname:[il_dw1row].value=<is_name>|||qs_qsftpos_edit|||qs_qsftpos_edit###
  0|||form|||setitem measurementpersname row 5 to manager manager||||||qs_qsftpos_edit###
  0|||...itemchanged qs_qsftpos_edit.messwertc[1]:setmesswert|||if <item.typ:[il_dw1row].value> = L or <item.typ:[il_dw1row].value> = T then||||||qs_qsftpos_edit###
  0|||insertinfo:if <item.t||| [[-( "" = "l" ) = [[rfalse-]]( "" = "t" ) = [[rfalse-]]-]]||||||qs_qsftpos_edit###
  0|||...itemchanged qs_qsftpos_edit.messwertc[1]:setmesswert|||dw_1.item.ok:[il_dw1row].value=N|||qs_qsftpos_edit|||qs_qsftpos_edit###
  0|||form|||setitem ok row 5 to N||||||qs_qsftpos_edit###
  0|||...itemchanged qs_qsftpos_edit.messwertc[1]:setmesswert|||dw_2.item.ok.value=N|||qs_qsftpos_edit|||qs_qsftpos_edit###
  0|||form|||setitem ok row 1 to N||||||qs_qsftpos_edit###
  0|||...itemchanged qs_qsftpos_edit.messwertc[1]:setmesswert|||setvar=e_max=<dw_1.item.maximal:[il_dw1row].value,#0.000000>|||qs_qsftpos_edit|||qs_qsftpos_edit###
  0|||insertinfo:setvar=||| [[-e_max="6.300000"-]] ||||||qs_qsftpos_edit###
  0|||...itemchanged qs_qsftpos_edit.messwertc[1]:setmesswert|||if <e_max> n= 0 and <dw_1.item.minimal:[il_dw1row].value,#0.000000> = 0 then||||||qs_qsftpos_edit###
  0|||insertinfo:if <e_max>||| [[-( "6.300000" n= "0" ) = [[rfalse-]]( "5.500000" = "0" ) = [[rfalse-]]-]]||||||qs_qsftpos_edit###
  0|||...itemchanged qs_qsftpos_edit.messwertc[1]:setmesswert|||select round(0+ <dw_1.item.messwert:[il_dw1row].value,dbnum>,<dw_1.item.beas_me_anzdez:[il_dw1row].value>) from BEAS_DUMMY|||qs_qsftpos_edit|||qs_qsftpos_edit###
  0|||sql|||select round(0+ 5.400000,2) from BEAS_DUMMY||||||qs_qsftpos_edit###
  0|||duration|||<span class="sqlInfo">31 ms, Result: wert1=5.4000 (Decimal),</span>||||||qs_qsftpos_edit###
  0|||...itemchanged qs_qsftpos_edit.messwertc[1]:setmesswert|||setvar=ld_value=<wert1>|||qs_qsftpos_edit|||qs_qsftpos_edit###
  0|||insertinfo:setvar=||| [[-ld_value="5.400000"-]] ||||||qs_qsftpos_edit###
  0|||...itemchanged qs_qsftpos_edit.messwertc[1]:setmesswert|||if <ld_value> n>= <dw_1.item.minimal:[il_dw1row].value,#0.000000> and <ld_value> n<= <e_max,#0.000000> and <dw_1.item.beas_qssperrgrund_blockok:[il_dw1row].value> n<> 1 then||||||qs_qsftpos_edit###
  0|||insertinfo:if <ld_val||| [[-( "5.400000" n>= "5.500000" ) = [[rfalse-]]( "5.400000" n<= "6.300000" ) = [[gtrue-]]( "0" n<> "1" ) = [[gtrue-]]-]]||||||qs_qsftpos_edit###
  0|||...itemchanged qs_qsftpos_edit.messwertc[1]:setmesswert|||setrelease()||||||qs_qsftpos_edit###
  0|||...itemchanged qs_qsftpos_edit.messwertc[1]:setmesswert|||goto=setrelease()||||||qs_qsftpos_edit###
  0|||..nged qs_qsftpos_edit.messwertc[1]:setmesswert:setrelease|||if <dw_1.item.releaseautomatic:[il_dw1row].value> n= 1 and <dw_1.item.ok:[il_dw1row].value> = J then||||||qs_qsftpos_edit###
  0|||insertinfo:if <dw_1.i||| [[-( "1" n= "1" ) = [[gtrue-]]( "n" = "j" ) = [[rfalse-]]-]]||||||qs_qsftpos_edit###
  0|||..nged qs_qsftpos_edit.messwertc[1]:setmesswert:setrelease|||if <dw_2.item.release:1.value> = 0 then||||||qs_qsftpos_edit###
  0|||insertinfo:if <dw_2.i||| [[-( "0" = "0" ) = [[gtrue-]]-]]||||||qs_qsftpos_edit###
  0|||..nged qs_qsftpos_edit.messwertc[1]:setmesswert:setrelease|||dw_1.item.release:[il_dw1row].value=0|||qs_qsftpos_edit|||qs_qsftpos_edit###
  0|||..nged qs_qsftpos_edit.messwertc[1]:setmesswert:setrelease|||return true||||||qs_qsftpos_edit###
  0|||...itemchanged qs_qsftpos_edit.messwertc[1]:setmesswert|||return true||||||qs_qsftpos_edit###
  0|||globalfunction|||itemchangeuser()|||qs_qsftpos_edit|||qs_qsftpos_edit###
  0|||.itemchanged qs_qsftpos_edit.messwertc[1]|||dynamicobject=send=itemchanged=messwertc|||qs_qsftpos_edit|||qs_qsftpos_edit###
  0|||.itemchanged qs_qsftpos_edit.messwertc[1]|||iqs=scale=view|||qs_qsftpos_edit|||qs_qsftpos_edit###
  0|||.itemchanged qs_qsftpos_edit.messwertc[1]|||return true||||||qs_qsftpos_edit###
  0|||globalfunction|||itemchangeuser()|||qs_qsftpos_edit|||qs_qsftpos_edit###
  0|||.itemchanged qs_qsftpos_edit.messwertc[1]|||dynamicobject=send=itemchanged=messwertc|||qs_qsftpos_edit|||qs_qsftpos_edit###
  0|||itemfocuschanged|||set focus from messwertc to sperrgrundid||||||qs_qsftpos_edit###
  0|||BeasUsabilityPackage|||validation GotFocus for dw_2.sperrgrundid in window qs_qsftpos_edit||||||qs_qsftpos_edit###
  0|||stack|||postsysitemchanged|||qs_qsftpos_edit|||qs_qsftpos_edit###
  0|||itemchanged|||Is executed. Don't execute second time!||||||qs_qsftpos_edit###
  0|||stack|||dw_2.item.messwertc.redraw|||qs_qsftpos_edit|||qs_qsftpos_edit###
  0|||stack|||dw_1.item.messwertc.redraw|||qs_qsftpos_edit|||qs_qsftpos_edit###
  0||||||command for closing stack (1-step)...||||||qs_qsftpos_edit###
  0|||BeasUsabilityPackage|||validation Click for dw_2.messwertc in window qs_qsftpos_edit||||||qs_qsftpos_edit###
  0|||globalfunction|||dw_2_click()|||qs_qsftpos_edit|||qs_qsftpos_edit###
  0|||globalfunction|||dw_2_item_messwertc_click()|||qs_qsftpos_edit|||qs_qsftpos_edit###
  0|||itemfocuschanged|||set focus from sperrgrundid to messwertc||||||qs_qsftpos_edit###
  0|||BeasUsabilityPackage|||validation GotFocus for dw_2.messwertc in window qs_qsftpos_edit||||||qs_qsftpos_edit###
  0|||key|||40TAB5||||||qs_qsftpos_edit###
  0||||||syskeyclicked()|||qs_qsftpos_edit|||qs_qsftpos_edit###
  0|||key|||0TAB54||||||qs_qsftpos_edit###
  0||||||syskeyclicked()|||qs_qsftpos_edit|||qs_qsftpos_edit###
  0|||key|||TAB545||||||qs_qsftpos_edit###
  0||||||syskeyclicked()|||qs_qsftpos_edit|||qs_qsftpos_edit###
  0|||key|||545TAB||||||qs_qsftpos_edit###
  0||||||syskeyclicked()|||qs_qsftpos_edit|||qs_qsftpos_edit###
  0|||tracing|||itemchanged dw_2.messwertc (<strong>Value</strong>) = <kbd>5.45</kbd>||||||qs_qsftpos_edit###
  0||||||sysitemchanged|||qs_qsftpos_edit|||qs_qsftpos_edit###
  0|||globalfunction|||dw_2_itemchanged()|||qs_qsftpos_edit|||qs_qsftpos_edit###
  1|||globalfunction|||dw_2_item_messwertc_itemchanged() [[gexecuting-]]|||qs_qsftpos_edit|||qs_qsftpos_edit###
  1|||.itemchanged qs_qsftpos_edit.messwertc[1]|||setvar=lc_value=<dw_2.item.messwertc.value,#.000000>|||qs_qsftpos_edit|||qs_qsftpos_edit###
  0|||insertinfo:setvar=||| [[-lc_value="5.450000"-]] ||||||qs_qsftpos_edit###
  1|||.itemchanged qs_qsftpos_edit.messwertc[1]|||dw_2.item.sperrgrundid.setvalue=|||qs_qsftpos_edit|||qs_qsftpos_edit###
  0|||form|||setitem sperrgrundid row 1 to ||||||qs_qsftpos_edit###
  0|||globalfunction|||dw_2_itemchanged()|||qs_qsftpos_edit|||qs_qsftpos_edit###
  0|||globalfunction|||dw_2_item_sperrgrundid_itemchanged()|||qs_qsftpos_edit|||qs_qsftpos_edit###
  0|||BeasUsabilityPackage|||validation Validate for dw_2.sperrgrundid in window qs_qsftpos_edit||||||qs_qsftpos_edit###
  0|||.itemchanged qs_qsftpos_edit.messwertc[1]|||accepttext|||qs_qsftpos_edit|||qs_qsftpos_edit###
  0|||stack|||postsysitemchanged|||qs_qsftpos_edit|||qs_qsftpos_edit###
  0|||itemchanged|||Is executed. Don't execute second time!||||||qs_qsftpos_edit###
  0|||stack|||dw_2.item.messwertc.redraw|||qs_qsftpos_edit|||qs_qsftpos_edit###
  0|||stack|||dw_2.item.sperrgrundid.redraw|||qs_qsftpos_edit|||qs_qsftpos_edit###
  0||||||setvar=dwo-row=<il_dw1row>|||qs_qsftpos_edit|||qs_qsftpos_edit###
  0|||insertinfo:setvar=||| [[-dwo-row="5"-]] ||||||qs_qsftpos_edit###
  0||||||select "SPERRGRUND","COLORID","BITMAP","BlockOk" into dw_2.item.sperrgrund,dw_1.item.beas_qssperrgrund_colorid,dw_1.item.beas_qssperrgrund_bitmap,dw_1.item.beas_qssperrgrund_blockok from "BEAS_QSSPERRGRUND" where "SPERRGRUNDID"=<dw_2.item.sperrgrundid.value,dbstring>|||qs_qsftpos_edit|||qs_qsftpos_edit###
  0|||sql|||select "SPERRGRUND","COLORID","BITMAP","BlockOk" from "BEAS_QSSPERRGRUND" where "SPERRGRUNDID"=N''||||||qs_qsftpos_edit###
  0|||duration|||<span class="sqlInfo">16 ms, <span style="color:red">No result</span></span>||||||qs_qsftpos_edit###
  0||||||dw_1.item.sperrgrund:[il_dw1row].setvalue=<dw_2.item.sperrgrund:1.value>|||qs_qsftpos_edit|||qs_qsftpos_edit###
  0|||form|||setitem sperrgrund row 5 to ||||||qs_qsftpos_edit###
  0|||globalfunction|||dw_1_itemchanged()|||qs_qsftpos_edit|||qs_qsftpos_edit###
  0|||globalfunction|||dw_1_item_sperrgrund_itemchanged()|||qs_qsftpos_edit|||qs_qsftpos_edit###
  0|||BeasUsabilityPackage|||validation Validate for dw_1.sperrgrund in window qs_qsftpos_edit||||||qs_qsftpos_edit###
  0|||globalfunction|||itemchangeuser()|||qs_qsftpos_edit|||qs_qsftpos_edit###
  0||||||dynamicobject=send=itemchanged=sperrgrund|||qs_qsftpos_edit|||qs_qsftpos_edit###
  0||||||dw_1.item.sperrgrundid:[il_dw1row].value=<dw_2.item.sperrgrundid:1.value>|||qs_qsftpos_edit|||qs_qsftpos_edit###
  0|||form|||setitem sperrgrundid row 5 to ||||||qs_qsftpos_edit###
  0||||||if <dw_1.item.beas_qssperrgrund_blockok:[il_dw1row].value> n= 1 then||||||qs_qsftpos_edit###
  0|||insertinfo:if <dw_1.i||| [[-( "0" n= "1" ) = [[rfalse-]]-]]||||||qs_qsftpos_edit###
  0||||||if <dw_2.item.messwertc.value> <> then||||||qs_qsftpos_edit###
  0|||insertinfo:if <dw_2.i||| [[-( "5.45" <> "" ) = [[gtrue-]]-]]||||||qs_qsftpos_edit###
  0||||||setmesswert()||||||qs_qsftpos_edit###
  0||||||goto=setmesswert()||||||qs_qsftpos_edit###
  0|||..:setmesswert|||setvar=ls_result=%len(<dw_1.item.messwertc:[il_dw1row].value>)|||qs_qsftpos_edit|||qs_qsftpos_edit###
  0||||||len([5.40],]||||||qs_qsftpos_edit###
  0|||insertinfo:setvar=||| [[-ls_result="4"-]] ||||||qs_qsftpos_edit###
  0|||..:setmesswert|||if <ls_result> n> 13 then||||||qs_qsftpos_edit###
  0|||insertinfo:if <ls_re||| [[-( "4" n> "13" ) = [[rfalse-]]-]]||||||qs_qsftpos_edit###
  0|||..:setmesswert|||else||||||qs_qsftpos_edit###
  0|||..:setmesswert|||dw_1.item.messwert:[il_dw1row].value=<dw_1.item.messwertc:[il_dw1row].value,#0.000000>|||qs_qsftpos_edit|||qs_qsftpos_edit###
  0|||..:setmesswert|||setmeasurement()||||||qs_qsftpos_edit###
  0|||..:setmesswert|||goto=setmeasurement()||||||qs_qsftpos_edit###
  0|||....:setmesswert:setmeasurement|||dw_1.item.measurementpersid:[il_dw1row].value=<currentpers_id>|||qs_qsftpos_edit|||qs_qsftpos_edit###
  0|||form|||setitem measurementpersid row 5 to 3||||||qs_qsftpos_edit###
  0|||....:setmesswert:setmeasurement|||dw_1.item.measurementstationid:[il_dw1row].value=<stationname>|||qs_qsftpos_edit|||qs_qsftpos_edit###
  0|||form|||setitem measurementstationid row 5 to SAPAdmin||||||qs_qsftpos_edit###
  0|||....:setmesswert:setmeasurement|||dw_1.item.measurementdate:[il_dw1row].value=<today> <now>|||qs_qsftpos_edit|||qs_qsftpos_edit###
  0|||....:setmesswert:setmeasurement|||dw_1.item.measurementpersname:[il_dw1row].value=<is_name>|||qs_qsftpos_edit|||qs_qsftpos_edit###
  0|||form|||setitem measurementpersname row 5 to manager manager||||||qs_qsftpos_edit###
  0|||..:setmesswert|||if <item.typ:[il_dw1row].value> = L or <item.typ:[il_dw1row].value> = T then||||||qs_qsftpos_edit###
  0|||insertinfo:if <item.t||| [[-( "" = "l" ) = [[rfalse-]]( "" = "t" ) = [[rfalse-]]-]]||||||qs_qsftpos_edit###
  0|||..:setmesswert|||dw_1.item.ok:[il_dw1row].value=N|||qs_qsftpos_edit|||qs_qsftpos_edit###
  0|||form|||setitem ok row 5 to N||||||qs_qsftpos_edit###
  0|||..:setmesswert|||dw_2.item.ok.value=N|||qs_qsftpos_edit|||qs_qsftpos_edit###
  0|||form|||setitem ok row 1 to N||||||qs_qsftpos_edit###
  0|||..:setmesswert|||setvar=e_max=<dw_1.item.maximal:[il_dw1row].value,#0.000000>|||qs_qsftpos_edit|||qs_qsftpos_edit###
  0|||insertinfo:setvar=||| [[-e_max="6.300000"-]] ||||||qs_qsftpos_edit###
  0|||..:setmesswert|||if <e_max> n= 0 and <dw_1.item.minimal:[il_dw1row].value,#0.000000> = 0 then||||||qs_qsftpos_edit###
  0|||insertinfo:if <e_max>||| [[-( "6.300000" n= "0" ) = [[rfalse-]]( "5.500000" = "0" ) = [[rfalse-]]-]]||||||qs_qsftpos_edit###
  0|||..:setmesswert|||select round(0+ <dw_1.item.messwert:[il_dw1row].value,dbnum>,<dw_1.item.beas_me_anzdez:[il_dw1row].value>) from BEAS_DUMMY|||qs_qsftpos_edit|||qs_qsftpos_edit###
  0|||sql|||select round(0+ 5.400000,2) from BEAS_DUMMY||||||qs_qsftpos_edit###
  0|||duration|||<span class="sqlInfo">0 ms, Result: wert1=5.4000 (Decimal),</span>||||||qs_qsftpos_edit###
  0|||..:setmesswert|||setvar=ld_value=<wert1>|||qs_qsftpos_edit|||qs_qsftpos_edit###
  0|||insertinfo:setvar=||| [[-ld_value="5.400000"-]] ||||||qs_qsftpos_edit###
  0|||..:setmesswert|||if <ld_value> n>= <dw_1.item.minimal:[il_dw1row].value,#0.000000> and <ld_value> n<= <e_max,#0.000000> and <dw_1.item.beas_qssperrgrund_blockok:[il_dw1row].value> n<> 1 then||||||qs_qsftpos_edit###
  0|||insertinfo:if <ld_val||| [[-( "5.400000" n>= "5.500000" ) = [[rfalse-]]( "5.400000" n<= "6.300000" ) = [[gtrue-]]( "0" n<> "1" ) = [[gtrue-]]-]]||||||qs_qsftpos_edit###
  0|||..:setmesswert|||setrelease()||||||qs_qsftpos_edit###
  0|||..:setmesswert|||goto=setrelease()||||||qs_qsftpos_edit###
  0|||....:setmesswert:setrelease|||if <dw_1.item.releaseautomatic:[il_dw1row].value> n= 1 and <dw_1.item.ok:[il_dw1row].value> = J then||||||qs_qsftpos_edit###
  0|||insertinfo:if <dw_1.i||| [[-( "1" n= "1" ) = [[gtrue-]]( "n" = "j" ) = [[rfalse-]]-]]||||||qs_qsftpos_edit###
  0|||....:setmesswert:setrelease|||if <dw_2.item.release:1.value> = 0 then||||||qs_qsftpos_edit###
  0|||insertinfo:if <dw_2.i||| [[-( "0" = "0" ) = [[gtrue-]]-]]||||||qs_qsftpos_edit###
  0|||....:setmesswert:setrelease|||dw_1.item.release:[il_dw1row].value=0|||qs_qsftpos_edit|||qs_qsftpos_edit###
  0|||....:setmesswert:setrelease|||return true||||||qs_qsftpos_edit###
  0|||..:setmesswert|||return true||||||qs_qsftpos_edit###
  0|||globalfunction|||itemchangeuser()|||qs_qsftpos_edit|||qs_qsftpos_edit###
  0|||.itemchanged qs_qsftpos_edit.messwertc[1]|||dynamicobject=send=itemchanged=sperrgrundid|||qs_qsftpos_edit|||qs_qsftpos_edit###
  1|||.itemchanged qs_qsftpos_edit.messwertc[1]|||if <lc_value,#.000000> n< <dw_1.item.minimal.value,#.000000> or <lc_value,#.000000> n> <dw_1.item.maximal.value,#.000000> then||||||qs_qsftpos_edit###
  1|||insertinfo:if <lc_val||| [[-( "5.450000" n< "5.500000" ) = [[gtrue-]]( "5.450000" n> "6.300000" ) = [[rfalse-]]-]]||||||qs_qsftpos_edit###
  1|||.itemchanged qs_qsftpos_edit.messwertc[1]|||if <lc_value,#.000000> n> 0 and <dw_1.item.minimal.value,#.000000> <> 0 then||||||qs_qsftpos_edit###
  1|||insertinfo:if <lc_val||| [[-( "5.450000" n> "0" ) = [[gtrue-]]( "5.500000" <> "0" ) = [[gtrue-]]-]]||||||qs_qsftpos_edit###
  1|||.itemchanged qs_qsftpos_edit.messwertc[1]|||dw_2.item.sperrgrundid.setvalue=OOR|||qs_qsftpos_edit|||qs_qsftpos_edit###
  0|||form|||setitem sperrgrundid row 1 to OOR||||||qs_qsftpos_edit###
  0|||globalfunction|||dw_2_itemchanged()|||qs_qsftpos_edit|||qs_qsftpos_edit###
  0|||globalfunction|||dw_2_item_sperrgrundid_itemchanged()|||qs_qsftpos_edit|||qs_qsftpos_edit###
  0|||BeasUsabilityPackage|||validation Validate for dw_2.sperrgrundid in window qs_qsftpos_edit||||||qs_qsftpos_edit###
  0|||.itemchanged qs_qsftpos_edit.messwertc[1]|||accepttext|||qs_qsftpos_edit|||qs_qsftpos_edit###
  0|||stack|||dw_1.item.sperrgrund.redraw|||qs_qsftpos_edit|||qs_qsftpos_edit###
  0|||stack|||dw_2.item.sperrgrundid.redraw|||qs_qsftpos_edit|||qs_qsftpos_edit###
  0||||||setvar=dwo-row=<il_dw1row>|||qs_qsftpos_edit|||qs_qsftpos_edit###
  0|||insertinfo:setvar=||| [[-dwo-row="5"-]] ||||||qs_qsftpos_edit###
  0||||||select "SPERRGRUND","COLORID","BITMAP","BlockOk" into dw_2.item.sperrgrund,dw_1.item.beas_qssperrgrund_colorid,dw_1.item.beas_qssperrgrund_bitmap,dw_1.item.beas_qssperrgrund_blockok from "BEAS_QSSPERRGRUND" where "SPERRGRUNDID"=<dw_2.item.sperrgrundid.value,dbstring>|||qs_qsftpos_edit|||qs_qsftpos_edit###
  0|||sql|||select "SPERRGRUND","COLORID","BITMAP","BlockOk" from "BEAS_QSSPERRGRUND" where "SPERRGRUNDID"=N'OOR'||||||qs_qsftpos_edit###
  0|||duration|||<span class="sqlInfo">0 ms, Result: dw_2.item.sperrgrund=Out of Range value (CHAR),dw_1.item.beas_qssperrgrund_colorid=0.0000 (Long),dw_1.item.beas_qssperrgrund_bitmap=bmp\gfx\small_standstillok.png (CHAR),dw_1.item.beas_qssperrgrund_blockok=1.0000 (Long),</span>||||||qs_qsftpos_edit###
  0||||||dw_1.item.sperrgrund:[il_dw1row].setvalue=<dw_2.item.sperrgrund:1.value>|||qs_qsftpos_edit|||qs_qsftpos_edit###
  0|||form|||setitem sperrgrund row 5 to Out of Range value||||||qs_qsftpos_edit###
  0|||globalfunction|||dw_1_itemchanged()|||qs_qsftpos_edit|||qs_qsftpos_edit###
  0|||globalfunction|||dw_1_item_sperrgrund_itemchanged()|||qs_qsftpos_edit|||qs_qsftpos_edit###
  0|||BeasUsabilityPackage|||validation Validate for dw_1.sperrgrund in window qs_qsftpos_edit||||||qs_qsftpos_edit###
  0|||globalfunction|||itemchangeuser()|||qs_qsftpos_edit|||qs_qsftpos_edit###
  0||||||dynamicobject=send=itemchanged=sperrgrund|||qs_qsftpos_edit|||qs_qsftpos_edit###
  0||||||dw_1.item.sperrgrundid:[il_dw1row].value=<dw_2.item.sperrgrundid:1.value>|||qs_qsftpos_edit|||qs_qsftpos_edit###
  0|||form|||setitem sperrgrundid row 5 to OOR||||||qs_qsftpos_edit###
  0||||||if <dw_1.item.beas_qssperrgrund_blockok:[il_dw1row].value> n= 1 then||||||qs_qsftpos_edit###
  0|||insertinfo:if <dw_1.i||| [[-( "1" n= "1" ) = [[gtrue-]]-]]||||||qs_qsftpos_edit###
  0||||||dw_2.item.ok.value=N|||qs_qsftpos_edit|||qs_qsftpos_edit###
  0|||form|||setitem ok row 1 to N||||||qs_qsftpos_edit###
  0||||||dw_1.item.ok:[il_dw1row].value=N|||qs_qsftpos_edit|||qs_qsftpos_edit###
  0|||form|||setitem ok row 5 to N||||||qs_qsftpos_edit###
  0||||||dw_1.item.release:[il_dw1row].value=0|||qs_qsftpos_edit|||qs_qsftpos_edit###
  0||||||dw_2.item.release.value=0|||qs_qsftpos_edit|||qs_qsftpos_edit###
  0||||||setuser()||||||qs_qsftpos_edit###
  0||||||goto=setuser()||||||qs_qsftpos_edit###
  0|||..:setuser|||dw_1.item.measurementpersid:[dwo-row].value=<currentpers_id>|||qs_qsftpos_edit|||qs_qsftpos_edit###
  0|||form|||setitem measurementpersid row 5 to 3||||||qs_qsftpos_edit###
  0|||..:setuser|||dw_1.item.measurementstationid:[dwo-row].value=<stationname>|||qs_qsftpos_edit|||qs_qsftpos_edit###
  0|||form|||setitem measurementstationid row 5 to SAPAdmin||||||qs_qsftpos_edit###
  0|||..:setuser|||dw_1.item.measurementdate:[dwo-row].value=<today> <now>|||qs_qsftpos_edit|||qs_qsftpos_edit###
  0|||..:setuser|||dw_1.item.measurementpersname:[dwo-row].value=<is_name>|||qs_qsftpos_edit|||qs_qsftpos_edit###
  0|||form|||setitem measurementpersname row 5 to manager manager||||||qs_qsftpos_edit###
  0||||||return true||||||qs_qsftpos_edit###
  0|||globalfunction|||itemchangeuser()|||qs_qsftpos_edit|||qs_qsftpos_edit###
  0|||.itemchanged qs_qsftpos_edit.messwertc[1]|||dynamicobject=send=itemchanged=sperrgrundid|||qs_qsftpos_edit|||qs_qsftpos_edit###
  0|||globalfunction|||dw_2_item_messwertc_itemchanged()|||qs_qsftpos_edit|||qs_qsftpos_edit###
  0|||BeasUsabilityPackage|||validation Validate for dw_1.messwertc in window qs_qsftpos_edit||||||qs_qsftpos_edit###
  0|||.itemchanged qs_qsftpos_edit.messwertc[1]|||setvar=dwo-row=<il_dw1row>|||qs_qsftpos_edit|||qs_qsftpos_edit###
  0|||insertinfo:setvar=||| [[-dwo-row="5"-]] ||||||qs_qsftpos_edit###
  0|||.itemchanged qs_qsftpos_edit.messwertc[1]|||dw_1.item.messwertc:[il_dw1row].setvalue=<dw_2.item.messwertc.value>|||qs_qsftpos_edit|||qs_qsftpos_edit###
  0|||form|||setitem messwertc row 5 to 5.45||||||qs_qsftpos_edit###
  0|||globalfunction|||dw_1_itemchanged()|||qs_qsftpos_edit|||qs_qsftpos_edit###
  0|||globalfunction|||dw_1_item_messwertc_itemchanged()|||qs_qsftpos_edit|||qs_qsftpos_edit###
  0|||BeasUsabilityPackage|||validation Validate for dw_1.messwertc in window qs_qsftpos_edit||||||qs_qsftpos_edit###
  0|||.itemchanged qs_qsftpos_edit.messwertc[1]|||setmesswert()||||||qs_qsftpos_edit###
  0|||.itemchanged qs_qsftpos_edit.messwertc[1]|||goto=setmesswert()||||||qs_qsftpos_edit###
  0|||...itemchanged qs_qsftpos_edit.messwertc[1]:setmesswert|||setvar=ls_result=%len(<dw_1.item.messwertc:[il_dw1row].value>)|||qs_qsftpos_edit|||qs_qsftpos_edit###
  0||||||len([5.45],]||||||qs_qsftpos_edit###
  0|||insertinfo:setvar=||| [[-ls_result="4"-]] ||||||qs_qsftpos_edit###
  0|||...itemchanged qs_qsftpos_edit.messwertc[1]:setmesswert|||if <ls_result> n> 13 then||||||qs_qsftpos_edit###
  0|||insertinfo:if <ls_re||| [[-( "4" n> "13" ) = [[rfalse-]]-]]||||||qs_qsftpos_edit###
  0|||...itemchanged qs_qsftpos_edit.messwertc[1]:setmesswert|||else||||||qs_qsftpos_edit###
  0|||...itemchanged qs_qsftpos_edit.messwertc[1]:setmesswert|||dw_1.item.messwert:[il_dw1row].value=<dw_1.item.messwertc:[il_dw1row].value,#0.000000>|||qs_qsftpos_edit|||qs_qsftpos_edit###
  0|||...itemchanged qs_qsftpos_edit.messwertc[1]:setmesswert|||setmeasurement()||||||qs_qsftpos_edit###
  0|||...itemchanged qs_qsftpos_edit.messwertc[1]:setmesswert|||goto=setmeasurement()||||||qs_qsftpos_edit###
  0|||..nged qs_qsftpos_edit.messwertc[1]:setmesswert:setmeasurement|||dw_1.item.measurementpersid:[il_dw1row].value=<currentpers_id>|||qs_qsftpos_edit|||qs_qsftpos_edit###
  0|||form|||setitem measurementpersid row 5 to 3||||||qs_qsftpos_edit###
  0|||..nged qs_qsftpos_edit.messwertc[1]:setmesswert:setmeasurement|||dw_1.item.measurementstationid:[il_dw1row].value=<stationname>|||qs_qsftpos_edit|||qs_qsftpos_edit###
  0|||form|||setitem measurementstationid row 5 to SAPAdmin||||||qs_qsftpos_edit###
  0|||..nged qs_qsftpos_edit.messwertc[1]:setmesswert:setmeasurement|||dw_1.item.measurementdate:[il_dw1row].value=<today> <now>|||qs_qsftpos_edit|||qs_qsftpos_edit###
  0|||..nged qs_qsftpos_edit.messwertc[1]:setmesswert:setmeasurement|||dw_1.item.measurementpersname:[il_dw1row].value=<is_name>|||qs_qsftpos_edit|||qs_qsftpos_edit###
  0|||form|||setitem measurementpersname row 5 to manager manager||||||qs_qsftpos_edit###
  0|||...itemchanged qs_qsftpos_edit.messwertc[1]:setmesswert|||if <item.typ:[il_dw1row].value> = L or <item.typ:[il_dw1row].value> = T then||||||qs_qsftpos_edit###
  0|||insertinfo:if <item.t||| [[-( "" = "l" ) = [[rfalse-]]( "" = "t" ) = [[rfalse-]]-]]||||||qs_qsftpos_edit###
  0|||...itemchanged qs_qsftpos_edit.messwertc[1]:setmesswert|||dw_1.item.ok:[il_dw1row].value=N|||qs_qsftpos_edit|||qs_qsftpos_edit###
  0|||form|||setitem ok row 5 to N||||||qs_qsftpos_edit###
  0|||...itemchanged qs_qsftpos_edit.messwertc[1]:setmesswert|||dw_2.item.ok.value=N|||qs_qsftpos_edit|||qs_qsftpos_edit###
  0|||form|||setitem ok row 1 to N||||||qs_qsftpos_edit###
  0|||...itemchanged qs_qsftpos_edit.messwertc[1]:setmesswert|||setvar=e_max=<dw_1.item.maximal:[il_dw1row].value,#0.000000>|||qs_qsftpos_edit|||qs_qsftpos_edit###
  0|||insertinfo:setvar=||| [[-e_max="6.300000"-]] ||||||qs_qsftpos_edit###
  0|||...itemchanged qs_qsftpos_edit.messwertc[1]:setmesswert|||if <e_max> n= 0 and <dw_1.item.minimal:[il_dw1row].value,#0.000000> = 0 then||||||qs_qsftpos_edit###
  0|||insertinfo:if <e_max>||| [[-( "6.300000" n= "0" ) = [[rfalse-]]( "5.500000" = "0" ) = [[rfalse-]]-]]||||||qs_qsftpos_edit###
  0|||...itemchanged qs_qsftpos_edit.messwertc[1]:setmesswert|||select round(0+ <dw_1.item.messwert:[il_dw1row].value,dbnum>,<dw_1.item.beas_me_anzdez:[il_dw1row].value>) from BEAS_DUMMY|||qs_qsftpos_edit|||qs_qsftpos_edit###
  0|||sql|||select round(0+ 5.450000,2) from BEAS_DUMMY||||||qs_qsftpos_edit###
  0|||duration|||<span class="sqlInfo">16 ms, Result: wert1=5.4500 (Decimal),</span>||||||qs_qsftpos_edit###
  0|||...itemchanged qs_qsftpos_edit.messwertc[1]:setmesswert|||setvar=ld_value=<wert1>|||qs_qsftpos_edit|||qs_qsftpos_edit###
  0|||insertinfo:setvar=||| [[-ld_value="5.450000"-]] ||||||qs_qsftpos_edit###
  0|||...itemchanged qs_qsftpos_edit.messwertc[1]:setmesswert|||if <ld_value> n>= <dw_1.item.minimal:[il_dw1row].value,#0.000000> and <ld_value> n<= <e_max,#0.000000> and <dw_1.item.beas_qssperrgrund_blockok:[il_dw1row].value> n<> 1 then||||||qs_qsftpos_edit###
  0|||insertinfo:if <ld_val||| [[-( "5.450000" n>= "5.500000" ) = [[rfalse-]]( "5.450000" n<= "6.300000" ) = [[gtrue-]]( "1" n<> "1" ) = [[rfalse-]]-]]||||||qs_qsftpos_edit###
  0|||...itemchanged qs_qsftpos_edit.messwertc[1]:setmesswert|||setrelease()||||||qs_qsftpos_edit###
  0|||...itemchanged qs_qsftpos_edit.messwertc[1]:setmesswert|||goto=setrelease()||||||qs_qsftpos_edit###
  0|||..nged qs_qsftpos_edit.messwertc[1]:setmesswert:setrelease|||if <dw_1.item.releaseautomatic:[il_dw1row].value> n= 1 and <dw_1.item.ok:[il_dw1row].value> = J then||||||qs_qsftpos_edit###
  0|||insertinfo:if <dw_1.i||| [[-( "1" n= "1" ) = [[gtrue-]]( "n" = "j" ) = [[rfalse-]]-]]||||||qs_qsftpos_edit###
  0|||..nged qs_qsftpos_edit.messwertc[1]:setmesswert:setrelease|||if <dw_2.item.release:1.value> = 0 then||||||qs_qsftpos_edit###
  0|||insertinfo:if <dw_2.i||| [[-( "0" = "0" ) = [[gtrue-]]-]]||||||qs_qsftpos_edit###
  0|||..nged qs_qsftpos_edit.messwertc[1]:setmesswert:setrelease|||dw_1.item.release:[il_dw1row].value=0|||qs_qsftpos_edit|||qs_qsftpos_edit###
  0|||..nged qs_qsftpos_edit.messwertc[1]:setmesswert:setrelease|||return true||||||qs_qsftpos_edit###
  0|||...itemchanged qs_qsftpos_edit.messwertc[1]:setmesswert|||return true||||||qs_qsftpos_edit###
  0|||globalfunction|||itemchangeuser()|||qs_qsftpos_edit|||qs_qsftpos_edit###
  0|||.itemchanged qs_qsftpos_edit.messwertc[1]|||dynamicobject=send=itemchanged=messwertc|||qs_qsftpos_edit|||qs_qsftpos_edit###
  0|||.itemchanged qs_qsftpos_edit.messwertc[1]|||iqs=scale=view|||qs_qsftpos_edit|||qs_qsftpos_edit###
  0|||.itemchanged qs_qsftpos_edit.messwertc[1]|||return true||||||qs_qsftpos_edit###
  0|||globalfunction|||itemchangeuser()|||qs_qsftpos_edit|||qs_qsftpos_edit###
  0|||.itemchanged qs_qsftpos_edit.messwertc[1]|||dynamicobject=send=itemchanged=messwertc|||qs_qsftpos_edit|||qs_qsftpos_edit###
  0|||itemfocuschanged|||set focus from messwertc to sperrgrundid||||||qs_qsftpos_edit###
  0|||BeasUsabilityPackage|||validation GotFocus for dw_2.sperrgrundid in window qs_qsftpos_edit||||||qs_qsftpos_edit###
  0|||stack|||dw_1.item.sperrgrund.redraw|||qs_qsftpos_edit|||qs_qsftpos_edit###
  0|||stack|||dw_1.item.messwertc.redraw|||qs_qsftpos_edit|||qs_qsftpos_edit###
• 

  Martin Heigl

  • December 29, 2020 08:16

  Hi,

   

  

   

  i checked this

  this is only working, if min value <> 0 and the input value <> 0
  in the not readable debug log i can see, that it's working fine.
  Please use this icon to share the debug log
  
• 

  Ashvin Hargovind

  • January 12, 2021 21:38

  Hi

  Thank you for the assistance.  I managed to get it working.

  It wasnt working at first because i was using the beas usability extension to trigger it.  

  Once i put it directly in beas script, it worked as Martin mentioned.

  Once again, thank you.

  Kind Regards
  Ashvin

Please sign in to leave a comment.