05Nov
By: Marc Ruel On: November 5, 2021 In: APEX Developer Solutions, Instant Tips Comments: 0

In this episode, Mike Hichwa, co-creator of Oracle APEX demonstrates a tip you can use in virtually any version of APEX. In his demo app, Mike wants to easily find developers for his Project. He adds a select list that shows the best matches at the top of a long list.

 

 

Here is the code Snippet Mike used in his demo

with suggested_developers as (select name, id, count(*) as score from(select 
        dd.name,
        dd.id,
        t.column_value as tag
    from demo_developers dd, 
        apex_string.split(dd.tags, ',') t
    where t.column_value in (select 
            t.column_value as tag
        from demo_projects dp, 
            apex_string.split(dp.tags, ',') t
        where dp.id = 1))group by name, id
    order by 3 desc, 1fetch first 3 rows only
)

See the full episode

Insum's APEX Instant Tips: Every Friday at 12:05pm EST

Join Anton and Hayden every Friday at 12:05pm EST live on our Facebook and YouTube channels, as they present a new APEX tip every week.

Subscribe and hit the bell to be notified so you never miss a thing!

View Past Episodes

Full episode list on YouTube here.

Share this:
Share

Leave reply:

Your email address will not be published.