Andrew Christensen replied 6 months ago

In the example shortcode I posted above `[display-frm-data id=354 county="San Diego" industry="Advanced Manufacturing"]` the attributes are `county` and `industry`.

When I add the filters `frm_view_order` or `frm_where_filter` I can't figure out how to get the value of `county` and `industry`. They aren't uri request params.

Victor Font replied 6 months ago

You still use the [get param] shortcode.

Andrew Christensen replied 6 months ago

How do I use that inside the PHP code? I'm needing to take the value of `industry` and query a particular column. I was trying to follow the examples you gave for the `frm_view_order` which worked very well when I have uri request params because in PHP I can get the values using $_REQUEST. But that doesn't work when the params are added as attributes and not in the URI.

In this project, I have 7 possible industries, each with it's own field in the database. What I need to do is get the value of `industry` and then get the entries where the county form field equals the `county` attribute and where the form field for the value of `industry` is greater than 0. In the example above, this would be the field for "Advanced Manufacturing".

I could in the filters for the view select the "Advanced Manufacturing" field and set it to gte to 1 but then that view would only work for that one industry so I'd need to have a separate view built for each industry which is what I'm trying to avoid.