Between dates (again)

[Ted Giles]

It's been a while, and I am convinced I had this working, but cannot do it now.

I need to have 2 dates - Start and End, so I created an IMDB with a single row for each date and the tables are StartDate and EndDate and the fields are Start and End.
I split the existing panel and put the 2 IMDB tables into the top half.
Problem is when selecting into variables. The first table in the IMDB suddenly has both fields - Start and End.

So back to basics.
How is it best to display the start and end dates, and then filter data based on those dates?

[ljwilson]

In general I try to have just one imdb single row table for all of the query fields I need, and use that everywhere, only selecting the fields I want.

Try this:

one imdb singlerow table (lets call it MyFilters)

That table has two date fields: Start Date and End Date.

Use this imdb table on your panel top half.

Then see what happens.

...jack

[Ted Giles]

I was over thinking it, Jack.
Created a new test app.
Added an IMDB with 2 fields. Data is selected using the two IMDB fields.
Works well, and no need to mess with variables.

ONE PROBLEM!
My IMDB Icon has gone missing in the development app. How do I get it back?

[ljwilson]

I'd reboot the computer first if you haven't already.
Failing that...
If you create a new imdb table in the dev project does the icon show?

If so then you could recreate the imdb table and drag it over to where the old one is used to replace it, then delete the old imdb table.

If not then does an imdb table icon show in a new project? Worst case you could drag all the items from the old project to the new one project.

...jack

[Ted Giles]

Weird.
I just created a new folder, called it IMDB - it was in the web app section - and added a new table and fields.
It looked just like the normal one and files were accessible and worked.
So it seems like the IMDB name is recognised anywhere as a special name. I assume therefore that you could have many separate IMDB'S

[ljwilson]

Most definitely.

These 9 IMDB tables are in the acme invoice example:

2021-06-26_6-57-04.png (11.65 KiB) Viewed 2730 times

...jack

[Ted Giles]

Yes I get that, Jack.
I created a new IMDB folder - just typed it in and it appears at the bottom of the folder list.
I wondered if you could place multiple IMDB folders in different places.
Not sure why, just curious.

[ljwilson]

I think IMDB is just a folder name automatically created for new projects.
Folder names must be unique within a given app/component.

...jack