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

How can you open search dialog in javascript with a filter

detroit — Tue, 15 Jan 2019 09:39:21 GMT

Hello

as per title - how can we set the filter for search dialog in javascript

var param = {

title: title,

aras: top.aras,

type: 'SearchDialog',

dialogWidth: 700,

dialogHeight: 450,

itemtypeName: 'Part'

};

wnd.ArasModules.Dialog.show('iframe', param).show("iframe", param);

Is it possible to catch an even of this dialog?

Or how can we manually run the opened dialog "search"? The dialog is an iframe and the dijits have no ids

I managed to make it work for test case with, mind you i cannot use this in reality, scope issues

dijit.byId("dijit_form_TextBox_0").setDisplayedValue("3*");

dijit.byId(dojo.query('.dijitButton')[0].attributes.widgetid.nodeValue).onClick()

Thank you

Discussion Starter I

Tue, 25 Feb 2020 08:46:24 GMT

Start a discussion in a forum that receives 5 replies.

Desktop Notification

Suhas — Sat, 22 Feb 2020 17:20:00 GMT

Is it possible to implement Desktop Notification in Aras?

Scenario is.

If user is doing workflow activity sign off. Once it is completed desktop notification (alternative to email notifications) should display to next activity user without using refresh or redirect.

Regards,

Suhas

Ask A Question I

Tue, 25 Feb 2020 08:30:05 GMT

Ask a question in a forum.

Badly formed HTML in Aras FormattedText Fields

JWT007 — Tue, 25 Feb 2020 12:32:21 GMT

I have the following scenario.

I have a report action bound to an item type which performs a REST call to the Microsoft SSRS Report Server with a delimited set of IDs.

The RDL Report performs an SQL query against a fixed ItemType to retrieve the meta-data for the given IDs.

Problem #1:

Several of the fields are of type FormattedText - although the relevant value may only be a few lines of text, Aras packs so much HTML and JavaScript around them that these Fields can exceed 100k characters. If generating an XLS report, there is a hard limit on the length of any given cell (32767 characters) - if this limit is exceeded, the report blows up with a HTTP Response Code error.

Potential Solution #1.

I wrote a simple SQL Function to convert the formatted text field string to XML and back again to a NVARCHAR(max) which effectively strips all XML elements from the text...the *magic* happens in this statement.

-- convert to XML and back to VARCHAR(max) again
SET @result = CONVERT(XML, @result , 1).value('.', 'NVARCHAR(max)');

Problem #2:

In several data sets the FormattedText fields contain HTML string content which is not valid XML. In this case, the conversion function blows up.

Examples:

undefined namespace prefixes: '<o:p>...</o:p>' (note: the prefix can vary)
invalid attribute definitions: '<br \="" ... >

This means I have to identify and correct each special case with time-consuming REPLACE(Column, Find, Replace) calls - a few of those on 100k+ character strings starts to blow up the query times. Only when the string is *clean* can I try to convert it to XML. For example,

SET @result = REPLACE(REPLACE(@result, '<o:p','<p'), '</o:p', '</p');
SET @result = REPLACE(REPLACE(@result, '<u5:p','<p'), '</u5:p', '</p');
SET @result = REPLACE(@result, '\=""', '');

I could go and fix each *special case* with one-time SQL scripts, but I cannot *guarantee* that Aras will not write new fields with invalid XML.

So my question is can Aras take a look at the formatted fields and *guarantee* that they will no longer write poorly-formed XML(HTML). Maybe they could provide an out-of-the-box SQL functionality to make it possible properly prepare FormattedText fields for export.