Created a new table, z_product_changes, that needs to be sorted by version.
After reading the documentation, it appears the way to do this is to set the Sort Columns value in the Domsets in the schema designer.
Following errors are seen in the SDM STDLOGs whenever the SDM service is restarted
domsrvr 6164 ERROR domdict.c 4012 Ignoring duplicate definition of domset MLIST_DYNAMIC in factory z_product_changes
domsrvr 6164 ERROR domdict.c 4016 Use MODIFY statement to modify previously-defined items
domsrvr 6164 ERROR domdict.c 4012 Ignoring duplicate definition of domset RLIST_DYNAMIC in factory z_product_changes
domsrvr 6164 ERROR domdict.c 4012 Ignoring duplicate definition of domset MLIST_STATIC in factory z_product_changes
domsrvr 6164 ERROR domdict.c 4012 Ignoring duplicate definition of domset RLIST_STATIC in factory z_product_changes
Service Desk 12.9, 14.1 and 17.x
All Supported Operating Systems
Modify the NX_ROOT/site/mods/majic/wsp.mods file as the following to correct this error:
DELETE
MODIFY FACTORY z_product_changes
{
DOMSET MLIST_DYNAMIC "version" "" DYNAMIC;
};
MODIFY FACTORY z_product_changes
{
DOMSET MLIST_STATIC "version" "" STATIC;
};
MODIFY FACTORY z_product_changes
{
DOMSET RLIST_DYNAMIC "version" "" DYNAMIC;
};
MODIFY FACTORY z_product_changes
{
DOMSET RLIST_STATIC "version" "" STATIC;
};
ADD SORT_BY STATEMENT TO THE STANDARD LIST SO IT LOOKS LIKE
STANDARD_LISTS {
SORT_BY "version";
MLIST OFF;
RLIST OFF;
};
INSTEAD OF
STANDARD_LISTS {
MLIST OFF;
RLIST OFF;
};
Save changes and recycle the SDM service