Forum Engagement Daily Reports

[system]

Daily Forum Report | 26 January 2022

Top 3 Topics with Most Views

Http request set Variable made by @FingFong with 44 views.

Need help in getting calculated values in a data table column without looping and grouping based on another column made by @sharazkm33 with 43 views.

Cron, two different hours on the same day? made by @Aguirre with 43 views.

Top 3 Topics with Most Replies

Http request set Variable made by @FingFong with 15 replies.

フォルダ名に変数をいれたい made by @YYYYYYY with 12 replies.

Merge 3 datatables with the same column name into one with different column names made by @RaduNRV with 9 replies.

Top 3 Users Who Posted The Most

@ppr made 24 posts!

@Yoichi made 23 posts!

@Nithinkrishna made 17 posts!

Top 3 Most Liked Posts

This post made by @guenter.schramm received 3 likes!

Execute database query but don't wait for the results

Hi, I solved this in a different way: I’ve created an Elastic Job Agent (free Azure feature). That agent has a job configured with excutes my stored procedure. The uipath robot is no longer calling “exec ” and then waits till it’s finished (20-25min later). Instead it now calls “exec ” which immediately returns and the process resumes and finishes without a 20-25min waiting period. The elastic job agent is actually starting the job almost immediately so I’m not losing any time here.

This post made by @Yoichi received 2 likes!

Convert Datarow into list of datarow

Hi, Do you mean add DataRow instance to List of DataRow using Assing activity? If so, can you try the following? listDataRow = listDataRow.Concat({dr}).ToList() Regards,

This post made by @ppr received 2 likes!

Convert Datarow into list of datarow

the lazy approach: {YourDataRowVar}.toList()

Top 3 Most Liked Solutions

This solution provided by @guenter.schramm received 3 likes!

Execute database query but don't wait for the results

Hi, I solved this in a different way: I’ve created an Elastic Job Agent (free Azure feature). That agent has a job configured with excutes my stored procedure. The uipath robot is no longer calling “exec ” and then waits till it’s finished (20-25min later). Instead it now calls “exec ” which immediately returns and the process resumes and finishes without a 20-25min waiting period. The elastic job agent is actually starting the job almost immediately so I’m not losing any time here.

This solution provided by @Nithinkrishna received 1 likes!

Convert Datarow into list of datarow

Hey @Doonline, Kindly find the snippet below. list_DR = new List(Of DataRow)({ DR }) Hope this helps. Thanks #nK

This solution provided by @codemonkee received 1 likes!

Apollo Orchestrator

You cannot initiate an Process from Orchestrator for an Attended Robot. This was restrcited a few versions ago as it would create a risk and potential inconvenience for end users. Process on an attended Robot are invoked directly from Assistant. If you want/need to kick off a process from Orchestrator on the same User/Machine that you are using, you need to also configure your user’s robot with an Unattended Runtime/Robot Credentials in the User’s Profile.

---

That’s it for now, see you tomorrow for a new report!

Don’t forget to share ideas for other fun stuff we should add to the reports here.