Datamaster search with dates

Frank Racette shared this question 7 years ago
Answered

I would like to know how is is possible to search through a datamaster by selecting a date to start from to a date . i.e. search all result generated from may 22nd 2010 to april 1st 2011

Comments (11)

photo
1

Easy, create a set value event on the data grid with this expression:db5646dccf8236298779294ed0ccc614

photo
1

I ried for several hours yesterday to do simple login and other things. today with the formula you gave. The same message pops up : The highlighted expression is list. Replace it for an other one having comparative result.


The equation is : when {{filter{ datamaster,{date attribute greater or = input 1}}&{date attribute smaller or = input 2}}}


I also tried without the when but same error message.


I am using a mac with the justinmind version4.1 on 30 day trial

photo
1

The problem is the & function must be next to the other equals function. To insert a function between two brackets move it from below the expression to the space between them. The resulting expression would be this:


when {{filter{ datamaster,{date attribute greater or = input 1}&{date attribute smaller or = input 2}}}}

photo
1

Is there a reason why now i cant get the two {{ before the filter ?

photo
1

Well, there shoudn't be two {{ before the filter the correct expression should be this (sorry for the last reply, that happens sometimes with copy&paste):


when {filter{ datamaster,{date attribute greater or = input 1}&{date attribute smaller or = input 2}}}

photo
1

Maybe its me ... and I really appreciate your help but seems like my expression is like your yet does not work.


96a11e995c48dafe6e3b1ea115adfd91

photo
1

Oh sorry sorry! I didn't see it! You are configuring a condition but what you must configure is a set value event with a calculated value. The calculated value expression must be the filter one.

photo
1

Wow great it work ! Victor I must say great customer service really appreciate it !!!


Now when I simulate it shows the complete data set and filters down only when i select the dates. is there a way to displays the data set only when the dates are selected ? or am I pushing my luck with the simulation?

photo
1

I'm sorry but I can't understand what you want to simulate. Could you detail it a little bit please?

photo
1

I would like to navigate to a page where the data table is empty ( at first) and when the date variable ( from and to) are selected ( like you showed me) then display the results.


But on the page load I don't want any results to show.

photo
1

That's really easy. Just create an onpageload event with a set value, select the data grid and leave the value blank.