Passing filter params to a sub query

0 votes

1 answer

226 views

                          I'd like to create a view from the query below, but the query contains a sub query which I need to apply a filter to (the place is marked with a comment). I'm wondering if it's possible somehow to adjust the query to have the subquery filtered by those params.

The query

    select
     form_name,
     nvl(form_pravo,0) as form_pravo,
     nvl(fl_pravo,0) as menu_pravo,
     menu_nazov as menu_name    
    from(
    SELECT 
        form_name,
        pravo as form_pravo
      FROM (
        SELECT 
            f.ID as form_id,
            f.NAME as form_name,
            f.XF_MODULY_ID as modul_id,
            u.ID as uziv_id,
            f.XF_MODULY_ID       
              FROM xf_forms f, xf_uziv u) uf
           LEFT JOIN
            xp_forms_uzivs fu ON form_id  = fu.XF_FORM_ID AND uziv_id = fu.XF_UZIV_ID
                where modul_id = 14 and uziv_id = 1 -- <--HERE
                )
            full join (
                select 
                    SUBOR,
                    FL_PRAVO,
                    menu_nazov,
                    uziv_id,
                    modul_id
                from xv_uziv_menu              
            ) um on form_name = um.subor
            where uziv_ID = 1 and modul_id = 14
                        

Asked by user49126 (103 rep)

May 20, 2015, 03:11 PM
Last activity: Jun 6, 2025, 03:05 PM

Passing filter params to a sub query

Related Questions