Hi everyone, has anyone done drill downs in SuiteScript? I want to create a Suitelet that shows me various transactions according to applied filters, and I want to be able to drill down to view the transaction summary and its detailed timestamp.

Fairly easy, created multiple suitelets like this. With the help of suiteql using a suitelet and a client script field change (to update the suitelet based on the selections) What exactly are your filters.

I need a Suitelet in NetSuite to query the progression of transactions from inception (for sales: opportunity - estimate - sales order - sales order approval - item order fulfillment - sales invoice - customer payment - return authorization generation (if applicable) - returned item receipt (if applicable) - credit memo issuance - credit memo application to new sales invoice); for purchases: purchase order - purchase order approval - purchase order receipt - supplier payment - supplier credit (if applicable). The query process should begin with selecting the process (whether it's Sales or Purchases), it should have date, location, and transaction type filters to visualize state changes, approvals, and related record generation, all including the employee who generates the transaction record, the employee who approves the transaction, and their respective date and time

So the user will select the sales or purchases. Let's assume it's sales it will list down all the sales order. They can select anyone of them. Then in the next view they will see all the mentioned transactions their approves, etc in the sublist ?

yes, it is, and i need to know how make the drill down for each sales order, to show the state changes, approvals, and related record generation, all including the employee who generates the transaction record, the employee who approves the transaction, and their respective date and time

It's not a small task, and will require a complex query with a lot of unions I am assuming. Will take a few days at least to build the complete thing out. First of all I suggest you start with a basic view of the suitelet where you have the mentioned filters. Based on what user selects on a field change display the purchase order or sales order in the sublist. Against each order provide a link which has the param of the sales order or purchase order internal id, among few others as needed. When that link gets clicked, redirect it to the same suitelet but now instead provide a detailed view. Where based on the query suitelet has populated the sublidt with all the info. I have built something like this recently. But suiteQL query is the one thing that will take way too much time for this requirement.

thanks for the advice @raghav !!!