jo-ka
Member
Hello.
I have a list with club player records, and I need to set if their renewall for the current season is OK. This is like a status field, on/off, 0/1, enabled/disabled, whatever.
The question is that I need to do this based on the season, this is, I have another list where I have the seasons records and if it's the current season.
So I've set a databasejoin field from the players list to seasons list, where I can filter the current season with a pre-filter and get the id. If I do this mannually it works OK.
Now, what i need is to have a button plugin, update_col, so that the user do'nt have to edit the record to set the season mannually. But I can't figure out if it's possible to have an sql query on the update_col value field, as we have for example in pre-filters, like:
Field Value
{fab_players___season_raw} IN select fab_seasons.id from fab_seasons where fab_seasons.status = current
Is it possible to do this?
Thanks in advance.
I have a list with club player records, and I need to set if their renewall for the current season is OK. This is like a status field, on/off, 0/1, enabled/disabled, whatever.
The question is that I need to do this based on the season, this is, I have another list where I have the seasons records and if it's the current season.
So I've set a databasejoin field from the players list to seasons list, where I can filter the current season with a pre-filter and get the id. If I do this mannually it works OK.
Now, what i need is to have a button plugin, update_col, so that the user do'nt have to edit the record to set the season mannually. But I can't figure out if it's possible to have an sql query on the update_col value field, as we have for example in pre-filters, like:
Field Value
{fab_players___season_raw} IN select fab_seasons.id from fab_seasons where fab_seasons.status = current
Is it possible to do this?
Thanks in advance.