• Replies 7 replies
  • Subscribers 413 subscribers
  • Views 171 views
  • Users 0 members are here
Related

Next Performance as a custom element in Plans

Anthony Busti
$organization

Hello,

Has anyone successfully added next performance (name/date/time) as a custom element in a constituent plan?  If so, can you share the code that enables this?

Thanks!

Anthony

Parents
  • $organization

    I'm happy to share the line of code for this - just wondering what format you wanted it in........... 

    For example, my string returns the perf details as Jun 14 2018 8:00PM Ex Machina

    select top 1 CONVERT(varchar,perf_dt,100) + ' ' + perf_name from LVS_TKT_HIST where perf_dt >= GETDATE() and customer_no = @customer_no order by perf_dt

    Of course, you should check that the secure view LVS_TKT_HIST is valid for the task - ticket history being usually customised.  This works as either a Flex Header or Portfolio element.

    Martin  

Reply
  • $organization

    I'm happy to share the line of code for this - just wondering what format you wanted it in........... 

    For example, my string returns the perf details as Jun 14 2018 8:00PM Ex Machina

    select top 1 CONVERT(varchar,perf_dt,100) + ' ' + perf_name from LVS_TKT_HIST where perf_dt >= GETDATE() and customer_no = @customer_no order by perf_dt

    Of course, you should check that the secure view LVS_TKT_HIST is valid for the task - ticket history being usually customised.  This works as either a Flex Header or Portfolio element.

    Martin  

Children
No Data