Welcome Serena Central users! CLICK HERE
The migration of the Serena Central community is currently underway. Be sure to read THIS MESSAGE to get your new login set up to access your account.
nurulhuda1 Absent Member.
Absent Member.
654 views

Unable to create Active List " xxx " : Data List must have at least 1 value field

Jump to solution

whenever I want to make the active list, always appears an error like this, please help me

lcDAbb6.png

Labels (1)
0 Likes
1 Solution

Accepted Solutions
Highlighted
rhope Acclaimed Contributor.
Acclaimed Contributor.

Re: Unable to create Active List " xxx " : Data List must have at least 1 value field

Jump to solution

This happens when you have only key fields, you need a non key field. Is there a reason you are trying to set all fields as key?

View solution in original post

0 Likes
6 Replies
Highlighted
rhope Acclaimed Contributor.
Acclaimed Contributor.

Re: Unable to create Active List " xxx " : Data List must have at least 1 value field

Jump to solution

This happens when you have only key fields, you need a non key field. Is there a reason you are trying to set all fields as key?

View solution in original post

0 Likes
sujansures Absent Member.
Absent Member.

Re: Unable to create Active List " xxx " : Data List must  have at least 1 value field

Jump to solution

Hi ​, I too have confusions on this thing. Can you elaborate what is the use of having a key field..?

0 Likes
nurulhuda1 Absent Member.
Absent Member.

Re: Unable to create Active List " xxx " : Data List must  have at least 1 value field

Jump to solution

SOLVED ,,, thanks @richard hope

0 Likes
rhope Acclaimed Contributor.
Acclaimed Contributor.

Re: Unable to create Active List " xxx " : Data List must have at least 1 value field

Jump to solution

Keys (at least when multi-mapping is not enabled) are effectively a unique constraint on the underlying table that the ActiveList is stored in.  This means if you define a field or fields as key fields then there can only be one row in the table with that combination of values e.g. AL with fields 'foo'[key] and 'bar' when you add to active list values 'x', 'y' the row will be inserted, if you then subsequently add 'x', 'z' then the row with key value x will be updated.  If x wasn't key you would get a new row.  Key fields are needed when using the getActiveListValue variable type, if you are just using it for an inActveList condition then they may not be required

0 Likes
balahasan.v1 Acclaimed Contributor.
Acclaimed Contributor.

Re: Unable to create Active List " xxx " : Data List must have at least 1 value field

Jump to solution

Hey Nurul,

If u want All fields to be key field for ur AL. Leave the key field option unchecked. Will consider all fields as key.

Hey Sujan,

The key fields has a lot of advantages. When u define a unique key field is like a Primary keys on DB. Used to map and compare data fields

0 Likes
sujansures Absent Member.
Absent Member.

Re: Unable to create Active List " xxx " : Data List must  have at least 1 value field

Jump to solution

Hi ​, key field - primary key in DB. wow comparison!

Thanks bro

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.