Hello. There is a task to add a filter to the DocumentNumber column on the ApprovalHistory page.
This field was created in the PersonWantsOrg collection as a result of the script "from shoppingcartorder select top 1 displayvalue(documentnumber) where uid_shoppingcartorder = ( select current uid_shoppingcartorder from personwantsorg)"
When the column filter is selected for this field, nothing happens.
When you try to select a filter by the field that exists in the PersonWantsOrg table,it appears, but of course it is filtered on a different field.
The question is whether you can even create a filter on the virtual field created in the collection.
I tried to display everything in the screenshots. Thanks in advance.
