HI
I have more than 4 column in my DB for date-time. I want to filter all the row of which any of the date value falls between tomorrow and next 7 days.
I know I probably have to use in the do a search for’s filter condition but can’t figure it out how to use it.
Hi there, @tanmoy_cgartist… if I understand your post correctly, these constraints on a search should do the trick.
Hope this helps.
Best…
Mike
I’m not infront of my computer, but do a search with a constraint of the event <= current date +days +7. And also current days +1 for it being tomorrow.
Hope this helps
Hi thanks for the help. didn’t know that more than one constraint can be coupled, i thought the bottom one overwrite the others.
This is great for single date, in my DB I have more than 4 different date column, so i want to check if any of those date are in the given range, Basically I want to filter out any row of which any of the date value is falling in between tomorrow and next 7 days.
I think i will have to use “Search for Items:filter”
Sorry for any stupid question, I’m new to bubble
It’s not that your question is stupid, it’s that what you wrote in your last post and what you have now edited your original post to say isn’t even close to what the original post initially said. So, you know, that.
And even now the question isn’t clear because the original post makes it seem like you want things where any one of a number of dates falls between tomorrow and the next 7 days, and your last post says you want to filter those things out.
Draw us a picture or post your database design or something to clarify. And why would you need more than one date range? Let’s optimize it!
I’m sorry if it sounds confusing. My main moto is :
I have a DB with 4 date field. Now I want my repeating group to show only the entries/rows in my DB of which any of those dates falls between tomorrow and next 7 days.
Example:
Row1 has all 4 date value from last month— so it will not show up,
Row2 has 1 date value which is day after tomorrow ----so it will show up
Row3 has 2 date value which is within next 7 days---- so it will show up
With your latest description of what you are trying to do, try using the merged with operator to merge four searches together (one for each of the date fields) that have constraints that look like what I showed in the screenshot in my initial reply.
I’m not even distantly related to the coding/no coding or data base stuff, but I enjoy logic, I’m from purely creative industry so I’m pretty sure my db structure is garbage.
Here each row is one item(asset) of which there are multiple stages(rig,texture,model,shading) so does multiple due dates and multiple user for each stages.
Now I want to populate my repeating group which only shows only the items/asset/row of which any of those dates fall under tomorrow and next 7 days.
So that I can see what asset has due dates in next 7days.
Thank you very much it worked.
I see what you are doing. You are creating critical dates in those fields for you creative workflow. What you should try to do is use a secondary data thing which is strictly for dates and the description of that event, and tie it together with the unique id of your main thing “gameboy” or “camera”.
Then you can do a search for all date things that match your single camera thing.
Not at comp now, sorry for no examples.
