topic Filter values in App Development

Filter values

Loeckli — Thu, 18 Aug 2022 10:10:43 GMT

Animals	Test	Status	Start	End
fish	weight	in process	12.08.2022
fish	distance	preparing	18.08.2022
fish	color	finished	10.08.2022	18.08.2022
tiger

I want to know if there is a possibilty for checking the test colum on their status and only do the calcuation of the same animals if all status are finished. Is there also an other approach for cheking the if all status of each animal is finished ?

Re: Filter values

Lakshminarayanan_J — Thu, 18 Aug 2022 10:48:40 GMT

@Loeckli

could you please post the expected result format to work on?

Re: Filter values

Loeckli — Thu, 18 Aug 2022 11:05:50 GMT

the result is a statement which takes only the animals into account which have on all level the status finished for their test. For these animals I only want to calculate the duration. For the moment the statement takes all the rows into account which have a value in the the colum. So if only in one row like in the above example is a date in the last row the whole animals will be taken into account. This needs to be changed