NodeJs, Docker project, dealing with a server action, I would like to add a where() formatter, in the UI it is doing it like this
{{tstC.where('image_type', '==', ism_type)}}
I find it strange because image_type and ism_type are both dynamic values and both being picked from database multi queries, this is reading to me like one is a string and the other a dynamic value.
I tried this
{{tstC.where(`image_type`, '==', `ism_type`)}}
Which I always thought was correct, using backtick, but I get a lexar error of unexpected token
Here is a screenshot of what the server action looks like
What I want to do is take 2 different multi database queries from 2 different database servers and join the common column together.
Which works fine at that point.
My next 2 setValue steps is where I am trying to only display the records where the results only come from one of the databases and not both
I have a project where i connect to 2 different databases, both the databases contain a list of car makes/models as an example.
Database 1 has 30 records and Database 2 has more than 100
Some cars in Database 1 are the same as Database 2
Some cars in Database 1 are unique to Database 1
Some cars in Database 2 are unique to Database 2
I want to get a single list in the end only showing all the unique records from both databases, and remove all the results that appear in both databases.
Could create a view across both tables and use distinct possibly (not sure if that would work without a where though), ie a where clause using a common denominator to filter down the results? Let me think a little more about it…
