• Replies 3 replies
  • Subscribers 13 subscribers
  • Views 4395 views
  • Users 0 members are here
Options
Related

Unable to apply condition on "created_on" property for a Part.

Former Member
Former Member
Hi ,
I am trying to apply filter on created_on property of a part . 1: When I fetch a  part , it shows <created_on>2017-05-16T15:20:49</created_on> in the aml studio. 2 :But when I use following aml query to fetch a part: <AML> <Item type="Part" action="get" > <created_on>2017-05-16T15:20:49</created_on> </Item> </AML> It gives me error saying : <![CDATA[No items of type 'Part' found using the criteria: <Item type="Part" action="get"><created_on>2017-05-16T15:20:49</created_on></Item> ]]> 3: When I search in sql server table , innovator.Part table has   2017-05-16 09:50:49.753 date for the same part . Is there anything wrong/remaining  in  installation. How can I get proper part based on date filter ? Can anybody help me with this issue. Thanks in advance . Thanks & Regards , Ketan.
 
Parents
  • オフライン
    hi i am using  following aml query <AML> <Item type='Bal_BinCard' action='get'> <bal_bincarddate condition='between'>2018-06-01T17:01:58 and 2018-06-01T17:01:59</bal_bincarddate> </Item> </AML> but i get error-  Incorrect value explanation: Parse error occurred during analyze condition attribute:\r\n Incorrect syntax near T17:.
Reply
  • オフライン
    hi i am using  following aml query <AML> <Item type='Bal_BinCard' action='get'> <bal_bincarddate condition='between'>2018-06-01T17:01:58 and 2018-06-01T17:01:59</bal_bincarddate> </Item> </AML> but i get error-  Incorrect value explanation: Parse error occurred during analyze condition attribute:\r\n Incorrect syntax near T17:.
Children
No Data

Copyright © 2025 Aras. All rights reserved.