Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
If I do certain filters (for example if I choose my DES_REFERENT field) I notice that in the object where the list of filters is displayed I learn a filter that I have never put, and I would not want it, on what does this behavior depend?
For example:
it has been inserted autonomously and I would not want it, because if I change the filter in DES_REFERENTE this previous CD_FORNITORE limits me the view of the rows (which should not have selected it)
I find the problem:
I have the trigger:
on each selection
this:
and in the expression i have this: =if(UPPER(OSUSER())='THISTHISTHIS','VALUE',CD_FORNITORE)
Hi, This behaviour can be caused beacuse of an Aggr() function, like Aggr(DES_REFERENT, CD_FORNITORE), this will show DES_REFERNT values but the selections will be done in CD_FORNITORE.
This value can also be set by triggers.
do you mean that somewhere in some expression around there might be an AGGR function causing this behavior?
If this is a filter that exists when the app is opened most propably it's because of a trigger, open configuration menu -> document properties ->triggers, there may be something that makes actions on start, it could be direct actions to select values or executing a macro that makes the selctions
No, it is not a trigger and CD_FORNITORE is not set by anyone as a filter
How can I find if there is an AGGR function in one of the expressions used (there are a lot of them)
Is the value selected when you open the app?.
Aggr will only select values in another field when user selects a value, or by a trigger.
There is also the option that CD_FORNITORE field has the option to 'always one value selected' ebnabled, you can add a list with this field to check if it has the option enabled.
Is the value selected when you open the app? NO
I DON'T have a filter that works on CD_FORNITORE, so I don't understand why it is selected if I select DES_REFERENT
so i think it may depend on an Aggr, as you said earlier, but how can i find where this Aggr expression is in the whole document?
If it's done when you select DES_REFERENT you have to check the object where you are selecting the values to see if it's using an aggr.
This would be easier if you can upload a sample to check
in the object i have this expression (the object is a listbox):
=aggr(Concat(DISTINCT {<DES_REFERENTE=P(DES_REFERENTE), DES_REFERENTE=>} DES_REFERENTE), DES_REFERENTE)
when i choose one.... it put in the selection CD_FORNITORE