2022 Oct 19 11:19 AM
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
2022 Oct 19 12:19 PM
2022 Nov 02 10:28 AM
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.
2022 Nov 02 12:42 PM
Look in Code options of SQ02, there is a AT SELECTION-SCREEN OUTPUT section, there you can
2022 Nov 02 2:32 PM
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.
2022 Nov 02 1:19 PM
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.
2022 Nov 02 2:16 PM
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)