Filter management view - request for additional columns

[kitenetter]

Is it possible to add two more columns to this view:
https://irecord.org.uk/filters/admin-list

One for the warehouse user ID, and one for the date the filter was created.

[BirenRathod]

@kitenetter I added two columns now. However, only two filters are working title & description. I need to find out about rest of those fields.

[kitenetter]

Excellent, thanks. I not worried about the filters, as the table can be downloaded and filtered when needed.

[kitenetter]

@BirenRathod the column for "Warehouse Userid" does not contain the data that I expected. E.g. my warehouse id is 50, but in the iRecord table it is showing a range of incorrect values:

Can we change this so that it gives the user id?

[kitenetter]

@BirenRathod this is becoming urgent - are you able to add the user IDs to this view?

If the user ID is not available, the filter ID would be an alternative we could try.

[johnvanbreda]

@BirenRathod the filters_user_id is the ID from the filters_users table, not the users table. If you like I can patch the warehouse to add a user_id column? Or, the filter ID is available in a column called just "id".

[kitenetter]

Just seen that Biren is on leave this week, so I'll find an alternative approach for my immediate requirement. Which means that this issue isn't urgent any more, but would be good to resolve it in future.

[johnvanbreda]

As a very quick fix I can replace the filter user ID column which you don't need with the actual filter ID?

[kitenetter]

Thanks @johnvanbreda that would be helpful. In the longer term it would be hugely helpful if the user ID can be added as well, but the filter ID would be a great stopgap for now.

[johnvanbreda]

I've added a Filter ID column.