06-20-2019 06:33 AM
Has anyone written a custom FormFilter and can send me an example?
No Idea which baseclass I have to implement and wha I am supposed to return.
I want to join some values from a status colmn. With the standard filter I can only do something like:
<FormField name="STATUS" visible="filter" type="combobox" lov="SQL[select stKey, stValue from dbStatus]" />
where I can filter for 0 ("new") or 1 ("in progress") or 2 ("finished").
What I want to do for example, is fill the combobox with a LIST[...] and then filter with "(STATUS = 0 or STATUS = 1)
07-01-2019 06:55 AM
If I understand you correctly, you are trying to add a filter in the top area above a list?
I can tell you more about my example and you can see if it matches yours.
I have a table where poles are saved and then another table where the types of poles are saved. In the table with the poles, the ID of the type of poles is use as a foreign key.
In the list-view of the workflow, I want to be able to filter according to pole types (but not by typing the ID of the types, but the name of the type).
For this, I use sqlselect to define how the filter works (see below the code and image).
<FormField name="GG170_GG171_ID" label="Typ:" type="combobox" datatype="number" required="true" maxlength="22" persisted="false" sqlselect="SQL[select GG171_MASTARTTEXT from GG171_MASTART where GG170_GG171_ID=GG171_ID]" visible="filter"/>