AnsweredAssumed Answered

Using a Card Variable in a Card list Query

Question asked by Ross McEllhiney on Mar 4, 2011
Latest reply on Mar 8, 2011 by Joy Garon

Hello

Is it possible to pass a card variable value to a card list Query

I would like to use a combox pull down list to select a subset of a database list using the value in the Combobox

I know that I can use the

Dynamically-controlled Card Lists

But this does not let me query a seperate database.

I also know how to write API code to do this but it would be simpler to Pass a varaible to the Query

Thanks

Ross

Correct Answer

The query Jeff mentions cannot contain/reference a variable value from the card.

Wouldn't that be sweet though? Think how much more intelligent our cards could be.

No one else had this question

Outcomes

Have you looked in to creating a list from a SQL query? Page 171 in the Administration guide.

The query Jeff mentions cannot contain/reference a variable value from the card.

Wouldn't that be sweet though? Think how much more intelligent our cards could be.

I need to do exactly what Jeff is saying, Does anyone know how to do That??????

I want to transfer a varaible from the card to a Query and then run the query to get a list

Thanks

Ross -

You can use an add-in -

Look at the AVI included in this thread:

Joy