Loop Through List

[selbjx]

Does anyone have a function that will allow me to loop through a list retrieving values based on the index of the item, count items in the list. This list could be dynamic or static.

Any help would be greatly appreciated, also in adding this to ebase.

[Joost]

More work and code then a (custom) function, but if you haven't tried this yet you could create a db-resource which queries the dynamic/static list and use it to fill a table-field.

You then may loop at the table and count or get the required data. You could even use the modified table data to fill a dropdown field.

[selbjx]

More work and code then a (custom) function, but if you haven't tried this yet you could create a db-resource which queries the dynamic/static list and use it to fill a table-field.

You then may loop at the table and count or get the required data. You could even use the modified table data to fill a dropdown field.

The problem i have is that the product we have, has a tailorability statement which prevents us doing such things, however functions are permitted.

[AJDulk]

Does "tailorability statement" mean that contractually you are not allowed to connect directly to and query the database?

How exactly are you getting the list into Ebase?

An Ebase list is (normally speaking) a table in a database. Static Lists are in the repository and Dynamic Lists can be in any database to which you are connected. All the list is, is a query on a table in a database. Since you already have a query on the database referencing the list I am not sure where the problem is in creating another query on the same database.