|
Home > Archive > Commerce Server General > May 2005 > Ordering relationships
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Ordering relationships
|
|
| Tomas Vera 2005-05-04, 5:55 pm |
| Hello All,
In my site, I need to establish several relationships between
Category/ Product and between Category/SubCategory and Product/product
Using CS2002 and FP1, I've been using the CatalogManager to create the
relationships with no trouble and the related categories/products
return as expected.
Now, I need to control the order in which these items are displayed to
the user (i.e. Product 234 needs to come before product 789 and after
product 123).
Does Commerce support performing a search such as this?
Do I need to create a new "RelationshipOrder" table, with these
relationships listed explicitly?
Any suggesstions on how best to do this?
All help is appreciated!
-tomas
/*-------------------------------
* Tomas Vera
* tomas (at) sbcglobal (dot) net
*-------------------------------
*/
| |
| Tomas Vera 2005-05-05, 5:57 pm |
| OK, I've got something working.
I've created an "admin" page to show the admin user the
products/category he's interested in.
On that page I get the related product/categories, sorting on the
relationshipName field.
On update/save, I take the items in the order that the user has
arranged, and create a relationship name using the index of the
current item. In this manner I can specify the relationship I want as
well as the ordering for the product/category.
There's probably a better way, but it's working for now.
-tomas
On Wed, 04 May 2005 19:12:10 GMT, Tomas Vera
<tavera@NO_SPAM_sbcglobal.net> wrote:
>Hello All,
>In my site, I need to establish several relationships between
>Category/ Product and between Category/SubCategory and Product/product
>
>Using CS2002 and FP1, I've been using the CatalogManager to create the
>relationships with no trouble and the related categories/products
>return as expected.
>
>Now, I need to control the order in which these items are displayed to
>the user (i.e. Product 234 needs to come before product 789 and after
>product 123).
>
>Does Commerce support performing a search such as this?
>
>Do I need to create a new "RelationshipOrder" table, with these
>relationships listed explicitly?
>
>Any suggesstions on how best to do this?
>
>All help is appreciated!
>
>-tomas
>/*-------------------------------
> * Tomas Vera
> * tomas (at) sbcglobal (dot) net
> *-------------------------------
> */
/*-------------------------------
* Tomas Vera
* tomas (at) sbcglobal (dot) net
*-------------------------------
*/
|
|
|
|
|