Adv Filtering aint filtering

mack2580 · 2024-11-23T04:30:56.474Z

Trying to do an initial time by linking my start times to my reference list times. The filter isn’t working. When I do a search for a filter that way it works however I have to format my start date to match my reference date that’s why I was planning on using adv filtering.

Screenshot 2024-11-22 at 10.00.08 PM898×632 55.4 KB

Screenshot 2024-11-22 at 9.10.59 PM525×209 5.41 KB

mitchbaylis · 2024-11-23T06:37:32.133Z

it likely is filtering but taking a long time to process due to the complexity of that query

if you are comparing X to a list of 1000 things and formatting 1000 things values before comparing… well that’s quite intensive to do.

rethink how you do the query to simplify the request - possibly bring data forward in the data structure so you don’t need to do a nested advanced filter client side but can instead do a search server side.

alex.esposito.1108 · 2024-11-23T07:05:10.745Z

Can you provide a bit more context? What are you showing in that table and what are you wanting to do with that initial input’s value?

Also, just a heads up for advanced filters…the ignore empty constraints option does not work. The equivalent would be to append this expression to the advanced filter: or Search for Time - Cards:each item's Start Dates:first item is empty

mack2580 · 2024-11-23T13:33:11.529Z

There’s only one thing in the database at the moment.

mack2580 · 2024-11-23T13:34:52.941Z

I want to display the time card’s start and end dates alongside the corresponding row, based on whether the current user has already submitted a time card.

I’m aiming to create something similar to this: Time Card Calculator | TimeSheet Calculator | Hours Calculator. I’m showing the first value, but I have three key dates: a Reference Date, Start Date, and End Date. The Reference Date is shown in the table. I’m using logic to match the Start Date to the current row’s Reference Date.

When I check the debugger, it shows all the dates correctly, just looks like it ignoring grabbing the first date the corresponds to reference date.

system · 2025-02-01T04:31:33.133Z

This topic was automatically closed after 70 days. New replies are no longer allowed.