Reltio Connect

 View Only

  • 1.  Validation function rules | defining

    Posted 06-12-2023 02:30

    Hi Team,

    Starting this discussion to know more about ways to define values which has comma delimiter while creating validation function.

    Attached function works for values such as Agriculture & Mining, Business Services, Computer & Electronics since all these are single values.
    But for values such as. "Healthcare, Pharmaceticals & Biotech" these are considered as single value. 
    Looking for a way to define such use cases.
    Thanks & Regards


    ------------------------------
    Chetan P
    Lead MDM Specialist
    Freshworks
    Chennai
    ------------------------------


  • 2.  RE: Validation function rules | defining

    Posted 06-20-2023 12:53

    @Ashish Rawat @Sheshadri V  - Any thoughts on the above .?



    ------------------------------
    Chetan P
    Lead MDM Specialist
    Freshworks
    Chennai
    ------------------------------

    Original Message


  • 3.  RE: Validation function rules | defining

    Reltio Partner
    Posted 06-21-2023 08:45

    Hi Chetan,

    Thanks for tag.

    I was browsing the docs on Validation and could not find anything matching your requirements.

    If we use equals it allows only 1 value and if we use in the list it does not consider values with ,

    I was checking and tried below in advanced editor:

    listEquals(attributes.Name.value, 'hi, hello', 'Hello')

    and surprisingly it worked in DVF.

    so switch to advanced editor and try to provide values in single quotes which have ,

    I would still say this as workaround and consider checking with Reltio Support if they extend the range of functions to listEquals as we can provide multiple kinds of values.

    Try out and update us.



    ------------------------------
    Sheshadri V
    Fresh Gravity
    ------------------------------

    Original Message


  • 4.  RE: Validation function rules | defining

    Reltio Partner
    Posted 06-21-2023 09:33

    Hi Chetan,

    Have you tried to separate the ones without comma as 'In the list' and the ones with comma you can have as equals and having or conditions?

    Do try out and update us if it works.



    ------------------------------
    Sheshadri V
    Fresh Gravity
    ------------------------------

    Original Message


  • 5.  RE: Validation function rules | defining

    Posted 06-28-2023 01:13

    Hi Sheshadri,

    Above mentioned approaches / Other approaches which i have tired to implement the requirement seems not working. Will raise an Enhancement request for the same.

    Validation functions either through a list / separate variable works only as a whole words but doesn't working for series of words having , (commas) between them.

    Will also update the Idea ID in the same loop.

    Thanks & Regards,



    ------------------------------
    Chetan P
    Lead MDM Specialist
    Freshworks
    Chennai
    ------------------------------

    Original Message


  • 6.  RE: Validation function rules | defining
    Best Answer

    Posted 07-04-2023 01:35

    Hi Team,

    Update regarding defining Validation function for the above use case.

    Solution - listEquals(attributes.INDUSTRY.value, 'A, B, & C')

    By applying mentioned formula in the validation function expression, we can able to achieve the requirement needs.


    Thanks & Regards,



    ------------------------------
    Chetan P
    Lead MDM Specialist
    Freshworks
    Chennai
    ------------------------------

    Original Message


Related Content