[ic] Hiding inactive product items...

[Xin Xu]

To take advantage of the inactive field in product table, I upgraded my interchange to version 4.9.7. As mentioned in WHATSNEW file, I have added the following lines at end of my catalog.cfg,


Database products HIDE_FIELD inactive
Database products COLUMN_DEF "inactive=int default 0"


After restarting the interchange, it seems only display items where “inactive <> NULL” (i.e. regardless whether the inactive is “1” or “0”), and it hides all the items having inactive=NULL, which is not what I expected either. What did I do wrong???

 

Thank for helping.

-Xin