Hi Martin :

There are 23 projects that appear if you filter projects by "Transport - Transit" and "Transport - Heavy Rail" on Dev ILG live. Could you replace them all with "Transport - Commuter Rail"?

I added "Transport - Commuter Rail" under meta field list of Industry Subsector on Dev ILG admin, but I still don't see it as a filter option on Dev ILG live. What is the reason why I don't see 58 options appearing on the Dev ILG admin site on Dev ILG live (I see only 31)?

Industry Subsector Transport - Communter Rail (26-May-22).mp4 7.16 MB • Download

Thanks,

Paul

Hi Hiren ,

For Paul 's main request, I assume that the task is easy, and that you only need to perform a few UPDATE queries against the database. Can you let us know if it is more complex than that?

I have created DevOps item https://dev.azure.com/tologix/ILG/_workitems/edit/1929 for this.


Additionally, can you help answer Paul's other question (details in video)?
My theory is that we might only display 31 entries in the drop-down since the other 27 might not have been used.

Thanks,
-Martin

Hi Paul and Martin ,

1) I have replaced "Transport - Transit" and "Transport - Heavy Rail" with "Transport - Commuter Rail" in Industry subsector meta fields of projects.
2) In Industrial Subsectors there are totally 58 items but these all items are not used in projects which implemented in publish documents. There are around 29 items used in projects which we have implement in our publish documents so it is meaningless if we have to show all 58 items in Filter because there are no any project implementation in publish documents.

Thanks,
Hiren Patel    

Hi Hiren :

1. In the first video (around 2:27), there were 23 projects under "Transport - Transit" and "Transport - Heavy Rail." However, now I see 27 projects under "Transport - Commuter Rail" after you replaced the meta field. It looks like there are 4 more projects, while we didn't add any more projects on dev ILG admin site. Could you explain the discrepancy?

2. Ok, understood.

Thanks,

Paul

Hi Paul ,

I had made changes using SQL query for update Industrial Subsectors and all data are correct but some how it was not display in project list in search document at subscriber side. I had also verified this data with ILG production (https://infrastructurelawguide.com ) data from where we had taken it into ILG staging. (https://dev.infrastructurelawguide.com).  

Thanks,
Hiren Patel

Hi Hiren :

Did you make changes ("Transport - Transit" and "Transport - Heavy Rail" to "Transport - Commuter Rail") on ILG subscriber site as well? I asked Nafiseh to make the change on https://infrastructurelawguide.com, so you may need to change the SQL query after she finishes the update.

As for Dev ILG live site, it looks good as shown below, but I noticed the "Browse by Project" option is listing projects in a random order; please sort it alphabetically.

Browse by Project appearing in a random order (6-Jun-22).mp4 1.5 MB • Download

Thanks,

Paul

Hi Paul ,

1) I have only replaced ("Transport - Transit" and "Transport - Heavy Rail" to "Transport - Commuter Rail") in project's master list .There is no any changes will require to subscriber side.

2) https://infrastructurelawguide.com is ILG production side so as per my view, as of now no need to change on it. we will do it later when we will upload all ILG staging (http://dev.infrastructurelawguide.com)  changes to ILG Production (https://infrastructurelawguide.com). Please Provide your feedback.

3) I will update you once Project ordering in ascending  will complete. 

Thanks,
Hiren Patel

Hi Hiren and Martin :

It is important to note that Nafiseh is currently updating ILG production admin site with new project information. ILG production (admin) site has more projects than ILG dev (admin) site. When we deploy all the features and fixes to ILG production site, it's crucial that we do not wipe out the existing content on ILG production site. 

Nafiseh has updated ILG production site with "Transport - Commuter Rail" already.

Please ensure that we have the projects appearing in alphabetical order before Friday (we have an ILG demo on Monday).

Thanks,

Paul

Hi Paul and Martin ,

projects appearing in alphabetical order changes has been done. Please check and provide your feedback.

Thanks,
Hiren Patel

Thanks, Hiren .