Hello together,
the plugin "struct" provides aggregations as selection on the database. For example, the syntax for a table is as follows:
---- struct table ----
schema : akat
cols : matnr, benenn
headers : Material, Benennung
filter : p1 = $STRUCT.akat.p0$
or : p2 = $STRUCT.akat.p0$
----
My idea now is to use a new plugin (e.g. "structfiltertable") to extend the tabular aggregation with queries on the "cols" level, for example in this form:
---- struct filtertable ----
schema : akat
cols : matnr, benenn, $SFILT(p1=$STRUCT.akat.p0$,"X","-")$, $SFILT(p2=$STRUCT.akat.p0$,"X","-")$
headers : Material, Benennung, P1, P2
filter : p1 = $STRUCT.akat.p0$
or : p2 = $STRUCT.akat.p0$
----
Using the filter conditions "filter" and "or", all database entries would first be searched for that match one of the three conditions.
Using the suggested syntax
"$SFILT(p1=$STRUCT.akat.p0$, "X","-")$"
a further filter would be possible, which works additively on column level and sets the values "X" or "-" in the example.
Who could develop such a plugin?
Many greetings
Juergen from Cologne