Hello,
I have a reactive application. I have 2 tables: 1 table to show machines (e.g Machine A, Machine B etc.) and another table that shows the status of the machine (basically to keep track of the availability of the machine)
I would like a page with a quick overview to show all available machines. So ideally, I want to see every single machine from the first table minus those that are in use from the second table. I am not able to simply filter by status because some machines havent been used yet and they wont appear in the summary page if I filter it by status. Any suggestions? Thank you!
Hi Low,
Can you please share a screenshot for that aggregate need to verify which join you are using between these two tables.
Also filter screenshot that help me to understand more.
Regards,
Rajat
hi @Low Nico ,
I think you can have a With or Without join from Machines table to Machines Status table.
Then in your filter, you can filter by status = availableStatus or status = nullidentifier() (if status is an idenfitier, if not, you can use MachineStatus.Id = nullidentifier())
Bryan
Hi @Low Nico
You have two Table (Table A has with one to one Relationship With TableB like this)
Join like this:
Filter Like this:
MachineAvaiblity.Isavailability=True
I have Attached oml File so please go through this:
Thanks
Md Mansur
Hi,
When using filters with tables that might not have yet data defined, you should use the filter on the Join Condition instead of using in the filters tab.
Try using refresh aggregates, and keep the aggregate fetch on demand. For two tables to be joined, you must have some foreign key (if not do implement) as it is 1 to 1 if all machines are unique and quantity of each is 1 max.
Now that you have joined them, filter them out using their status, and use refresh aggregate everywhere you think the status of the machine might change. So the results you get now will be accurate and in sync.
Hope it helps.
Tejas Mahale.