spacer
cornerspacercorner
Reply
Advisor
Prax
Posts: 34
Registered: 07-05-2011
0 Kudos

List/Array ??

Does metastorm have a list/array type ?

 

Here's my problem. I have a form that brings back a long list of static values. Right now, every time this form is reloaded, it hits the DB to pull that whole list again.

 

It makes perfect sense to pull back that list from the DB before the form loads (serverside) and store that list in a variable (which type ??) and then use this variable to populate values into the dropdown.

 

Is this possible in metastorm ? Seems like basic functionality to avoid database hits .... Maybe im missing something really simple..HELP

 

Thanks

Have a nice day

Advisor
Prax
Posts: 34
Registered: 07-05-2011
0 Kudos

Re: List/Array ??

Does this feature just not exist ? :smileysad:

Valued Contributor
Paul
Posts: 146
Registered: 05-19-2010
0 Kudos

Re: List/Array ??

It really depends what you are trying to do so your question is a little difficult to answer.  There is no 'memory' list object as you would have in modern programming languages but there are a couple of options available to you, again depending on what you are trying to do.

 

v7 had the option to read an indexed value from a memo variable like: myMemo[0].... and you could either populate the memo through concatenation or from a select statement.  It's a while since I used v7 and I can't remember whether the delimeter was tab or line feed.

 

If you're looking to save DB overhead I'm not sure this helps you because you still have a read of a memo variable which is going to incurr more overhead than a row read. If this is on a folder row then this will be opened on each folder access.

 

If you have a many to one relationship that you're trying to resolve you could consider using an external table which gives you the advantage of only accessing the data when you need it.

 

Hope this helps,

 

Paul

Advisor
Prax
Posts: 34
Registered: 07-05-2011
0 Kudos

Re: List/Array ??

Thanks Paul - it looks like the memo solution would best help me at this point. Do you have any examples by any chance on the metastorm site that describes this ?

 

Thanks

line spacer line
spacerFollow Metastorm on:
spacer Twitter YouTube Blog iTunes LinkedIn Metastorm Community Central, MC2
spacer Copyright © 2011 OpenText Corporation. All Rights Reserved.spacer About Metastormspacer Privacyspacer Legalspacer Site Mapspacer RSSspacer Contact Us
Microsoft Gold Certified Partner
Powered by Windows Azure
line spacer line