Forum Engagement Daily Reports

[system]

Daily Forum Report | 02 March 2023

Top 3 Topics with Most Views

(Improvement suggestion) When creating a new variable/argument let us choose type and scope in addition to name made by @Cosmin_Mandoc with 59 views.

Need a help to write a LINQ query for a datatable made by @deepika.garg with 57 views.

How to add backround color/cell color in Gsheet made by @Sidney_Vogel with 46 views.

Top 3 Topics with Most Replies

How to throw BRE properly (error code 1002) made by @Meu_Eu_Nando with 14 replies.

Edge - "Cannot communicate with browser" made by @David_Hernandez2 with 12 replies.

Regex Multiple condition made by @ravindar.singh with 11 replies.

Top 3 Users Who Posted The Most

@Anil_G made 26 posts!

@Yoichi made 22 posts!

@postwick made 17 posts!

Top 3 Most Liked Posts

This post made by @arjunshenoy received 2 likes!

Multiples values SQL Excel

Hi @DimitriLYR Try the following code & let us know if it works: Select * From [Export$] where [Supplier] = '22' AND [Product Code] NOT IN ('101748', '101896') Best Regards.

This post made by @RobertRussell_Monsalud received 2 likes!

The Queue being created in the orchestrator is not being detected in the Studio (REFramework)

Hi @fernando_zuluaga and @Sanjit_Pal Thank you for your inputs and solutions. Both are helpful. I really appreciate it. Best regards, Robert

This post made by @RobertRussell_Monsalud received 2 likes!

Enforcing Unique References in Queue Creation

Hi @arjunshenoy and @GANESH_BALAGAM Thank you for your inputs and solutions. Both are helpful. I really appreciate it. Best regards, Robert

Top 3 Most Liked Solutions

This solution provided by @arjunshenoy received 2 likes!

Multiples values SQL Excel

Hi @DimitriLYR Try the following code & let us know if it works: Select * From [Export$] where [Supplier] = '22' AND [Product Code] NOT IN ('101748', '101896') Best Regards.

This solution provided by @Anil_G received 2 likes!

Change Action Center Port (on-prem) issue

@irahmat I hope this might help you [image] Cheers

This solution provided by @Anil_G received 2 likes!

How to group the row and add the values in the row and copy it to the same datatable

@Demo_User Welcome to the community Please try this in assign activity with the below given formula on right and on left dtoutput… dtoutput = (From d In dtinput.AsEnumerable() Group d By k=d("Name").toString.Trim Into grp = Group Let sum = grp.sum(function(x) cdbl(x("Value"))) Let ra = New Object(){k,sum} Select r = Dtoutput.Rows.Add(ra)).CopyToDataTable() Before this use another assign with Dtoutput = dtinput.Clone() And if not working please confirm if your project is in c# or vb.net Ch…

---

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.