searching for parts that contain an asterisk in Aras Innovator

Former Member
Former Member
Is there a way within Aras Innovator to search for Part Numbers that contain the asterisk character?  I'm not sure how to search for parts containing the asterisk without the system assuming I am using a wildcard in my criteria.  It seems that the results are the same weather "Use Wildcards" is checked or not in the Search drop-down menu. On the advice of a colleague I tried these variants, none of which returned any parts containing the asterisk in their part number: *\*   and  \*      both return every part (>74k parts) *[*]        returned just 20 parts but none containing Asterisk character *\[*]      returned the same 20 parts as above *[\*]      returned the same 20 parts as above
Parents
  • Hi Tony, The "Use Wildcards" option only applies to Simple Searches. It does not prevent you from using wildcards with the "like" condition inside of an Advanced or AML Search. Unfortunately, there is currently not a way to filter a search for an asterisk outside of using the where clause in an AML query. I have filed an enhancement for this functionality to be introduced in a later release of Aras Innovator, but I'm not aware of any way to perform this kind of search OOTB currently. Chris __________________________________________ Christopher Gillis Aras Labs Software Engineer
Reply
  • Hi Tony, The "Use Wildcards" option only applies to Simple Searches. It does not prevent you from using wildcards with the "like" condition inside of an Advanced or AML Search. Unfortunately, there is currently not a way to filter a search for an asterisk outside of using the where clause in an AML query. I have filed an enhancement for this functionality to be introduced in a later release of Aras Innovator, but I'm not aware of any way to perform this kind of search OOTB currently. Chris __________________________________________ Christopher Gillis Aras Labs Software Engineer
Children
No Data