People go to the store and shop many items. I have entered all the items in a data type called Purchase. So Purchase contains the items purchased with many of their properties. One property that has the same value for all the items of a specific purchase is “purchase date”. Now I want to RG list only the 1st record when dates are the same. I want to RG list only the 1st item of every purchase based on the “purchase date”. Could not figure out a way to get this done. Thanks for any help, indeed. Jairo.
Hello @jairo.ibp ,
When you are giving the data source to the repeating group, you need to add constraints to the repeating group, purchase =current date/time. (I am assuming that the item’s purchase date will be compared on the basis of the present day).
If not then you can take a date input element and compare the input value with the purchase date.
Thank you karamwise. I understand what you say. But I’m not getting any input from anywhere to compare with the item purchase date. The RG logic should be: while the dates are the same don’t list it. When a record with a different date comes out, then list it. Then all over again, when the dates are the same don’t list it… In other languages that I can read each record, I can do that. Using a do while loop I can bypass any record I want. Thank you, indeed. Jairo.
Hey @jairo.ibp ,
I understood your problem… Here is the solution to your problem when you search for the data apply the constraint. As shown in the screenshot below.
This will list the items which will not contain the current date.
add a field list on that table and put the all same value items of a specific purchase date.
on RG make conditions. if the list is empty.
ITEM = when this field is empty show the item list( 1 item)
ITEM LIST = when the field list is empty show the item field (this field is only for the same value of items) to get 1 record chose this field’s first item
DATE = current date
Thank you vence.naga. I’ll try it. Thanks again. Jairo.
This topic was automatically closed after 70 days. New replies are no longer allowed.