Advanced search function inside workflow history

[pask]

In order to perform a fast and correct bug fix we need to be able to search inside all workflow history for a specific key, contained for example in the input parameters or inside any block in task execution.

Thanks in advance

Pasquale

[shakir-karim]

There is a feature enabled in your sandbox environment today that will move to production in February that can help with this use case. 

We are now exposing workflow details for advanced search and extraction using Data Query. Documentation specifically on this capability is being created in preparation for production / general availability, but in the meantime please do try it out and give us feedback. 

Steps

• Navigate to Data Query (under Platform) within your sandbox
• Use 'Describe workflow' to return the fields you can query on for workflow setups or runs
• Use 'Describe task' to return the list of fields you can query on for task setups or runs
• Use 'Describe api_call' to return the list of fields you can query on for API calls made by workflow on the tenant's behalf
• Use 'Describe linkage' to return the list of fields you can query on for linkage and flow details between workflow tasks
• Use 'Describe task_usage' to return the description of fields you can query on for workflow volume data.
• Refer to documentation on Data query to understand how to create your query (return data, join returning data, limiting results, etc)
• Post to our Data Query Forum if you need help in crafting your query.
• Create new ideas if you have additional enhancement requests. 

Thanks!

[pask]

Hi,great, thanks for this enhancement. It will be very useful in creating workflow that automatically re-executes failed tasks without opening them manually and also to derive reports in general.

I'll test it in these days. 

Regards

Pasquale

[pask]

Hi, we tested today in our EU Sandbox with Tenant ID: 2000247 in entity Enel X UAT Spain B2C (8adc8f996a06ca08016a0c704a45025d).

All describe statement that you shared are not working. If we perform show tables mentioned tables are not showed.

Thanks in advance

Pasquale

[shakir-karim]

Hey @pask, we deployed to US environments this week and target for EMEA next. Apologies, I should've been more clear. I'll message once available. Thanks!

[pask]

Hi @shakir-karim , is it possible to enable it on my training test sandbox? it is apisandbox.zuora.com. TenantID: *

Thanks in advance 

Pasquale

* removed

[pask]

Hi @shakir-karim I've opened a Zuora Support Ticket for my last request *

Regards

Pasquale

* removed support ticket url

[D1eg0v]

Hi @shakir-karim 

could you please give us updates on this functionality? When it is planned to be released in EU prod environment? Do we have a link to the documentation?
Thanks a lot in advance.

[shakir-karim]

Feature has deployed to all sandbox instances, and is targeted for production release March 4th. Please do test out in your sandbox, and provide feedback when you have a moment! 

Documentation:

https://knowledgecenter.zuora.com/Central_Platform/Workflow/Using_Workflow/Use_Data_Query_to_report_...

[shakir-karim]

Note: We received usability feedback on this feature and will be making the following update before moving the feature to your production tenants.

"Prefix the object names with workflow to allow easier search-ability, visibility and usability" 

Existing object / table name	New object / table name
workflow	workflow (no change)
task	workflow_task
linkage	workflow_linkage
api_call	workflow_api_call
task_usage	workflow_task_usage