We hope you'll join us for our 4/23 webinar on using data tables to apply reference ranges and AE codes in OC4. For more information and to register, visit https://register.gotowebinar.com/register/2882170018956684555

Validation Rules Issue:

Hi there,
I´ve an issue on writing validation rules.
If I test my rule in the webinterface within the "Test Rules" dialog i paste the following:
Target:
S_REACTION.F_REACTION_50_10.IG_REACT_UNGROUPED.I_REACT_REAC_TYPE_OF_DIABETES
Rule:
(I_REACT_REAC_TYPE_OF_DIABETES eq "3") and
(I_REACT_REAC_TYPE_OF_DIABETES_IFOTH eq "")
The answer I´ve got was:
Rule Result: Fail : Extra Data in Expression.
If I try to upload the XML I got an Target Syntax Invalid error.
Here´s my XML:




S_REACTION.F_REACTION_50.IG_REACT_UNGROUPED.I_REACT_REAC_TYPE_OF_DIABETES




If 'Type of Diabetes' equals 'other' then you have to specify.







If 'Type of Diabetes' equals 'other' then you have to specify.


(I_REACT_REAC_TYPE_OF_DIABETES eq "3") and (I_REACT_REAC_TYPE_OF_DIABETES_IFOTH eq "")



Any hints for me?
Regards,
Bernd

Comments

  • RE: [Users] Validation Rules Issue:
    Hello Bernd,
    I see two things that look incorrect with your syntax. In your target, the study event has not been defined correctly.
    Your study event should be "SE_REACTION" (assuming that is the name of your study event). All study event OIDs begin with SE_ .
    Next, it seems that the CRF OID is inconsistent with what you wrote in the test and in the target itself. Please make sure you are using the correct CRF OID (which is probably F_REACTION). You may want to use the CRF OID rather than the version OID.
    Another thing that I noticed is that you have the IfExpressionEvaluates set to false. Based on what I read from the expression, you probably want this set to true. This is assuming that "3" is the response value for "other".
    If these suggestions do not work, please attach the study metatdata file as well.
    Best,
    Alicia
    -----Original Message-----
    Sent: Tue 6/29/2010 6:22 AM
    To: [email protected]
    Subject: [Users] Validation Rules Issue:
    Hi there,
    I´ve an issue on writing validation rules.
    If I test my rule in the webinterface within the "Test Rules" dialog i paste the following:
    Target:
    S_REACTION.F_REACTION_50_10.IG_REACT_UNGROUPED.I_REACT_REAC_TYPE_OF_DIABETES
    Rule:
    (I_REACT_REAC_TYPE_OF_DIABETES eq "3") and
    (I_REACT_REAC_TYPE_OF_DIABETES_IFOTH eq "")
    The answer I´ve got was:
    Rule Result: Fail : Extra Data in Expression.
    If I try to upload the XML I got an Target Syntax Invalid error.
    Here´s my XML:




    S_REACTION.F_REACTION_50.IG_REACT_UNGROUPED.I_REACT_REAC_TYPE_OF_DIABETES




    If 'Type of Diabetes' equals 'other' then you have to specify.







    If 'Type of Diabetes' equals 'other' then you have to specify.


    (I_REACT_REAC_TYPE_OF_DIABETES eq "3") and (I_REACT_REAC_TYPE_OF_DIABETES_IFOTH eq "")



    Any hints for me?
    Regards,
    Bernd
  • haenselhaensel Posts: 602 ✭✭✭
    Hi Bernd
    I'm no rule expert but could you try "SE_REACTION.F_REACTION_50_10.IG_REACT_UNGROUPED.I_REACT_REAC_TYPE_OF_DIABETES" instead of "S_REACTION.F_REACTION_50_10.IG_REACT_UNGROUPED.I_REACT_REAC_TYPE_OF_DIABETES" (notice the SE_ instead of S_)?
    Regards,
    Christian
    Am 29.6.2010 12:22, schrieb Tschapeller, Bernd:
    > Hi there,
    >
    > I´ve an issue on writing validation rules.
    >
    > If I test my rule in the webinterface within the "Test Rules" dialog i paste the following:
    >
    > Target:
    > S_REACTION.F_REACTION_50_10.IG_REACT_UNGROUPED.I_REACT_REAC_TYPE_OF_DIABETES
    >
    > Rule:
    > (I_REACT_REAC_TYPE_OF_DIABETES eq "3") and
    > (I_REACT_REAC_TYPE_OF_DIABETES_IFOTH eq "")
    >
    > The answer I´ve got was:
    > Rule Result: Fail : Extra Data in Expression.
    >
    > If I try to upload the XML I got an Target Syntax Invalid error.
    >
    > Here´s my XML:
    >
    >
    >
    >
    > S_REACTION.F_REACTION_50.IG_REACT_UNGROUPED.I_REACT_REAC_TYPE_OF_DIABETES
    >
    >
    >
    >
    > If 'Type of Diabetes' equals 'other' then you have to specify.
    >
    >
    >
    >
    >
    >
    >
    > If 'Type of Diabetes' equals 'other' then you have to specify.
    >
    >
    > (I_REACT_REAC_TYPE_OF_DIABETES eq "3") and (I_REACT_REAC_TYPE_OF_DIABETES_IFOTH eq "")
    >
    >
    >
    >
    > Any hints for me?
    >
    > Regards,
    > Bernd
    >
    >
    >
    >
  • GerbenRienkGerbenRienk Posts: 809 ✭✭✭
    RE: [Users] Validation Rules Issue:
    Hello Bernd,

    This may sound strange, but there is probably nothing wrong with the expressions you are testing. It’s the length of their names that is (probably) the problem.

    If you have tested both the expressions
    (I_REACT_REAC_TYPE_OF_DIABETES eq 3)
    (I_REACT_REAC_TYPE_OF_DIABETES_IFOTH eq "")

    and found them both OK, try composing your expression in another editor as one big line. Copy this line in the box for the rule. Now add spaces between the first half of your expression and the word “and”, until “and (I_REACT_REAC_etc” are on one line. Now submit your rule and see if it syntacticly sound. (Is that English?)
    I’ll attach a screenshot of a similar situation and hope this clarifies it.
    Good luck,

    Gerben Rienk Visser
    http://www.trialdatasolutions.com


    Van: [email protected] [mailto:[email protected]] Namens Tschapeller, Bernd
    Verzonden: dinsdag 29 juni 2010 14:53
    Aan: [email protected]
    Onderwerp: AW: [Users] Validation Rules Issue:

    Hi,

    I've figured out that i did make one big mistake. I've choosen the study-OID instead of the studyEvent-OID.
    Never the less this isn´t solving my issue.

    Once again:
    In the test I entered:

    Target:
    SE_VISIT1.F_REACTION_50_10.IG_REACT_UNGROUPED.I_REACT_REAC_TYPE_OF_DIABETES
    Rule:
    (I_REACT_REAC_TYPE_OF_DIABETES eq 3) and (I_REACT_REAC_TYPE_OF_DIABETES_IFOTH eq "")
    I've changed the study event OID and removed the quotation marks ("3" --> 3)
    The result is still:
    Rule Result:
    Fail : Extra Data in Expression.
This discussion has been closed.