D2 Property Page - List Feilds

Hi All,

We have a requirement where we need 3 list fields where data selected in first decides the data available in selection in rest of the two.

I am trying to create a property page and using 3 list fields .The issues which i am facing are

1.List fields does not support taxonomy.

2.The DQL associated with list field is executed every time even for edit/view mode.

To overcome the first problem , I have associated a DQL query to fetch the data values available for selection.The DQL is in format

select xyz from dm_dbo.register_table where abc=$value(abc) and xyz is not null

Once the document is created and saved .When i try to view document properties , the dql associated with list feild (for data selection) is fired even when the object has values saved.The dql execution fails highlighting error in User interface.

The environment is

D2 4.5

CS -7.2

Browser - IE 11

Please let me know if anyone has faced this issues or if there is workaround.

Thanks

Yashashri.

Find more posts tagged with

Comments

EktaVegad

Hi Yashashri,

you can try with 2 property pages, one for the import/create the document & other one which is applied at configuration matrix(which is used when you edit or view property page).

try to put list with query in a property page which is used for importing the document & in other property page either keep list with read only or use other controls to show a values i.e not editable.

Hope this will work.

Regards,

Ekta

yevryid

Hi Ekta,

Thanks for input.I am not sure how to set the page in view mode.Could you please let me know.

Also,for edit mode ,I think user should be allowed to edit the list field values so making them read only might not help.

This does not seem to be usual behavior.I doubt if this is by design or is it a bug.

anupatnaik

Hello Yevryid,

For setting the page in create/import mode, you need to configure the page in the creation profile/extended creation profile. This is the property page which will turn up during creation/import of objects.

For setting the page in view/edit mode, you need to check the property page against the context in the configuration matrix. This is the property page which will turn during "Edit Properties".