Problems with Validations\Assignments

[Former Member]

Dear MDM Specialists,

I have a requirement where in if a field say "Name" in the main table named Products is in lower case (value of field NAME) then it should give a warning message and convert it into UPPER CASE or Sentence case.

I have been tring couple of syntaxs but none works.

Can anyone pls give me the exact syntax for doing the same i.e. giving out warning message and also converting the same field value into Upper case.

This is to be done from the Data Manager side automatically when the field NAME is changed by any user.

Greatly apreciate any prompt inputs.

Thanks.

Hari

[Former Member]

Hi Hari,

No matter what expression we used in the validation, if we point out proper table & field information in the validation attributes it executes the expressions automatically. <u>[ So in ur case when the user try to change the NAME field value it automatically points out WARNING or ERROR or the option which you chosen in the Automatic Execution attribute of validation]</u>

FYI: Validation is Stackable(callable), once can call the other one.

cheers,

Alexander.

[Former Member]

Hi Hari,

Please find the Assignment Expression:-

IF(IS_LOWER(Temp Info),UPPER(Temp Info),Temp Info)

This expression will check first whether it is Lower case or not,If it is small case then it will change the Small case into Upper case.If it upper case , it will leave the field value as it is.

By using the Work Flow,We can perform the automatic assignments on this case.

I do not have MS Visio with me to test that.

I hope it will be useful to your request.

Note:-

I could not perform assignments on Name Field(Product Names Table).I am looking on to that.

Best regards

Devaraj PK

[Former Member]

Hi, I have the same requirement but this expression is not working.

Assignment Expression : IF(IS_LOWER(Customer),UPPER(Customer),Customer)....

Customer is a field in main table with Text[50] and DF.

Result: It is giving true/false result but not assigning the value...

Please let me know Am I missing something? Or my understanding about assignment is wrong??

Thanks in adv....

[Former Member]

Its working now....

Solution: Just closed DM and opened it again....

[Former Member]

Hi Ron..

Instead of closing and opening the Datamanager ... Kindly 'REFRESH' the session by clicking 'F5' and let us know whether its giving the same result...

cheers

Alexander

[Former Member]

Actually It got hanged. So I just closed it and open it again. Now it is working fine even after using F5.

[Former Member]

Hi Ron..

Great!!! have a good time with work...

cheers

Alexander