Enumerations Label As Value In Query Filter

[jianghait960580]

Dear,

    I'll describe my problem first. Enumerations comes from Salesforce synchronization. The useful values are Label and Internal Name. However, the values between the two are inconsistent. The database stores the value of Internal Name, but when I do Query, THE SQL splicing takes the Label of Enumerations as the condition to Query. Is there no transformation here?

   However, in the Schema, Enumerations syntax, the forwarding between Label and value can be implemented.

                         

I expect that enumeration can also achieve the effect of syntax in enumeration in schema.

Thanks，

Abel

[Jonathon_wodnicki · Accepted solution]

Hi,

There are 2 usages of db enums in schema:

• userEnum - Use @label for everything, ignore existence of @name
• dbEnum - Use @name for value, @label for display (your expectation)

Product doc is unhelpful and also wrong here, so use xtk:operator/@securityZone as a reference.

• userEnum (string): receives the internal name of an “open” enumeration. The values of the enumeration can be defined by the user in the interface.

• dbEnum (string): receives the internal name of a “closed” enumeration. The enumeration values must be defined in the <srcschema>. 

Thanks,

-Jon

[jianghait960580]

Thanks a lot, Jon