How to hide some values in the current selection box from being displayed. Since it is confusing for the end user to understand the selections. I want to hide some selecetions, so the current selections box is easy to understand.
The way to do this is to use the HidePrefix value in the load script, this will make sure that certain fields can be selected but will never show up on the current selections box.
In the load script, somewhere at the start, add the line:
SET HidePrefix='%';
Then, whenever you want a field to be selecteable, but not included in the current selections box, you need to alias it like this:
LOAD A, B, C AS %C FROM TableName;
So, field C can be selected, but will not appear in the selections box.
Note: the % symbol is what I use, but you can use anything you like in there.
