얌마들아 어떠냐? 쌔끈하지?


(%read-db-objects nil

                  (resource-record-name->meta-resource "Campaign")

                  {:$filter "name=test AND title is not null"

                   :$top 100

                   :$skip 10}

                  false)

                  

=>


WITH main_campaign AS (

SELECT headline,email,sys_ctime,end_date,name,sys_activep,type,event_oid,defaults,title,

     url_slug,promoter,oid,presentation,registration,start_date

FROM campaign

WHERE sys_activep = $1 and name = $2 and title is not null)

SELECT main_campaign.*,ROW_TO_JSON(s_event) AS event,

     ARRAY_TO_JSON(ARRAY_AGG(ROW_TO_JSON(s_available_actions))) AS available_actions

FROM (SELECT event.oid,event.name,event.description,event.start_date,event.end_date,

             event.location,event.time_zone

     FROM main_campaign,event WHERE event.oid=main_campaign.event_oid)

     s_event,

     (SELECT campaign_available_action.oid,campaign_available_action.type,

             campaign_available_action.channel,campaign_available_action.target,

             campaign_available_action.points,campaign_available_action.additional_info,

             campaign_available_action.sys_ctime

      FROM main_campaign,campaign_available_action

      WHERE campaign_available_action.campaign_oid=main_campaign.oid)

      s_available_actions,

      main_campaign

GROUP BY main_campaign.headline,main_campaign.email,main_campaign.sys_ctime,main_campaign.end_date,

     main_campaign.name,main_campaign.sys_activep,main_campaign.type,main_campaign.event_oid,

     main_campaign.defaults,main_campaign.title,main_campaign.url_slug,main_campaign.promoter,

     main_campaign.oid,main_campaign.presentation,main_campaign.registration,

     main_campaign.start_date,s_event.*

ORDER BY main_campaign.oid ASC

OFFSET 10

LIMIT 100