System-defined table constraints in Product Configurator

(0) Share

Report

Posted on by Amitsb1980

251

Hi All,

I have seen a lot of literature and illustration of user-defined table constrains used in product configurator in the form of YouTube videos/Microsoft documentation.

However, there isn't much explanation on System-defined table constrains. Where can I find any guidance with examples of how to create dynamic mapping using these constrains?

Thanks,

Amit

I have the same question (0)

All responses (5)

Answers (2)

Verified answer

Blue Wang on at

Like (1)

Report

Hi Amit Bhawalkar,

A system-defined table constraint creates a dynamic mapping between an attribute type and a field in a table.

Please refer this blog: community.dynamics.com/.../table-constraint-definitions

Was this reply helpful? Yes No
Verified answer

MATTGUO 22,349 Moderator on at

Like (1)

Report

Hi Amit,

1.Create the table constraint and specify the query.

2.Add the attribute with the same attribute type in configuration models, and add the Table constraint.

3.Map the attribute to Table constraint columns by clicking the edit table constraint in the previous screenshot.

4.Test. In the ActivityListOpenView table, there are 21 records, but the test result will display the records of the query.

Hope this helps you.

Was this reply helpful? Yes No
Amitsb1980 251 on at

Like (0)

Report

Thanks Mattguo for your response with illustrations.

Was this reply helpful? Yes No
Amitsb1980 251 on at

Like (0)

Report

Thanks Blue Wang for the blog. It indeed helped.

Was this reply helpful? Yes No
Amitsb1980 251 on at

Like (0)

Report

Hi Mattguo,

I tried the method explained. However, when I am trying to map a field in D365 with type 'number' with a attribute type 'integer' (with range), I get the error

'The selected field does not match any of the supported types; Enum, String and Integer'

Similarly, I am unable to map any prices that are decimal.

Are you able to assist with this issue?

Thanks,

Amit

Was this reply helpful? Yes No