Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Parameters to filter data in a SQL query #267

Open
vladimir-rybalko opened this issue Oct 13, 2021 · 2 comments
Open

Parameters to filter data in a SQL query #267

vladimir-rybalko opened this issue Oct 13, 2021 · 2 comments
Labels

Comments

@vladimir-rybalko
Copy link

Hi!

I try configure t_rex for display more than 7k points from PG.
Each user have uid in database. I want filtering data that belongs to the user.
How can I pass a parameter to filter data in a SQL query?

@pka pka added the question label Oct 28, 2021
@pka
Copy link
Member

pka commented Oct 28, 2021

There is no built-in way to pass a parameter at runtime. What comes close is some cases is using the templating functionallity of the config file like in this example. In your case you could create a layer for each uid, but that's probably not what you want.

@pka
Copy link
Member

pka commented Oct 28, 2021

After beeing reminded of #204, I think that runtime query parameters have a major drawback, because they make tile caching a lot more complicate.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

2 participants