Skip to main content
gabrield295009
gabrield295009
October 30, 2024
Question

Can I add pv! data to a task report?

  • October 30, 2024
  • 9 replies
  • 0 views

Hello,

I am trying to add pv! data to a task report but it always comes out empty. 

My data definition is: pv!record[W1182 Solicitud.idCategoria]

formatting: number 

It does not display any information. All information I request using tp! works fine. 

Am I doing it wrong? or is it not possible to display rv! info in the report?

Thank you

9 replies

parthasarathym6661
parthasarathym6661
October 30, 2024

Hi, In the task report, its not possible to display the record variable rv! .

    gabrield295009
    gabrield295009Author
    October 30, 2024

    Thank you Partha. I want to have a read only grid that displays active tasks but it also shows recordType information. Is that possible?

    somasundaram.d
    somasundaram.d
    October 30, 2024

    If you referenced a record data type as a column in the report, it will not display in the report designer; however, you can still query this data using a!queryProcessAnalytics().

      gabrield295009
      gabrield295009Author
      October 30, 2024

      Hi Soma, thank you. When I add the data on the report and use a!queryProcessAnalytics() the data shows null for the new value. Is there something else I need to do?

      peter.lewis
      peter.lewis
      Employee
      October 31, 2024

      You cannot index data from a specific record type, but if you pass the entire variable it should work. So instead of doing pv!record[W1182 Solicitud.idCategoria], just make the column pv!record. Then when you use a!queryProcessAnalytics you should see all the data there (and you can index from your expression rule / interface).

      stefanhelzle0001
      stefanhelzle0001
      October 30, 2024

      I wrote a blog post about this topic: https://appian.rocks/2024/03/13/searching-for-users-in-process-reports

      Record types are not supported as of now. In the past, I just added one PV of type text and just added any values to it in a semi-colon separated string.

        shanmathip7466
        shanmathip7466
        October 30, 2024

        Currently record type variables are not supported in Any Appian Reports (Task, Process or Process Model). If you want one or two record fields in your report's column you can save the value in two different Process variables in the model and access that in Report.

        If you want all the fields values in record, you can follow the [mention:a11f77a729fb4db2af76b09948583328:e9ed411860ed4f2ba0265705b8793d05] suggestion to add all values in a text pv

          gabrield295009
          gabrield295009Author
          October 31, 2024

          Thank you! I checked out Stefan's suggestion but I did not need all the values so this was the easiest solution.

            Terms & ConditionsAccessibility statement