How to compare 2 views data columns by using get row count and return not matching data on UI
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
Thank you.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
If possible would suggest do a JOIN in SQL itself, else you can look Infotable join.
