topic Re: How to restrict first row in App Development

How to restrict first row

Sra1bandi — Wed, 05 Mar 2025 05:51:24 GMT

Hi Team,

I have a requirement to restrict first task in first row

Code	Plant	Class	Procurement Type	Workflow	WF-Formkey	Task	TaskDescription	TS_Opening_Date	TS_Closing_Date
57546	BRI1	SU	E	57546BRI1FSAP	57546BRI1	82827	Initiate Plant Extension	02-03-2025	02-03-2025
57546	BRI1	SU	E	57546BRI1FSAP	57546BRI1	83326	Initiate Plant Extension	02-04-2025	02-04-2025

Code,plant,taskdescription are main fields

for same code and same plant two tasks are created i need to select only latest task which is in 2nd row in above example like this i have multiple codes are available with two tasks for same code but i need to show only latest tasks .

Regards,

Sravan.

Re: How to restrict first row

PrashantSangle — Wed, 05 Mar 2025 06:06:50 GMT

where in front end or back end??

in front end

take straight table

take all field as dimension

Expression - max(Task)

in backend

Load <all_fields_name_except_task>,max(task) as task from yourtable

Group by all_fields_name_except_Task;

Regards,

Prashant Sangle

Re: How to restrict first row

Chanty4u — Wed, 05 Mar 2025 12:40:00 GMT

Try this

IF(

TS_Opening_Date = Aggr(Max(TS_Opening_Date), Code, Plant),

TaskDescription)