Hi ,
I have list of year which i want to pass in dataset to filter out date between those years. But query is not returning anything.
I am new to this concept so please guide me on that.
with( local!years: {2015,2016,2017}, a!forEach( items: local!years, expression: a!queryEntity( entity: cons!YEAR_DETAILS, query: a!query( filter: {a!queryFilter( field: "created", operator: "between", value: {datetime(fv!item,month(1),day(1),hour(1),minute(1),second(1)),datetime(fv!item,month(12),day(31),hour(12),minute(1),second(1))} )}, pagingInfo: a!pagingInfo( startIndex: 1, batchSize: - 1, sort: a!sortInfo( field: "created", ascending: true ) ) ) ) ) )
Kindly consider YEAR_DETAILS table .
Discussion posts and replies are publicly visible
Hi Sourav,
what is your query, you have a list of years, for each yearvalue , you have to get the dataset am I right..??
if it , you have to create a one rule input of type date then you can try this query, but in the above you used Foreach function
Basically, foreach function is used for looping
Hope it will help to you
Regards,
Bhanu.
I want data to b efilter to respective year with date 01/01/** 12:00 PM 12/31/** 12 AM
So trying to club all data in one dataset. You can share sample code to me.It would be help fo rme.