Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

prefilter in the infoset (sq02) or the query (sq01)

former_member827229
Discoverer
0 Kudos
1,050

Hi Team!

I want to use a query from the asset table (ANLA), but I want to see only the active items. I can solve it so that I can filter on a selection screen, but my boss wants the filter not to appear. Is it possible to prefilter in the infoset (sq02) or the query (sq01)?

Best regards!

Tom

6 REPLIES 6

Sandra_Rossi
Active Contributor
0 Kudos
864

You can hide the parameter in the query.

former_member827229
Discoverer
0 Kudos
864

Dear Sandra!

I searched in sq01 but couldn't find an option to hide it.

I will try to approach it from another place:

The ANLA board contains the date of deactivation (ANLA-DEAKT). I want only the active devices to be visible.

I also tried in the infoset (SQ02).

I can't give it the parameter so that only it is visible (DEFAULT '00000000'). It does not accept it.

I created an additional field for it (deakt_1).

If anla-deakt>0. deact_1='d'. else. deakt_1='a'. endif.

I can set "a" as the default value, but I don't want the filter condition to be visible.

raymond_giuseppi
Active Contributor
0 Kudos
864

Look in Code options of SQ02, there is a AT SELECTION-SCREEN OUTPUT section, there you can

  • provide a default value to a parameter/select-options
  • hide and protect this parameter/select-options

0 Kudos
864

Try to keep the parameter initial (e.g. clear it) or use a select-option with a default value such as I/LT/ 02.01.0001.

former_member827229
Discoverer
0 Kudos
864

Dear Raymond!

That's the point. The active device does not have a deactivation date (it shows in the query as 0000.00.00, but cannot be set as DEFAULT). If I could define it, the problem would be solved. But I do not know.

And I cannot parameterize the additional field, because it cannot be added to LIKE.

Besides the date of deactivation, is there anything else that indicates deactivation? Because then I would create a parameter for that.

0 Kudos
864

Don't use Answer option but comment an answer. (this answer option is reserved to answer to the original (your) question. - read the 'Before answering' text at lower right)