Clarity PPM

Expand all | Collapse all

Convert a string to lowercase/uppercase for a calculated attribute

Jump to Best Answer
  • 1.  Convert a string to lowercase/uppercase for a calculated attribute

    Posted 05-17-2018 03:20 PM

    Hi,

    We have an editable string field which needs to be moved to a secure page for super users, and a calculated attribute needs to be created for normal users.

     

    Here, how can I convert the string to upper case. Please help me with the syntax 

     

    Thanks,

    Sreelesh 



  • 2.  Re: Convert a string to lowercase/uppercase for a calculated attribute
    Best Answer

    Posted 05-18-2018 04:13 AM

    Not sure that you can do it in a calculated attribute?

    However I am sure that you could do it like this ; TIP : How To Put Any Dynamically Generated Value On A Clarity Object 



  • 3.  Re: Convert a string to lowercase/uppercase for a calculated attribute

    Posted 05-18-2018 04:45 AM

    I do not think it  is possible. I mean I have not done this personally and there is no such OOTB method by which you can do that. But if changing the case of the string is really important for you, then you can try to create a process which will update the database column so that the case is changed. There are functions like LOWER() and UPPER()which can be used in the database level. So I am suggesting you to update the attribute value's case from the DB end. This process can be triggered whenever the calculated attribute is updated. You can just try this. Hope that helps.



  • 4.  Re: Convert a string to lowercase/uppercase for a calculated attribute

    Posted 05-18-2018 11:28 AM

    Thanks David and Abhishek. I guess it would be good to have the basic functions allowed for the calculated string attribute. 
    For now, I will go ahead with having a dynamic query lookup, as suggested by David since it will make it is easy to maintain