Is it possible to display only a few rows from a table in a list object?

[luiz_damascena]

In my script, I load the data from a table via SQL, obtaining the following result, by hypothesis:

code, description

1, FORD

2, VOLKSWAGEN

3, FIAT

I use the code as field in my list object.

But I want that the code 3 not to be displayed, only in this list object.

It would be something like a condition for displaying the line.

I can not put a condition on the select, since the listing with all rows is required to populate other list objects.

And I would not want to replicate SQL, creating another table, without that line.

Is it possible to display only a few rows from a table in a list object?

[stigchel · Accepted solution]

Yes, in the listbox properties scroll down to the end of the fields listed and select use an expression. For this expression use something like

=Aggr(Only({<code={"*"}-{'3'}>} code),code)

[luiz_damascena]

Thank you!

Clean and functional!