You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ofbiz.apache.org by "Alex D. Fleming" <al...@gmail.com> on 2006/11/11 14:20:05 UTC
Significance of SequenceId field
Hi,
What is the significance of SequenceId field in the database ??
Like we use 1,2,5 and other values for sequence field.
For example see in the Catalog --> Store --> OFBiz E-Commerce Store [9000]
-- > Promos
--
Regards
Alex D. Fleming
Re: Significance of SequenceId field
Posted by Chris Howe <cj...@yahoo.com>.
if multiple records have the same sequenceId then a
sort of those will be returned as a group ie
blue = 2
black = 1
pink = 3
brown = 1
purple = 3
orange = 2
navy = 1
lime = 3
red = 2
will return
Black
Brown
Navy
Blue
Orange
Red
Pink
Purple
Lime
--- "Alex D. Fleming" <al...@gmail.com>
wrote:
> Thx for the reply Chris.
> But sometime its been seen that all the sequence no
> are set to only 1 or any
> single value.
> Is that wrong data or something else ??
>
> BTW your explaination was very nice.
>
> On 11/11/06, Chris Howe <cj...@yahoo.com>
> wrote:
> >
> > It allows a way to sort the results of a query so
> that
> > they are returned in an order that is beneficial.
> >
> > For instance, if you had a list:
> > Low
> > Medium
> > High
> >
> > and had no sequenceId
> >
> > the only way you could sort them would be by:
> > alphabetical order - High, Low, Medium or Medium,
> > Low, High
> >
> > and
> >
> > character Length order - Low, High, Medium or
> Medium,
> > High, Low
> >
> > entering a sequence gives you:
> > Low - 1
> > Medium - 2
> > High - 3
> > lets you sort by 1,2,3 or 3,2,1 which results in
> Low,
> > Medium, High or High, Low, Medium this is an order
> > that makes sense.
> >
> > --- "Alex D. Fleming" <al...@gmail.com>
> > wrote:
> >
> > > Hi,
> > >
> > > What is the significance of SequenceId field in
> the
> > > database ??
> > > Like we use 1,2,5 and other values for sequence
> > > field.
> > > For example see in the Catalog --> Store -->
> OFBiz
> > > E-Commerce Store [9000]
> > > -- > Promos
> > >
> > > --
> > > Regards
> > > Alex D. Fleming
> > >
> >
> >
>
>
> --
> Regards
> Alex D. Fleming
>
Re: Significance of SequenceId field
Posted by "Alex D. Fleming" <al...@gmail.com>.
Thx for the reply Chris.
But sometime its been seen that all the sequence no are set to only 1 or any
single value.
Is that wrong data or something else ??
BTW your explaination was very nice.
On 11/11/06, Chris Howe <cj...@yahoo.com> wrote:
>
> It allows a way to sort the results of a query so that
> they are returned in an order that is beneficial.
>
> For instance, if you had a list:
> Low
> Medium
> High
>
> and had no sequenceId
>
> the only way you could sort them would be by:
> alphabetical order - High, Low, Medium or Medium,
> Low, High
>
> and
>
> character Length order - Low, High, Medium or Medium,
> High, Low
>
> entering a sequence gives you:
> Low - 1
> Medium - 2
> High - 3
> lets you sort by 1,2,3 or 3,2,1 which results in Low,
> Medium, High or High, Low, Medium this is an order
> that makes sense.
>
> --- "Alex D. Fleming" <al...@gmail.com>
> wrote:
>
> > Hi,
> >
> > What is the significance of SequenceId field in the
> > database ??
> > Like we use 1,2,5 and other values for sequence
> > field.
> > For example see in the Catalog --> Store --> OFBiz
> > E-Commerce Store [9000]
> > -- > Promos
> >
> > --
> > Regards
> > Alex D. Fleming
> >
>
>
--
Regards
Alex D. Fleming
Re: Significance of SequenceId field
Posted by Chris Howe <cj...@yahoo.com>.
It allows a way to sort the results of a query so that
they are returned in an order that is beneficial.
For instance, if you had a list:
Low
Medium
High
and had no sequenceId
the only way you could sort them would be by:
alphabetical order - High, Low, Medium or Medium,
Low, High
and
character Length order - Low, High, Medium or Medium,
High, Low
entering a sequence gives you:
Low - 1
Medium - 2
High - 3
lets you sort by 1,2,3 or 3,2,1 which results in Low,
Medium, High or High, Low, Medium this is an order
that makes sense.
--- "Alex D. Fleming" <al...@gmail.com>
wrote:
> Hi,
>
> What is the significance of SequenceId field in the
> database ??
> Like we use 1,2,5 and other values for sequence
> field.
> For example see in the Catalog --> Store --> OFBiz
> E-Commerce Store [9000]
> -- > Promos
>
> --
> Regards
> Alex D. Fleming
>