Stop text input for item property in relationship grid
Hello, Is it possible to stop users from selecting an item for a item property using text input in something like the part number property of the product model relationship item? I've added a filter to the OnSearchDialog event of the property to limit the choices, but since it only triggers when the … button is used to open a dialog, I can still input any part number through text. Is there any way to stop this text input or do I have to make a method that checks the property OnCellChange to verify the selected value? /Rick6.5KViews0likes3Commentsget property list from item type, issue reading the result item
hello, i want to get a list of names of propreties that start a certain way 'z%'. i've found aml that was supposed to do it, i' made an iom code to recrate that aml (actually creates the right aml). But what i get is only one item, so i want to know if the aml is actually good or if there is a specific way to get the properties from that one item i get. [embed:dc8ab71f-3b98-42d9-b0f6-e21e02a0f8e2:8336f2cd-196d-4ebb-8979-eeead87b54f9:type=text&text=%3CAML%3E%0D%0A%3CItem%20action%3D%22get%22%20type%3D%22itemType%22%20select%3D%22name%22%20where%3D%22ItemType.name%20%3D%20%27ZFCcontrainteTemplate%27%22%3E%0D%0A%09%3Cname%3Epart%3C%2Fname%3E%0D%0A%09%3CRelationships%3E%0D%0A%09%09%3CItem%20type%3D%22property%22%20action%3D%22get%22%20select%3D%22value%2C%20label%22%20where%3D%22%5Bproperty%5D.label%20like%20%27z%25%27%22%20%2F%3E%0D%0A%09%3C%2FRelationships%3E%0D%0A%3C%2FItem%3E%0D%0A%3C%2FAML%3E] [embed:dc8ab71f-3b98-42d9-b0f6-e21e02a0f8e2:d50be430-1135-40a5-be6a-46672b9d79f9:type=text&text=var%20FCitemType%20%3D%20inn.newItem%28%22itemType%22%2C%20%22get%22%29%3B%0D%0A%2F%2F%20FCitemType.setProperty%28%22name%22%2C%22FCcontrainteTemplate%22%29%3B%0D%0A%2F%2F%20FCitemType.setAttribute%28%22select%22%2C%20%22name%22%29%3B%0D%0AFCitemType.setAttribute%28%22where%22%2C%20%22%5BitemType%5D.name%20like%20%27ZFCcontrainteTemplate%27%22%29%3B%0D%0A%0D%0A%0D%0Avar%20property%20%3D%20FCitemType.createRelationship%28%22property%22%2C%20%22get%22%29%3B%0D%0Aproperty.setAttribute%28%22select%22%2C%20%22label%22%29%3B%0D%0Aproperty.setAttribute%28%22where%22%2C%20%22%5Bproperty%5D.label%20like%20%27z%25%27%22%29%3B%0D%0A%0D%0Aconsole.log%28%22FCitemType%20before%20apply%3A%20%22%2BFCitemType.ToString%28%29%29%3B%0D%0AFCitemType%20%3D%20FCitemType.apply%28%29%3B] thanks lucasSolved5.9KViews0likes7CommentsOverride IType Property auto-label
After adding a property to an ItemType and tabbing from the property Name to the property Label there is the annoying behaviour I would like very much to override. I'd rather it stay blank than constantly needing to: Select all, delete, and finally enter a sensible label. I'm only critical of this annoyance because all the default labels are sensible, but whoever put together this auto-label didn't seem to take that into account. For instance, the default label for "team_id" is simply "Team", and the default label for "release_date" is "Release Date". So, why would tab-to automatically copy the property name? I'd like if tab to split on underscore and did a caps op on every word. Then, rather than constantly needing to delete the auto-label to enter one that conforms to the default look of out-the-box Innovator IType labels, it would actually be helpful! This is a quick JS example, and I think if ANY auto-label this should be it: ``` // Change "release_date" property name to desired default-looking, "Release Date": "release_date".split("_").map(x => x.charAt(0).toUpperCase() + x.substr(1,)).join(' ') ````5.5KViews0likes6CommentsGetting an item property in onChangedCell from a recently created relationship vs existing relationship
I'm running a method on the property event "onChangedCell". When the method is called on a newly created related item, the following statement successfully get's the property: var my_item = parent.item.querySelector("#" + relatedID); var my_property = aras.getItemProperty(my_item, "my_property"); The problem though is when a user edits the cell of an existing related item, I don't get the related item with the query selector. How do I handle the different scenarios of the related item being newly created and the related item being loaded since it is an existing relationship? Since the user just finished changing the property I figured that property at least would be in the cache similar to a newly created item but I'm obviously missing something. Thank you in advance! -KenSolved5.4KViews0likes2CommentsCannot insert the value NULL into column 'NAME',
Hi all, I recently exported updates to the CAD item type from a development environment to our QA testing environment. I am running into an error when updating the NAME property to required: Cannot insert the value NULL into column 'NAME', table 'ArasTest_12sp14.innovator.CAD'; column does not allow nulls. UPDATE fails. The statement has been terminated. in SQL: [ALTERTABLECOLUMN] Any ideas? The field can be updated in the environment in which I exported without issue. Did I maybe miss something in my package definition?Solved5KViews0likes2CommentsConstraints not working on an integer field form
Hello, I created a new "feedback" ItemType for my users to write remarks about Aras. I want them to rank the priority of the feedback with an integer from 1 to 5. For this, I created a _priority property in the itemtype which is of type "Integer". I set the range Min to 1 and Max to 5, and checked the "inclusive" box. I also put a value of 1. Then I created a form and added the _priority as a text field (I first tried with a combobox but it didn't provide any selectable values, I would be happy if you can help me about that too). The form works well, the default value of 1 is here, but the user is able to enter any kind of integer (200, or even -8) and can still submit the form. I also tried to add a pattern ([1-5], and even /^[1-5]$/ ) but that didn't change anything, the validation isn't working. Is there something wrong in my databinding? Does anyone know why? Thank you.Solved4.6KViews0likes5CommentsItemType Pattern No Space
Good day all. Can someone tell me how to set the Pattern for an ItemType Property to not allow spaces? I read the Tech Tip: Enforce Property Formats Using Regular Expressions and looked at the Regex link provided, but have not been able to make anything work. I have tried [\s], [^\s], and [^\s-], but those throw an errors if there is not a space. Thank you for any help that you can provide.Solved4.2KViews0likes4CommentsCompressed text property
Frequently, on ItemTypes, I use a "Text" property to store json data. Because, the json is very verbose and can be compressed to reduce the taken space in database and network traffic, I use LZString.compressToBase64 before a setProperty and LZString.decompressFromBase64 after a getProperty. This could be very developer friendly if ARAS could provide a new type named "compressed" (or whatever you want) doing this transparently. I don't know how to submit an idea, so I doing it here. Thank you for considering it. Regards.4.2KViews0likes2CommentsDisplay property value to be different from actual value
Hi, I would like to have a property value displayed differently than the actual value which is on the Item. I could have a field on the form, which can be set on form load, but I want the same behavior on the search grid, relationship grids as well. Thanks.3.4KViews0likes5Comments