is it possible to select in an expression list box with the help of a trigger ?

[fashid]

Hi,

I have created a list box with an expression which is not an actual field in the data model.

Is it possible to create a trigger to select values in this list box.

Regards

Nadeem

[Gysbert_Wassenaar · Accepted solution]

No, not as far as I know. Expression values cannot be selected. These values are not field values, but are calculated.

[jonathandienst]

Agreed. Selections apply to fields. When you manually make a selection from an expression list box, QV will apply the selection to the underlying fields.

[petter]

That depends...

If you in the expression refer to any field(s) in your data model - then yes.

If this is a purely calculated/synthetic expression without references to the data model - then you will not be allowed any selection.

I would try to make a Load Script calculation out of it and generate a data island table that contains the values you have in your expression now. That way you can naturally select on this field and you can use the selections for instance in Set Expressions for your regular connected/associated data model.

[fashid]

I have created a list box with the following expression where BRANCH_NAME is field in the data model

=if(REGION='IND'and  BRANCH_NAME<>'BBS',BRANCH_NAME)

[petter]

Your list box will select the associated fields correctly. But you can't detect directly that you selected anything in the list box except indirectly.

BUT - with a help from a friend - we might do that...

A variable that has the same expression as your list box can have "Variable Event Triggers" created. And in this trigger you can create an Action that is a Selection in another field.

So a variable like this:

   vBranchIndTrigger

               =If( ReworkActivity = 'SI' AND DATASTypeField='Table 2', StepAtividade )

Then you can go to Document Properties and the Trigger tab.

Here you will find Variable Event Triggers and you can select your newly created variable and select OnChange Add Action(s) to it. Amongst the actions you can select ADD / SELECTION / SELECT IN FIELDS.

[fashid]

Hi,

Thanks for your reply.

I tried but maybe i am not getting the entire picture clearly.

I am attaching a copy of my sample app.

Maybe you can see into it .

My requirement  is just to make all selections in the list box created by expression.

Regards

Nadeem

[fashid]

I created a new field in the data model and applied a trigger to select all possible

Thank you gurus for all the help

Regards

nadeem