paul.sheehy@bd.com さんのグループアクティビティ

Searching against a multi value list data type

paul.sheehy@bd.com — Wed, 28 Oct 2020 14:56:25 GMT

Good morning!

I currently use the multi value list data type for a product line property in my Part item type. Our products share a lot of subassemblies and components, so any particular part could be assigned to multiple product lines. This makes sense on the part form, where the user can see Part 123 is a member of Product Line A, B, and C for example.

However, this data type has one major drawback that I have not figured out how to overcome: searching. By default, the multi value list uses the 'AND' operator when evaluating multi value list selections as search critera.

For example:

In the Part search grid, if you select Product Line A and search, Aras will return parts with ONLY Product Line A selected; Parts with Product Line A & B, or A B & C will be excluded.

In addition, because the data type is a multi value list and not text, users cannot use wildcard characters in the search bar for this property.

These 2 issues severly limit the usability of the multi value list data type as search criteria. Intuitively, I believe users select Product Lines in their search criteria under the assumption of the 'OR' operator: selecting Product Line A, B means I would like to see parts that are under either Product Line A OR Product Line B OR both.

I've thought about a method that copied the multi value list to a separate property that is text (ex: 'A, B, C'). This would give the user the ability to search with wildcards, but would not help when searching multiple values because then the order of the values in the list would determine the results (ex: with A, B, C = searching *A*C* will work, but searching *C*A* will not).

Has anyone else run into this scenario and come up with a solution?

Currently running 12SP7.

Thanks!

Paul Sheehy

configure email notification

Former Member — Fri, 01 Dec 2017 06:04:20 GMT

Hi, Requirement : on a document form, we attach some doc files. once we fill up mandate fields, then we type the email or selecting the email from drop down menu list. Once we click on green colour tick mark then the attachment what we attached that should be shared to the email which we provided. Please help me. how to take it forward.

Automate download of CAD files to send to Supplier

paul.sheehy@bd.com — Thu, 05 Dec 2019 02:36:40 GMT

Good evening, my Purchasing team is constantly getting Suppliers to quote building a certain assembly. In order to prepare the quote, the Supplier needs all of the SolidWorks CAD files from Aras. This means the parent SLDASM and all related child SLDPRT files. Currently, the Purchasing team is downloading these files 1-by-1 from Aras, before emailing them to the Supplier.

This seems like a fairly common industry task. Has anyone done any development to automate this, specifically the recursive file download? I've seen a GitHub project to download multiple file attachments via a single action, but this is a slight different use case.

Thanks in advance!

Paul Sheehy

Bypassing Check Escalations for active workflows

paul.sheehy@bd.com — Wed, 25 Aug 2021 20:09:00 GMT

I am looking to implement Check Escalations in my org, but I do not want to affect any active workflow. I would only like new change processes created moving forward to follow the new escalation process. Does anyone know the specific criteria 'Check Escalations' is using? Is this possible?

I've tried clearing out the 'escalated_to' and 'expected_duration' properties on the active activity on active workflows prior to running 'Check Escalations' method, but the activity assignments are still escalated.

Or if there is a better practice for managing existing workflows when trying to implement a check escalations process, I would appreciate the feedback.

Thanks,

Paul Sheehy

Logging Escalation events

paul.sheehy@bd.com — Fri, 16 Apr 2021 13:18:35 GMT

I'm about to implement an Escalation process in my ECO workflow and am exploring ways of logging/tracking when onEscalate events occur.

Currently for my ECO Review activity, I have duration and reminder count set so users receive email reminders when they have open tasks to review. Soon I will add escalate_to identities for each assignment and add the 'Check Escalations' method to the Scheduler service. I have been exploring ways of logging when task assignments are escalated, creating a metric I can report on. Adding a server event to the activity and set to onEscalate does indeed fire when appropriate, but I am not able to grab the task assignment details of what is being escalated. I also learned the onEscalate server event will fire separately for each task being escalated, not just once for the activity.

Does anybody have any experience with this? I'd like to capture, for example: The review task assignment for this identity, on this workflow, was escalated to this identity, on this date.

Thanks!

Paul

Printing Aras forms in 11SP15

paul.sheehy@bd.com — Fri, 15 Nov 2019 13:30:11 GMT

Good morning all, I have an Aras form for non-conforming material that needs to be printed in order to travel with the bad part. I already have the separate form designed with view type=print, but i'm looking for documentation on additional configuration options, such as:

1. The Printable View action (File/Printable View, Toolbar Print icon) displays a preview popup window and then downloads a PDF. Is this the only option? Can I send the print job to my default printer instead?

2. The Printable View appears to be oriented in Landscape regardless of the dimensions I set on the form. When I print the PDF (even with my printer set to Portrait), the form prints in Landscape. Is there a way to change this?

3. Is there a way to call an item form to be printed programmatically?

Thanks,

Paul S

Uploading a local file to Innovator using the Batch Loader

cambrianexplosion — Thu, 23 Jul 2020 20:38:48 GMT

I'm having issues uploading a local file to an instance of Innovator using the Batch Loader. I have the following XML:

This currently fails. I had to search to find out the <actual_filename> tag is used for the fully qualified path of the file, yet it is not present in the File Item when inspecting it through Innovator Client.

Any help with this would be appreciated.

using the SQL item type as a view

paul.sheehy@bd.com — Wed, 29 Jan 2020 04:07:52 GMT

Querying a SQL view I built in SSMS from an Aras server method:

string SQL_View = "innovator.my_custom_sql_view";

string SQL = "select * from " + SQL_View;
Item SQL_qry = inn.applySQL(SQL);

This is quick for me because I do a lot in SQL, but I know it is bad practice. So, I want to replace this SQL injection using IOM:

I created a new SQL item, type=View, with the contents from the custom SSMS view.

What is the correct C# code to get the view results?

Item SQL_qry = inn.newItem("SQL", "get");
SQL_qry.setProperty("keyed_name", SQL_View);

SQL_qry = SQL_qry.apply();

This code just gets the SQL item, not the contents of the View.

I couldn't find anything in the Programmers guide for this, and the Blog posts were only about Stored Procedures, not Views.

I'm thinking it should work the same way, but I haven't figured out the correct IOM syntax.

Thanks,

Paul Sheehy

Discussion Starter I

Tue, 19 Nov 2019 14:59:05 GMT

Start a discussion in a forum that receives 5 replies.

optgroup element

paul.sheehy@bd.com — Mon, 21 Oct 2019 19:40:12 GMT

Does Aras (specifically 11SP15) support the ability to add optgroup elements to a drop-down list?

Ask A Question I

Mon, 21 Oct 2019 03:56:12 GMT

Ask a question in a forum.

Usage Reporting

paul.sheehy@bd.com — Wed, 09 May 2018 12:26:02 GMT

Good afternoon, I'm looking to create some internal reports on Aras usage, tracking # of logins, time logged in, and possibly # of concurrent users. Is there any community solutions available already for generating these types of reports? Thanks, Paul

paul.sheehy@bd.com さんの グループ アクティビティ

Searching against a multi value list data type

configure email notification

Automate download of CAD files to send to Supplier

Bypassing Check Escalations for active workflows

Logging Escalation events

Printing Aras forms in 11SP15

Uploading a local file to Innovator using the Batch Loader

using the SQL item type as a view

Discussion Starter I

optgroup element

Ask A Question I

Usage Reporting

paul.sheehy@bd.com さんのグループアクティビティ