Skip to main content
4-Participant
December 28, 2023
Question

How to compare 2 views data columns by using get row count and return not matching data on UI

  • December 28, 2023
  • 1 reply
  • 990 views

I have 2 views data(table in each view please check screenshot) fetched it from SQL query in Thingworx and in that 2 views  same columns are available. 

Issue is - In first view of gcid column 4928 is not available and in 2nd view it's available so, I want to compare both the views data row by row. I want to fetch 4928 gcid platform column from 2nd view and want to show platform for 4928 gcid on UI (Same data available in both the views except 4928 gcid) I have attached ss of both the views data and already written code in attached file. please check it. code is already written by developer. I have to do changes for it.

On UI now showing following platforms need to add one more platform from 2nd view data(UI screenshot attached at the end)
(AvailabilityPlatformSummaryTable) and (SBDAvailabilityGC_PlatformTable )views names in code

Unable to apply logic for it. where should I do changes in code? Please let me know asap.
If something is needed please ask me.

AC_10463669_0-1703768495605.png

AC_10463669_0-1703770017787.png

 

AC_10463669_3-1703769577651.png

 

Thank you.

1 reply

14-Alexandrite
January 11, 2024

If possible would suggest do a JOIN in SQL itself, else you can look Infotable join.