Don Jackson さんのグループアクティビティ

Query Definitions - Removing duplicate rows / returning a single relationship row

Don Jackson — Wed, 02 Aug 2023 18:12:20 GMT

Hello all. I am adding more information to the 'BOM Structure' tgv query and could use some help in removing duplicate rows. Although I know various ways of handling this in SQL, I have not been able to arrive at a solution using where or join conditions in this Query Definition.

In this case, I want to display a link to the items CAD drawing viewable. The below query outputs the correct results (using a foreign CAD classification property) however there are occasions where the Part CAD relationship may have been been accidentally created twice. Ideally, I would only return the first row.

Here is a screenshot of the query definition:

Here is what the output looks like:

Any help is appreciated. Thank you

SSVC email message contains incorrect item URL - how to modify?

Don Jackson — Wed, 09 Nov 2022 19:08:31 GMT

Hello all,

I am currently testing SSVC email notifications and notice they are showing the wrong URL for the Item link, using 'localhost' as the prefix. I have checked all my configuration files and do not appear to be using localhost anywhere. Where is the email notification pulling this value from and/or how can I modify the format? The email message template doesn't have a typical query string and shows the following:

<table border="0" cellspacing="0" cellpadding="0" id="templateContainer" style="font-family: Arial,Helvetica,sans-serif; max-width: 600px">
   <tbody style="max-width: inherit;">
       <tr>
           <td style="border-bottom: 1px solid #d4d4d4; padding-bottom: 10px; color: #444444">{NotificationDescription}</td>
       </tr>
       {Messages}
   </tbody>
</table>

Any help is appreciated. Our version is Innovator 12 SP14.

Ask A Question I

Wed, 09 Nov 2022 19:08:32 GMT

Ask a question in a forum.

Don Jackson さんの グループ アクティビティ

Query Definitions - Removing duplicate rows / returning a single relationship row

SSVC email message contains incorrect item URL - how to modify?

Ask A Question I

Don Jackson さんのグループアクティビティ