<?xml version="1.0" encoding="UTF-8" ?>
<?xml-stylesheet type="text/xsl" href="https://www.aras.com/community/cfs-file/__key/system/syndication/rss.xsl" media="screen"?><rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/"><channel><title>hadrien.guiducci さんの グループ アクティビティ</title><link>https://www.aras.com/community/members/hadrien.guiducci</link><description>hadrien.guiducci さんの グループ ユーザーの最近のアクティビティ</description><dc:language>ja-JP</dc:language><generator>Telligent Community 12</generator><item><title>Displaying HTML in Aras Innovator</title><link>https://www.aras.com/community/b/english/posts/displaying-html-in-aras-innovator</link><pubDate>Thu, 07 Feb 2019 14:00:00 GMT</pubDate><guid isPermaLink="false">916d3f7e-8ddc-42f8-8d45-380822f51406:e16d6672-4ef5-4655-90d5-222f47d05ddc</guid><dc:creator>Christopher Gillis</dc:creator><description>&lt;p&gt;Whether it&amp;#39;s enabling administrators to create custom Forms or change the default user interface through CUI, Aras Innovator allows for easy configuration of the out-of-the-box client. However, there are still times when a particularly complex UI will require custom HTML to be written. In these cases, Aras Innovator still makes it easy to plug HTML directly into the client. In this blog post, we&amp;#39;ll cover three different ways that we can display HTML to our users.&lt;/p&gt;
&lt;h2&gt;From the TOC&lt;/h2&gt;
&lt;p&gt;The first method&amp;nbsp;we&amp;#39;ll cover is how to display an HTML file when the user selects an item in the TOC. This method of displaying HTML is actually built right into the Aras Innovator client and doesn&amp;#39;t require any additional coding beyond what&amp;#39;s already included in the HTML file.&lt;/p&gt;
&lt;p&gt;We&amp;#39;ll start by creating a new ItemType that will serve as the hub from which this HTML file will be called. For demonstration purposes, we&amp;#39;ll name this ItemType&amp;nbsp;&lt;strong&gt;HTML View&lt;/strong&gt;. Once we&amp;#39;ve created this ItemType we&amp;#39;ll navigate to the&amp;nbsp;&lt;strong&gt;TOC View&lt;/strong&gt; relationship tab and add a relationship to an Identity who will be able to see this custom view instead of the standard grid. You can even define different views for different Identities! Once we&amp;#39;ve created the new&amp;nbsp;&lt;strong&gt;TOC View&lt;/strong&gt; relationship, we&amp;#39;ll set the&amp;nbsp;&lt;strong&gt;Start Page&lt;/strong&gt; to the relative path of our HTML file in the code tree. You should define this relative path in relation to the&amp;nbsp;&lt;strong&gt;/Innovator/Client/scripts/&lt;/strong&gt; folder. For example, if your HTML file were in the&amp;nbsp;&lt;strong&gt;/Innovator/Client/customer/&lt;/strong&gt; folder, your relative path would be&amp;nbsp;&lt;strong&gt;../customer/test.html&lt;/strong&gt;.&lt;/p&gt;
&lt;p&gt;One thing to note is that this&amp;nbsp;&lt;strong&gt;Start Page&lt;/strong&gt; property just needs to point to an HTML source, so you can even pass in the URL to a website. To try this out, let&amp;#39;s pass in the &lt;a href="https://www.aras.com/"&gt;Aras website&lt;/a&gt;&amp;nbsp;as our Start Page and see what happens.&lt;/p&gt;
&lt;p&gt;&lt;img alt=" " src="/resized-image/__size/500x256/__key/communityserver-blogs-components-weblogfiles/00-00-00-00-04/1616.Aras-Website-in-main-grid.png" /&gt;&lt;/p&gt;
&lt;p&gt;Note that this may not work for every website.&amp;nbsp;&lt;/p&gt;
&lt;h2&gt;From a Dialog&lt;/h2&gt;
&lt;p&gt;Displaying HTML from the Table of Contents is a great way to display information in something like a dashboard. However, a different approach is more effective when&amp;nbsp;we just need our users to perform some action or data entry. To do this, we can use our custom HTML page from a popup dialog using the sample below.&lt;/p&gt;
&lt;p&gt;&lt;a href="https://gist.github.com/cgillis-aras/dd1fb4fced517a9af0f46d35996eeb6a"&gt;gist.github.com/.../dd1fb4fced517a9af0f46d35996eeb6a&lt;/a&gt;&lt;/p&gt;
&lt;p&gt;You can check out our blog post on &lt;a href="/b/english/posts/tech-tip-opening-a-custom-dialog-from-a-method"&gt;Opening Custom Dialogs&lt;/a&gt;&amp;nbsp;for more tips like how to return data that a user enters in your custom dialog!&lt;/p&gt;
&lt;h2&gt;From a New Tab&lt;/h2&gt;
&lt;p&gt;The last approach we&amp;#39;ll go over is how to display HTML in a new tab within the Aras Innovator client.&amp;nbsp;You can do this with code similar to the sample below.&lt;/p&gt;
&lt;p&gt;&lt;a href="https://gist.github.com/cgillis-aras/cadbcb2624f8888699a6506483d20e1d"&gt;gist.github.com/.../cadbcb2624f8888699a6506483d20e1d&lt;/a&gt;&lt;/p&gt;
&lt;p&gt;Please note that if you choose to use your own HTML page, you should use CSS to set a background color for the page.&amp;nbsp;While writing the sample above, I did this using the&amp;nbsp;&lt;strong&gt;bgcolor&lt;/strong&gt; attribute on the body tag like so: &lt;code&gt;&amp;lt;body bgcolor=&amp;quot;#FFF&amp;quot;&amp;gt;&lt;/code&gt;. If you don&amp;#39;t do this, you&amp;#39;ll notice that your HTML page appears to be drawn over the main grid.&lt;/p&gt;
&lt;p&gt;Just like with the TOC, we can even pass in websites to be displayed within a tab!&lt;/p&gt;
&lt;p&gt;&lt;img alt=" " src="/resized-image/__size/500x480/__key/communityserver-blogs-components-weblogfiles/00-00-00-00-04/8400.Aras-Website-in-Tab.png" /&gt;&lt;/p&gt;
&lt;h2&gt;Conclusion&lt;/h2&gt;
&lt;p&gt;If you have any ideas of how you could use these techniques or if you have a story about how you&amp;#39;ve already used these techniques, please leave a comment below!&lt;/p&gt;&lt;div style="clear:both;"&gt;&lt;/div&gt;</description></item><item><title>12sp05 packaging error on a simple item  with ITPresentationConfiguration</title><link>https://www.aras.com/community/f/development/9383/12sp05-packaging-error-on-a-simple-item-with-itpresentationconfiguration</link><pubDate>Thu, 26 Mar 2020 08:37:40 GMT</pubDate><guid isPermaLink="false">916d3f7e-8ddc-42f8-8d45-380822f51406:59f916b4-eff5-4db4-a2bc-9af7cc07ec23</guid><dc:creator>hadrien.guiducci</dc:creator><description>&lt;p&gt;Hi,&lt;/p&gt;
&lt;p&gt;&lt;/p&gt;
&lt;p&gt;I get a message I never saw while creating a package. I thougth it was due to a missing element but I reproduce it only by&lt;/p&gt;
&lt;p&gt;- 1 creating a simple object&lt;/p&gt;
&lt;p&gt;- add the TOC access (and permission/creation)&lt;/p&gt;
&lt;p&gt;- add it to a new package (1 form+ 1 item)&lt;/p&gt;
&lt;p&gt;- Then export it&lt;/p&gt;
&lt;p&gt;- and try to import it to a brand new db from the 12sp innovator backup db...&lt;/p&gt;
&lt;p&gt;I get that message :&lt;/p&gt;
&lt;p&gt;DELAYED RESOLUTION: applying AML &amp;lt;Item type=&amp;#39;ItemType&amp;#39; id=&amp;#39;D9D992E995EC41BB8B6B852510384D05&amp;#39; action=&amp;#39;edit&amp;#39; doGetItem=&amp;#39;0&amp;#39; version=&amp;#39;0&amp;#39;&amp;gt;&amp;lt;Relationships&amp;gt;&amp;lt;Item type=&amp;quot;ITPresentationConfiguration&amp;quot; id=&amp;quot;9807CFE5BF3BD9466B77D6069BFA2DFF&amp;quot; action=&amp;quot;add&amp;quot;&amp;gt;&amp;lt;client&amp;gt;js&amp;lt;/client&amp;gt;&amp;lt;related_id keyed_name=&amp;quot;tr_i001_project_TOC_Configuration&amp;quot; type=&amp;quot;PresentationConfiguration&amp;quot;&amp;gt;9807CFE5BF3BD94636326AA7318BB90D&amp;lt;/related_id&amp;gt;&amp;lt;sort_order&amp;gt;128&amp;lt;/sort_order&amp;gt;&amp;lt;source_id keyed_name=&amp;quot;tr_i001_project&amp;quot; type=&amp;quot;ItemType&amp;quot; name=&amp;quot;tr_i001_project&amp;quot;&amp;gt;D9D992E995EC41BB8B6B852510384D05&amp;lt;/source_id&amp;gt;&amp;lt;/Item&amp;gt;&amp;lt;/Relationships&amp;gt;&amp;lt;/Item&amp;gt;&lt;/p&gt;
&lt;p&gt;In the exported package I have this lines I never saw before&lt;/p&gt;
&lt;div&gt;
&lt;div&gt;&lt;span&gt; &lt;/span&gt;&lt;span&gt;&amp;lt;&lt;/span&gt;&lt;span&gt;Relationships&lt;/span&gt;&lt;span&gt;&amp;gt;&lt;/span&gt;&lt;/div&gt;
&lt;div&gt;&lt;span&gt; &lt;/span&gt;&lt;span&gt;&amp;lt;&lt;/span&gt;&lt;span&gt;Item&lt;/span&gt;&lt;span&gt; &lt;/span&gt;&lt;span&gt;type&lt;/span&gt;&lt;span&gt;=&lt;/span&gt;&lt;span&gt;&amp;quot;ITPresentationConfiguration&amp;quot;&lt;/span&gt;&lt;span&gt; &lt;/span&gt;&lt;span&gt;id&lt;/span&gt;&lt;span&gt;=&lt;/span&gt;&lt;span&gt;&amp;quot;7ACFCDADA1BD72956B77D6069BFA2DFF&amp;quot;&lt;/span&gt;&lt;span&gt; &lt;/span&gt;&lt;span&gt;action&lt;/span&gt;&lt;span&gt;=&lt;/span&gt;&lt;span&gt;&amp;quot;add&amp;quot;&lt;/span&gt;&lt;span&gt;&amp;gt;&lt;/span&gt;&lt;/div&gt;
&lt;div&gt;&lt;span&gt; &lt;/span&gt;&lt;span&gt;&amp;lt;&lt;/span&gt;&lt;span&gt;client&lt;/span&gt;&lt;span&gt;&amp;gt;&lt;/span&gt;&lt;span&gt;js&lt;/span&gt;&lt;span&gt;&amp;lt;/&lt;/span&gt;&lt;span&gt;client&lt;/span&gt;&lt;span&gt;&amp;gt;&lt;/span&gt;&lt;/div&gt;
&lt;div&gt;&lt;span&gt; &lt;/span&gt;&lt;span&gt;&amp;lt;&lt;/span&gt;&lt;span&gt;related_id&lt;/span&gt;&lt;span&gt; &lt;/span&gt;&lt;span&gt;keyed_name&lt;/span&gt;&lt;span&gt;=&lt;/span&gt;&lt;span&gt;&amp;quot;tr_i001_projet_TOC_Configuration&amp;quot;&lt;/span&gt;&lt;span&gt; &lt;/span&gt;&lt;span&gt;type&lt;/span&gt;&lt;span&gt;=&lt;/span&gt;&lt;span&gt;&amp;quot;PresentationConfiguration&amp;quot;&lt;/span&gt;&lt;span&gt;&amp;gt;&lt;/span&gt;&lt;span&gt;7ACFCDADA1BD729536326AA7318BB90D&lt;/span&gt;&lt;span&gt;&amp;lt;/&lt;/span&gt;&lt;span&gt;related_id&lt;/span&gt;&lt;span&gt;&amp;gt;&lt;/span&gt;&lt;/div&gt;
&lt;div&gt;&lt;span&gt; &lt;/span&gt;&lt;span&gt;&amp;lt;&lt;/span&gt;&lt;span&gt;sort_order&lt;/span&gt;&lt;span&gt;&amp;gt;&lt;/span&gt;&lt;span&gt;128&lt;/span&gt;&lt;span&gt;&amp;lt;/&lt;/span&gt;&lt;span&gt;sort_order&lt;/span&gt;&lt;span&gt;&amp;gt;&lt;/span&gt;&lt;/div&gt;
&lt;div&gt;&lt;span&gt; &lt;/span&gt;&lt;span&gt;&amp;lt;&lt;/span&gt;&lt;span&gt;source_id&lt;/span&gt;&lt;span&gt; &lt;/span&gt;&lt;span&gt;keyed_name&lt;/span&gt;&lt;span&gt;=&lt;/span&gt;&lt;span&gt;&amp;quot;tr_i001_project&amp;quot;&lt;/span&gt;&lt;span&gt; &lt;/span&gt;&lt;span&gt;type&lt;/span&gt;&lt;span&gt;=&lt;/span&gt;&lt;span&gt;&amp;quot;ItemType&amp;quot;&lt;/span&gt;&lt;span&gt; &lt;/span&gt;&lt;span&gt;name&lt;/span&gt;&lt;span&gt;=&lt;/span&gt;&lt;span&gt;&amp;quot;tr_i001_project&amp;quot;&lt;/span&gt;&lt;span&gt;&amp;gt;&lt;/span&gt;&lt;span&gt;2E959A23C5D640B79FA45579D827BDEC&lt;/span&gt;&lt;span&gt;&amp;lt;/&lt;/span&gt;&lt;span&gt;source_id&lt;/span&gt;&lt;span&gt;&amp;gt;&lt;/span&gt;&lt;/div&gt;
&lt;div&gt;&lt;span&gt; &lt;/span&gt;&lt;span&gt;&amp;lt;/&lt;/span&gt;&lt;span&gt;Item&lt;/span&gt;&lt;span&gt;&amp;gt;&lt;/span&gt;&lt;/div&gt;
&lt;/div&gt;
&lt;p&gt;With 11spX I never get that issue.&lt;/p&gt;
&lt;p&gt;Thanks for your help, for the moment the support only tell me I might miss some element in the package... Since I reproduce the bug with only 1 items and the corresponding form I am a little bit confuse...&lt;/p&gt;&lt;div style="clear:both;"&gt;&lt;/div&gt;</description></item><item><title>orderBy itemtype properties with pagination</title><link>https://www.aras.com/community/f/development/9361/orderby-itemtype-properties-with-pagination</link><pubDate>Mon, 23 Mar 2020 09:12:05 GMT</pubDate><guid isPermaLink="false">916d3f7e-8ddc-42f8-8d45-380822f51406:2af40999-1cd4-4299-9f69-174181868fa1</guid><dc:creator>hadrien.guiducci</dc:creator><description>&lt;p&gt;Hello community,&lt;/p&gt;
&lt;p&gt;I am facing a new challenge, I need to sort the answer of a SOAP request but since I have an&amp;nbsp;itemtype property, I only figure to sort on the id of the itemtype used in the property and not on the name of the instances...&lt;/p&gt;
&lt;p&gt;Datamodel :&lt;/p&gt;
&lt;p&gt;- I have an item bug&lt;/p&gt;
&lt;p&gt;- this item has a property &amp;quot;&lt;span&gt;criticality&amp;quot;&amp;nbsp;&lt;/span&gt;that is an itemtype property linked to 4 items with a property _name and values K1,K2,K3 and K4&lt;/p&gt;
&lt;p&gt;&lt;/p&gt;
&lt;p&gt;I would like to get a page of the first 100 issues over all sorted by ascending criticality thus K1,K2,K3,K4...&lt;/p&gt;
&lt;p&gt;&lt;br /&gt; &lt;span&gt;&amp;lt;Item type=&amp;#39;bug&amp;#39; select=&amp;#39;_criticality&amp;#39; action=&amp;#39;get&amp;#39; page=&amp;#39;1&amp;#39; pagesize=&amp;#39;25&amp;#39; orderBy=&amp;#39;_criticality&amp;#39;&amp;gt;&lt;/span&gt;&lt;br /&gt; &lt;span&gt;&amp;lt;/Item&amp;gt;&lt;/span&gt;&lt;br /&gt; &lt;img src="/resized-image/__size/320x240/__key/communityserver-discussions-components-files/3/pastedimage1584954324225v1.png" alt=" " /&gt;&lt;/p&gt;
&lt;p&gt;With that request I get a set of issues but sorted with the order K3 K1 K4 K2 since it&amp;#39;s using the id of the property itemtype _criticality...&amp;nbsp;&lt;/p&gt;
&lt;p&gt;I tried to orderBy _criticality._name and other stuff but it&amp;#39;s not sorting at all...&lt;/p&gt;
&lt;p&gt;Thanks in advance,&lt;/p&gt;
&lt;p&gt;Hadrien&lt;/p&gt;&lt;div style="clear:both;"&gt;&lt;/div&gt;</description></item><item><title>Update all generation of an object at once with AML</title><link>https://www.aras.com/community/f/development/8945/update-all-generation-of-an-object-at-once-with-aml</link><pubDate>Tue, 14 Jan 2020 08:40:29 GMT</pubDate><guid isPermaLink="false">916d3f7e-8ddc-42f8-8d45-380822f51406:02f4cd12-5105-4927-bd57-7d1fbf8c3750</guid><dc:creator>hadrien.guiducci</dc:creator><description>&lt;p&gt;Hi community,&lt;/p&gt;
&lt;p&gt;I am trying to modify a property on all the generation of an item.&lt;/p&gt;
&lt;p&gt;Thus I am trying to merge those two requests&lt;/p&gt;
&lt;p&gt;1) Modify the latest generation without changing the generation :&lt;/p&gt;
&lt;p&gt;&lt;span&gt;&amp;lt;AML&amp;gt;&lt;/span&gt;&lt;br /&gt; &amp;nbsp;&amp;nbsp;&lt;span&gt;&amp;lt;Item action=&amp;#39;merge&amp;#39; type=&amp;#39;Part&amp;#39; where=&amp;quot;[Part].item_number=&amp;#39;1234&amp;#39;&amp;quot; version=&amp;#39;0&amp;#39;&amp;gt;&lt;/span&gt;&lt;br /&gt; &amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&lt;span&gt;&amp;lt;_authoring_tool_id_label&amp;gt;&lt;/span&gt;TATA&lt;span&gt;&amp;lt;/_authoring_tool_id_label&amp;gt;&lt;/span&gt;&lt;br /&gt; &amp;nbsp;&amp;nbsp;&lt;span&gt;&amp;lt;/Item&amp;gt;&lt;/span&gt;&lt;br /&gt; &lt;span&gt;&amp;lt;/AML&amp;gt;&lt;/span&gt;&lt;/p&gt;
&lt;p&gt;&lt;span&gt;2) get all generation&lt;/span&gt;&lt;/p&gt;
&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&lt;span&gt;&amp;lt;Item action=&amp;#39;get&amp;#39; type=&amp;#39;Part&amp;#39;&amp;gt;&lt;/span&gt;&lt;br /&gt; &amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&lt;span&gt;&amp;lt;generation condition=&amp;#39;ge&amp;#39;&amp;gt;&lt;/span&gt;0&lt;span&gt;&amp;lt;/generation&amp;gt;&lt;/span&gt;&lt;br /&gt; &amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&lt;span&gt;&amp;lt;_title&amp;gt;1234&lt;/span&gt;&lt;span&gt;&amp;lt;/_title&amp;gt;&lt;/span&gt;&lt;br /&gt; &amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&lt;span&gt;&amp;lt;/Item&amp;gt;&lt;/span&gt;&lt;/p&gt;
&lt;p&gt;&lt;span&gt;Thus I tried something like&lt;/span&gt;&lt;/p&gt;
&lt;p&gt;&lt;span&gt;&amp;lt;AML&amp;gt;&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;lt;Item action=&amp;#39;merge&amp;#39; type=&amp;#39;Part&amp;#39; where=&amp;quot;[Part].item_number=&amp;#39;1234&amp;#39; and [Part].generation&amp;gt;&amp;#39;0&amp;#39;&amp;quot; version=&amp;#39;0&amp;#39;&amp;gt;&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;lt;_authoring_tool_id_label&amp;gt;TATA&amp;lt;/_authoring_tool_id_label&amp;gt;&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;lt;/Item&amp;gt;&lt;br /&gt;&amp;lt;/AML&amp;gt;&lt;/span&gt;&lt;/p&gt;
&lt;p&gt;&lt;span&gt;But I can not find how to make it work.&lt;/span&gt;&lt;/p&gt;
&lt;p&gt;&lt;span&gt;I will try to use the config id or swith to sql query... It&amp;#39;s for a datamodel modification and be done one time thus it could be ok.&lt;/span&gt;&lt;/p&gt;
&lt;p&gt;&lt;span&gt;Thanks,&lt;/span&gt;&lt;/p&gt;
&lt;p&gt;&lt;span&gt;Hadrien&lt;/span&gt;&lt;/p&gt;&lt;div style="clear:both;"&gt;&lt;/div&gt;</description></item><item><title>ARAS RESTful API:  How do I get a list of all generations for a part?</title><link>https://www.aras.com/community/f/development/6593/aras-restful-api-how-do-i-get-a-list-of-all-generations-for-a-part</link><pubDate>Tue, 19 Nov 2019 20:57:28 GMT</pubDate><guid isPermaLink="false">916d3f7e-8ddc-42f8-8d45-380822f51406:65e33c23-5635-420d-8811-234bb1699815</guid><dc:creator>Moses.Correia</dc:creator><description>&lt;p&gt;I&amp;#39;m attempting to get a full part history (14 generations worth) of a part.&amp;nbsp; I know the config_id is a value shared between all 14 parts; however, I can&amp;#39;t seem to construct the REST call to return all 14 records using the config_id.&lt;/p&gt;
&lt;p&gt;&lt;/p&gt;
&lt;p&gt;I get the config_id with ...&amp;nbsp;&lt;strong&gt;GET {base url}/Part(&amp;#39;&amp;lt;id&amp;gt;&amp;#39;)/config_id/id/$value&lt;/strong&gt;&lt;/p&gt;
&lt;p&gt;&lt;span&gt;Then I tried using the config_id in a filter like this ...&amp;nbsp;&lt;strong&gt;GET {base url}/Part?$config_id eq &amp;#39;&amp;lt;config_id&amp;gt;&amp;#39;&lt;/strong&gt;&amp;nbsp; That just returned one part record, the latest one.&lt;/span&gt;&lt;/p&gt;
&lt;p&gt;&lt;span&gt;&lt;/span&gt;&lt;/p&gt;
&lt;p&gt;&lt;span&gt;Using the config_id is what I would have done using an AML query, but is there another way with the REST API?&lt;/span&gt;&lt;/p&gt;
&lt;p&gt;&lt;span&gt;&lt;/span&gt;&lt;/p&gt;
&lt;p&gt;&lt;span&gt;I&amp;#39;m running Aras Innovator 11.0 SP12&lt;/span&gt;&lt;/p&gt;&lt;div style="clear:both;"&gt;&lt;/div&gt;</description></item><item><title>AML search to return only the count of object corresponding</title><link>https://www.aras.com/community/f/applications/6425/aml-search-to-return-only-the-count-of-object-corresponding</link><pubDate>Wed, 09 Oct 2019 22:08:36 GMT</pubDate><guid isPermaLink="false">916d3f7e-8ddc-42f8-8d45-380822f51406:aac935b0-56ee-4da7-93a5-792bea231b86</guid><dc:creator>hadrien.guiducci</dc:creator><description>&lt;p&gt;Hi community,&lt;/p&gt;
&lt;p&gt;&lt;/p&gt;
&lt;p&gt;I have a request to get from an AML request only the number of item corresponding to the AML request.&lt;/p&gt;
&lt;p&gt;In Odata and SQL it is ok but I cannot find the equiavlent.&lt;/p&gt;
&lt;p&gt;I precise that I do not want to create a method to count the items from a tab.&lt;/p&gt;
&lt;p&gt;&lt;/p&gt;
&lt;p&gt;For example I want to get the number of the Parts with status = Draft&lt;/p&gt;
&lt;p&gt;&lt;/p&gt;
&lt;p&gt;Best regards,&lt;/p&gt;
&lt;p&gt;Hadrien&lt;/p&gt;&lt;div style="clear:both;"&gt;&lt;/div&gt;</description></item><item><title>Let me Help You</title><link>https://www.aras.com/community/achievements/687f4b6d-e18a-4e55-836c-49926ca2c9d9</link><pubDate>Thu, 21 Nov 2019 08:40:41 GMT</pubDate><guid isPermaLink="false">916d3f7e-8ddc-42f8-8d45-380822f51406:cdb33857-4e70-48b7-85f9-520b05468a7b</guid><dc:creator /><description>Answer a question that is verified as helpful or correct.</description></item><item><title>AML where condition based on keyed name</title><link>https://www.aras.com/community/f/development/6565/aml-where-condition-based-on-keyed-name</link><pubDate>Tue, 12 Nov 2019 08:25:18 GMT</pubDate><guid isPermaLink="false">916d3f7e-8ddc-42f8-8d45-380822f51406:9f951ff2-42d8-43c6-8106-9572d0aa32d2</guid><dc:creator>hadrien.guiducci</dc:creator><description>&lt;p&gt;Hi community,&lt;/p&gt;
&lt;p&gt;&lt;/p&gt;
&lt;p&gt;I am trying to transform a where condition based on id into a where condition based on the keyed name or item_number&lt;/p&gt;
&lt;p&gt;Outside a where condition it would be&lt;/p&gt;
&lt;p&gt;&amp;lt; source _id&amp;gt;&lt;/p&gt;
&lt;p style="padding-left:30px;"&gt;&amp;lt;Item type=&amp;quot;Part&amp;quot; action=&amp;quot;get&amp;quot; select=&amp;quot;id&amp;quot;&amp;gt;&lt;/p&gt;
&lt;p style="padding-left:60px;"&gt;&amp;lt;keyed_name&amp;gt;PartB&amp;lt;/keyed_name&amp;gt;&lt;/p&gt;
&lt;p style="padding-left:30px;"&gt;&amp;lt;/Item&amp;gt;&lt;/p&gt;
&lt;p&gt;&amp;lt;/ source _id &amp;gt;&lt;/p&gt;
&lt;p&gt;&lt;/p&gt;
&lt;p&gt;I tried something like :&lt;/p&gt;
&lt;p&gt;where=&amp;quot;[Part BOM]. source_id=&amp;#39;qsdmlsdkfsd51651681q3s5dq3s5d1&amp;#39;&amp;quot;&lt;/p&gt;
&lt;p&gt;into&lt;/p&gt;
&lt;p&gt;where=&amp;quot;[Part BOM]. source_id.item_number=&amp;#39;PartB&amp;#39;&amp;quot;&lt;/p&gt;
&lt;p&gt;&lt;/p&gt;
&lt;p&gt;Thanks for the help !&lt;/p&gt;
&lt;p&gt;Best regards,&lt;/p&gt;
&lt;p&gt;Hadrien&lt;/p&gt;
&lt;p&gt;&amp;nbsp;&lt;/p&gt;&lt;div style="clear:both;"&gt;&lt;/div&gt;</description></item><item><title>batchloader to import several generation</title><link>https://www.aras.com/community/f/applications/6398/batchloader-to-import-several-generation</link><pubDate>Thu, 03 Oct 2019 13:55:45 GMT</pubDate><guid isPermaLink="false">916d3f7e-8ddc-42f8-8d45-380822f51406:c708878e-c3a1-48ec-b737-ee04914cabd9</guid><dc:creator>hadrien.guiducci</dc:creator><description>&lt;p&gt;Hi&amp;nbsp;&lt;/p&gt;
&lt;p&gt;I am trying to import several generation of an item.&lt;/p&gt;
&lt;p&gt;In AML I can do it with&amp;nbsp;&lt;/p&gt;
&lt;p&gt;&lt;span&gt;&amp;lt;Item type=&amp;#39;myItem&amp;#39; action=&amp;#39;merge&amp;#39; where=&amp;quot;[myItem]._title=&amp;#39;123456&amp;#39;&amp;quot;&amp;gt;&lt;/span&gt;&lt;br /&gt; &amp;nbsp;&amp;nbsp;&lt;span&gt;&amp;lt;_title&amp;gt;523556&lt;/span&gt;&lt;span&gt;&amp;lt;/_title&amp;gt;&lt;/span&gt;&lt;br /&gt; &amp;nbsp;&amp;nbsp;&lt;span&gt;&amp;lt;_start_date&amp;gt;&lt;/span&gt;2019-09-30T00:00:00&lt;span&gt;&amp;lt;/_start_date&amp;gt;&lt;/span&gt;&lt;br /&gt; &amp;nbsp;&amp;nbsp;&lt;span&gt;&amp;lt;_end_date&amp;gt;&amp;lt;/_end_date&amp;gt;&lt;/span&gt;&lt;br /&gt; &amp;nbsp;&amp;nbsp;&lt;span&gt;&amp;lt;_status&amp;gt;New&lt;/span&gt;&lt;span&gt;&amp;lt;/_status&amp;gt;&lt;/span&gt;&lt;br /&gt; &lt;span&gt;&amp;lt;/Item&amp;gt;&lt;/span&gt;&lt;/p&gt;
&lt;p&gt;&lt;span&gt;This AML request works it gives :&lt;/span&gt;&lt;/p&gt;
&lt;p&gt;&lt;span&gt;&lt;img src="/resized-image/__size/320x240/__key/communityserver-discussions-components-files/8/pastedimage1570110881971v1.png" alt=" " /&gt;&lt;/span&gt;&lt;/p&gt;
&lt;p&gt;&lt;span&gt;But in the batchloader I got an error since I could not make a aml like &amp;lt;Item&amp;nbsp;type=&amp;#39;myItem&amp;#39;&amp;nbsp;action=&amp;#39;merge&amp;#39;&amp;nbsp;where=&amp;quot;[myItem]._title=&amp;#39;@2&amp;#39;&amp;quot;&amp;gt;&amp;nbsp;&lt;/span&gt;&lt;/p&gt;
&lt;p&gt;&lt;span&gt;Any Idea ? Thanks.&lt;/span&gt;&lt;/p&gt;
&lt;p&gt;&lt;span&gt;Best regards&lt;/span&gt;&lt;/p&gt;
&lt;p&gt;&lt;span&gt;Hadrien&lt;/span&gt;&lt;/p&gt;&lt;div style="clear:both;"&gt;&lt;/div&gt;</description></item><item><title>Discussion Starter I</title><link>https://www.aras.com/community/achievements/21025ab1-febb-4fb4-a872-d32a921cb45c</link><pubDate>Thu, 10 Oct 2019 09:06:01 GMT</pubDate><guid isPermaLink="false">916d3f7e-8ddc-42f8-8d45-380822f51406:21fe1b8e-3941-460d-ba6e-f82b391243ee</guid><dc:creator /><description>Start a discussion in a forum that receives 5 replies.</description></item><item><title>AML problem using action=&amp;#39;update&amp;#39; (in order to modify an item without changing generation)</title><link>https://www.aras.com/community/f/applications/6403/aml-problem-using-action-update-in-order-to-modify-an-item-without-changing-generation</link><pubDate>Fri, 04 Oct 2019 08:57:31 GMT</pubDate><guid isPermaLink="false">916d3f7e-8ddc-42f8-8d45-380822f51406:eb3a8177-fbda-4356-9e0b-c4e6478e736d</guid><dc:creator>hadrien.guiducci</dc:creator><description>&lt;p&gt;Hi&amp;nbsp;&lt;/p&gt;
&lt;p&gt;I am facing a problem with an AML expression.&lt;/p&gt;
&lt;p&gt;&lt;span&gt;&amp;lt;AML&amp;gt;&lt;/span&gt;&lt;br /&gt; &amp;nbsp;&amp;nbsp;&lt;span&gt;&amp;lt;Item action=&amp;#39;update&amp;#39; type=&amp;#39;myItem&amp;#39; where=&amp;quot;[myItem]._title=&amp;#39;myItemName&amp;#39; and [myItem].generation=&amp;#39;1&amp;#39;&amp;nbsp;&amp;quot;&amp;gt;&lt;/span&gt;&lt;br /&gt; &amp;nbsp;&amp;nbsp;&lt;span&gt;&amp;lt;myItemProperty&amp;gt;&lt;/span&gt;&lt;br /&gt; &amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&lt;span&gt;&amp;lt;Item type=&amp;quot;myItemProperty&amp;quot; action=&amp;quot;get&amp;quot; select=&amp;quot;id&amp;quot;&amp;gt;&lt;/span&gt;&lt;br /&gt; &amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&lt;span&gt;&amp;lt;keyed_name&amp;gt;myItemPropertyName&lt;/span&gt;&lt;span&gt;&amp;lt;/keyed_name&amp;gt;&lt;/span&gt;&lt;br /&gt; &amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&lt;span&gt;&amp;lt;/Item&amp;gt;&lt;/span&gt;&lt;br /&gt; &amp;nbsp;&amp;nbsp;&lt;span&gt;&amp;lt;/myItemProperty&amp;gt;&lt;/span&gt;&lt;br /&gt; &lt;span&gt;&amp;lt;/AML&amp;gt;&lt;/span&gt;&lt;/p&gt;
&lt;p&gt;&lt;span&gt;That AML works with edit but it changes the generation...&lt;/span&gt;&lt;/p&gt;
&lt;p&gt;&lt;span&gt;I get that error whatever my item is locked or unlocked...&lt;/span&gt;&lt;/p&gt;
&lt;p&gt;&lt;span&gt; &amp;lt;SOAP-ENV:Envelope xmlns:SOAP-ENV=&amp;quot;&lt;a href="http://schemas.xmlsoap.org/soap/envelope/"&gt;&amp;quot;&amp;gt;schemas.xmlsoap.org/.../&amp;quot;&amp;gt;&lt;/a&gt;&lt;br /&gt; &amp;nbsp;&amp;nbsp;&amp;lt;SOAP-ENV:Body&amp;gt;&lt;br /&gt; &amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;lt;SOAP-ENV:Fault xmlns:af=&amp;quot;&lt;a href="http://www.aras.com/InnovatorFault"&gt;&amp;quot;&amp;gt;www.aras.com/InnovatorFault&amp;quot;&amp;gt;&lt;/a&gt;&lt;br /&gt; &amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;lt;faultcode&amp;gt;SOAP-ENV:Server.ItemIsNotLockedException&amp;lt;/faultcode&amp;gt;&lt;br /&gt; &amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;lt;faultstring&amp;gt;&amp;lt;![CDATA[Aras.Server.Core.ItemIsNotLockedException]]&amp;gt;&amp;lt;/faultstring&amp;gt;&lt;br /&gt; &amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;lt;detail&amp;gt;&lt;br /&gt; &amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;lt;af:legacy_detail&amp;gt;&amp;lt;![CDATA[Aras.Server.Core.ItemIsNotLockedException]]&amp;gt;&amp;lt;/af:legacy_detail&amp;gt;&lt;br /&gt; &amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;lt;af:exception message=&amp;quot;Aras.Server.Core.ItemIsNotLockedException&amp;quot; type=&amp;quot;Aras.Server.Core.ItemIsNotLockedException&amp;quot; /&amp;gt;&lt;br /&gt; &amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;lt;af:item type=&amp;quot;myItem&amp;quot; id=&amp;quot;5CC09554029A4E76AD0601C9F8C2AC33&amp;quot; /&amp;gt;&lt;br /&gt; &amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;lt;/detail&amp;gt;&lt;br /&gt; &amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;lt;/SOAP-ENV:Fault&amp;gt;&lt;br /&gt; &amp;nbsp;&amp;nbsp;&amp;lt;/SOAP-ENV:Body&amp;gt;&lt;br /&gt; &amp;lt;/SOAP-ENV:Envelope&amp;gt;&lt;/span&gt;&lt;/p&gt;
&lt;p&gt;&lt;span&gt;Any idea ?&lt;/span&gt;&lt;/p&gt;
&lt;p&gt;&lt;span&gt;Best regards,&lt;/span&gt;&lt;/p&gt;
&lt;p&gt;&lt;span&gt;Hadrien&lt;/span&gt;&lt;/p&gt;&lt;div style="clear:both;"&gt;&lt;/div&gt;</description></item><item><title>Ask A Question I</title><link>https://www.aras.com/community/achievements/460ac7df-7ccc-4c42-a204-9e05eef3be09</link><pubDate>Thu, 03 Oct 2019 00:16:50 GMT</pubDate><guid isPermaLink="false">916d3f7e-8ddc-42f8-8d45-380822f51406:e96c7394-b051-47c2-a210-cb80a0a2da1a</guid><dc:creator /><description>Ask a question in a forum.</description></item><item><title>Managing several relationships in one Odata Restful API request with versioning</title><link>https://www.aras.com/community/f/community/6357/managing-several-relationships-in-one-odata-restful-api-request-with-versioning</link><pubDate>Mon, 23 Sep 2019 12:53:31 GMT</pubDate><guid isPermaLink="false">916d3f7e-8ddc-42f8-8d45-380822f51406:d487c4f2-8f81-4ea2-b937-d62490d3d885</guid><dc:creator>hadrien.guiducci</dc:creator><description>&lt;p&gt;Hello we have the following AML request :&lt;/p&gt;
&lt;p&gt;&lt;/p&gt;
&lt;p&gt;&amp;lt;Item type=&amp;quot;Issue&amp;quot; action=&amp;quot;get&amp;quot; select=&amp;quot;id,_title,_summary,_status,_source&amp;quot;&amp;gt;&lt;/p&gt;
&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;_source&amp;gt;&lt;/p&gt;
&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;Item type=&amp;quot;Source&amp;quot; action=&amp;quot;get&amp;quot; select=&amp;quot;id,_name,_url&amp;quot;&amp;gt;&lt;/p&gt;
&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;/Item&amp;gt;&lt;/p&gt;
&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;/_source&amp;gt;&lt;/p&gt;
&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;Relationships&amp;gt;&lt;/p&gt;
&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;Item type=&amp;quot;Issue_Project&amp;quot; action=&amp;quot;get&amp;quot; select=&amp;quot;related_id&amp;quot;&amp;gt;&lt;/p&gt;
&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;related_id&amp;gt;&lt;/p&gt;
&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;Item type=&amp;quot;Project&amp;quot; action=&amp;quot;get&amp;quot; select=&amp;quot;_name,id&amp;quot;&amp;gt;&lt;/p&gt;
&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;/Item&amp;gt;&lt;/p&gt;
&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;/related_id&amp;gt;&lt;/p&gt;
&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;/Item&amp;gt;&lt;/p&gt;
&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;/Relationships&amp;gt;&lt;/p&gt;
&lt;p&gt;&amp;lt;/Item&amp;gt;&lt;/p&gt;
&lt;p&gt;&amp;nbsp;1) we want to do it with Odata API from Aras to get a json response but for the moment we are stuck... Any idea on managing several relationships in one request ?&lt;/p&gt;
&lt;p&gt;2)&amp;nbsp;We would like to perfom the same request at a specific date.&lt;/p&gt;
&lt;p&gt;Since the item issue is &amp;quot;versionable&amp;quot;, how to get the item in the state as it was at that date ?&lt;/p&gt;
&lt;p&gt;We are trying to use the OOTB effective date, what are the mechanism behind it ?&lt;/p&gt;
&lt;p&gt;Thanks for your help,&lt;/p&gt;
&lt;p&gt;Hadrien&lt;/p&gt;&lt;div style="clear:both;"&gt;&lt;/div&gt;</description></item></channel></rss>