Hi, I am stuck and would appreciate advice. I have a database of assets. Each asset belongs to a category. Each category has specific set of attributes. I want to be able to choose a category from a dropwdown menu and that will generate a table of assets only from that category with attributes be…

If you are able to obtain a list of columns by category, you could use a :for attribute on the :col slot. def columns(:category_a) do [{"Name", :name}] end def render(assigns) ~H""" <Flop.Phoenix.table items={@items} meta={@meta} path={~p"/items"}> <:col :let={i} :for={{label…

Hello and welcome! Can you share a little more about your data structure? Is category polymorphic or do you mean only some attributes apply to different categories? More broadly, Flop can’t dynamically generate tables based on different schemas (you would have to make a table for each type and sw…

Oh, that’s a pretty good idea :smiley:

Thank you both @sodapopcan @woylie for you answers! :clap: :star_struck: Is there a way to generate filter field for each column as well? Because as I read through the docs, I understand it that I need them to be defined in Flop.Schema.. My idea is that each column has its own field so that user c…

You need to define the filterable fields explicitly by design. Making every column filterable automatically can introduce vulnerabilities. To expand on the answers above, you can retrieve a list of all filterable columns with Flop.Schema.filterable/1 and then get additional information on each fiel…

[image] woylie: You need to define the filterable fields explicitly by design. Making every column filterable automatically can introduce vulnerabilities. Huh? Meaning? Example? :thinking:

If you have a query that returns only some columns to the user, and you allow to filter on columns that are normally hidden from the user, the user can gain insight about the column values just by using filters. For example, you might have a view of users that only shows the age and the city of each…

Thanks, very helpful. I see that we should be adding our own authz / need-to-know-only-basis-filters on top of your stuff which is completely fair. I initially thought that you were saying SQL injections are possible. :scream:

Elixir Programming Language Forum

Dynamically generated columns in flop_table

Questions & Help Questions

sodapopcan April 17, 2025, 5:19pm 4

Oh, that’s a pretty good idea