cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - Stay updated on what is happening on the PTC Community by subscribing to PTC Community Announcements. X

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

AC_10463669
4-Participant

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

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 1

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

Top Tags