クラシックファイルタイプは、2021年1月をもって使用不可となりました。クラシックファイルを移行するか、PDFをダウンロードすることができます。 詳細を見る

dynamic value as parameter

コメント

3件のコメント

  • Regan

    Hi Ganesh! 

    Let's first try not using a parameter. Let's go ahead and use a filter in the WHERE clause: field_name to filter = current_date. Make sure the field name is a fate datatype. 

    Please let me know if you are still having trouble!

    0
  • Ganesh Karri

    Hi Regan,

    My query is working if I use current date directly in the where condition. The user wants the latest report by default but also want the flexibility to pass a certain date and get report up to that date.

    0
  • Regan

    Ganesh, I spoke with our experts in Wdata and it sounds like as of right now there isn't a way to use a function such as CURRENT_DATE in a calendar-driven parameter. 

    If you would like help with a workaround or another possible solution I would recommend contacting support! I have included their contact information below:

    Phone: 800-706-6526
    Email: Support@workiva.com

    0

サインインしてコメントを残してください。