How can I filter by date from a collection where the date is part of an addon from Xano

[plucky00]

Hi All

I’m new to Weweb and the terminology, not a programmer, I managed to learn it pretty quick anyway , I am struggling trying to filter a collection by date, where the date field is returned from another table (Addon in Xano API), I cannot reach the date field in the filter section, as I can only access the entire object (returned by the addon). I’d appreciate your help,

This is the Xano API result, you can see the Addon that includes the date highlighted:

When I try to filter the collection, I cannot reach that field, is there another way solution where I can do that?

Thanks!!!

[visualdevs]

I’m looking for a solution to this too.
I asume that a way is to create a column in the table that shows the date (so you bring this data to the surface) to filter, but not sure if this is the best way to do it.

[MichaelLovell]

I have an Addon where I’m accessing the ‘last_active’ date property and then filtering if ‘last_active’ is greater than 2 days ago.

I apply the following code to the Collection List

// Access the global variable containing the data
const items = collections['c0876745-e0f1....de439c6947c9']['data']['items'];

// Get the current timestamp
const currentTime = Date.now();

// Calculate the timestamp for 2 days ago
const twoDaysAgo = currentTime - 2 * 24 * 60 * 60 * 1000;

// Filter the items based on the 'last_active' property
const filteredItems = items.filter(item => {
  // Check if 'last_active' property exists and if it's greater than 2 days ago
  return item._content_of_user.last_active && twoDaysAgo > item._content_of_user.last_active;
});

// Return the filtered items
return filteredItems;

The other method is to add the property as an Eval in Xano.

[Quentin]

Hey @plucky00

That’s a known issue on our side: nested filters (aka the ability to filter on nested objects).

We’re planning on adding this feature in a few weeks. In the meantime, a frontend filter like @MichaelLovell suggested seems the right solution!

[plucky00]

Thanks for yor answer @MichaelLovell and @Quentin!! I will try the JS code solution or doing the filter in Backend.