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

Filter plan layer and related layers with a selected plan_id #11

Closed
Tracked by #5
LKajan opened this issue Oct 2, 2024 · 0 comments · Fixed by #37
Closed
Tracked by #5

Filter plan layer and related layers with a selected plan_id #11

LKajan opened this issue Oct 2, 2024 · 0 comments · Fixed by #37

Comments

@LKajan
Copy link
Contributor

LKajan commented Oct 2, 2024

Pre requirement for opening a single plan.

Implement a method to update the "Provider Feature Filter" of plan and related layers to filter only selected plan and related features.

Example WHERE clause for a land_use_area layer would be something like:

-- WHERE
EXISTS (
  SELECT 1
  FROM hame.plan p
  WHERE
    p.id = hame.land_use_area.plan_id
    AND p.id = 'bfaae531-3e8f-4d93-b183-569c73379e56'
)
@LKajan LKajan mentioned this issue Oct 2, 2024
@nmaarnio nmaarnio self-assigned this Oct 2, 2024
@nmaarnio nmaarnio linked a pull request Oct 3, 2024 that will close this issue
@nmaarnio nmaarnio removed their assignment Oct 8, 2024
@Mtk112 Mtk112 linked a pull request Oct 28, 2024 that will close this issue
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
2 participants