Boolean field in MDM

[Former Member]

Hi All,

I got requirement to send data from MDM to ECC for check box.

Expected value from MDM is X or space.

For the above requirement want to use Boolean field in MDM.

I want to specify default values for boolean as X for True. Is there any keyward to specify as False as space.

I am just wondering how APIs are indicating for false in Boolean field.

Thanks i

[Former Member · Accepted solution]

Hi Kiran,

I am able to define space for false in boolean field

Please check in MDM console the false value whai is appearing the same value appear in data manager.

If space is appearing in console then it definetly come in data manager.

Please update me about yr status.

Thanks,

Sudhanshu

[former_member205403]

Hi,

Try This:

Specify "X" as TRUE and " " (SPACE) for False. now Syndicator will send "X" for True. and blank will be send for False which ECC can easily interpret.

If you are using APIS, then use " " (SPACE) for searching for False Value in the boolean Field.

Regards,

SHiv

[Former Member]

Hi,

Thanks for your reply.

The issue here for false value, if I configure space for false in Console.

In MDM data manager it defaulted as FALSE.

I am just exploring how to use boolean field for false condtion with SPACE.

For the above req workaroud is Lookup table as indicator with X as True SPACE as False.

Any ideas on this Boolean field appreciated.

Thank you,

Kiran

[former_member205403]

No, if you use Space for False, then in data manager it will not be dafaulted as False. it will be defaulted as what you define in Console. and if value is not maintained for any record then it will show {NULL] in data manager for that record.

Check it and let me know if you have any ques.

Regards,

SHiv

[Former Member]

Hi,

This can be implemented in PI interface. I believe you are using PI in between MDM and ECC, If "true" will come from MDM, PI will send as "X" for this field other wise PI has send space to ECC, this transformation has to done in PI.

Hope this helps you..

Thanks & Regards,

Veera.

[former_member205403]

Veera, I agree with you. it can be implemented easily through PI. But also if PI is not used, in this case also it can be done within MDM.

Regards,

Shiv