Forum Discussion

anhht-hue's avatar
anhht-hue
Ideator I
7 years ago

Search Parameter with date time

I have condition parameter search for ItemType Part like this (modified_on > 2019-04-11T00:00:00 and  modified_on <= 2019-04-20T00:00:00) Case 1. When I new item AML  to search <Item type="Part"...
AML
Gopikrishnan's avatar
Gopikrishnan
Ideator I
7 years ago

Hi Anhht

I guess the error is because of the = in your first query (after &lt;)

<AML>
<Item type = "Part" action = "get" where="[Part].modified_on &gt; '2019-04-11T00:00:00' AND [Part].modified_on &lt;'2019-04-20T00:00:00'"></Item>
</AML>

Alternately, you can use below query also to get the expected results

<AML>
<Item type="Part" action="get">
<modified_on condition="between">2019-04-11T00:00:00 and 2019-04-20T00:00:00</modified_on>
</Item>
</AML>

Another Way

<AML>
<Item type="Part" action="get">
<modified_on condition="gt">2019-04-11T00:00:00</modified_on>
<modified_on condition="lt">2019-04-20T00:00:00</modified_on>
</Item>
</AML>

Thanks,

GK

anhht-hue's avatar
anhht-hue
Ideator I
7 years ago

Thanks so much @gkarasuser,

Can I ask you another question? Is that AML not support operator <= or "le" ?

By the way, I will try follow your answer. Thanks buddy.

  • Gopikrishnan's avatar
    Gopikrishnan
    Ideator I
    7 years ago

    Hi Anhht

    If you want to use "le" or "ge" it should be like

    <AML>
    <Item type = "Part" action = "get">
    <modified_on condition="ge">2019-04-11T00:00:00</modified_on>
    <modified_on condition = "le">2019-04-20T00:00:00</modified_on
    </Item>
    </AML>

    It is not working when we are giving it as attribute. 

    Thank You

    GK