Implement search algorrithm on zoho data

Implement search algorrithm on zoho data

Hi,

I have to created a form which takes the user input and stores data, for example a form like expenses.

Now i have to create a page which will take input like expense type/date/ expense by fields and select all the rows belonging to the input and calculate the aggregate expense and display it to user.

If i give all the parameters the logic works but i want to know if we can build dynamic queries based to user input to fetch the records from the database.