No, This is still an active problem. and demon, you must work in customer relations

I updated Cargo as of 0900 23 March 2017, has there been a change since then?

Update PageForms to Page Forms 4.1 (380aafb)
Still are seeing the above problem.

Any page that we put that Cargo Query on, fails. Normal cargo table views and drilldowns work fine.

Yaron,
Sorry, but I think you are still missing part of the problem. Take the following example, here we are declaring a Cargo table
called Observation, it has 8 fields named Observation_topic, Event_Name, WFC_Title, WFF, keyword, Observation_type, Observation_Discussion,
and Observation_recommendation, declared as such:

We simplified the Cargo query to:
{{#cargo_query:
tables=Observation,Event

}}

How could this be closed, Resolved , if it has not been tested against MSSQL?

Awesome! Good Job, looks like everything is working as it should.
Thanks, it was really good meeting you at EMWCon last week.
Jerome

Did a new GIT Pull, moved the files to our wiki codebase.
still found one DAYOFMONTH function call line 148 of cargofilter.php I corrected that by changing it to just DAY,

From the drill down page:

OK, I did a New GIT Pull and placed it into my wiki codebase. I found two more uses of the "DayOfMonth" function that I changed to "Day". They were line 119 of CargoAppliedFilter.php and line 141 of CargoFilter.php I am still experiencing two errors during "View" and "Drilldown".
The "VIEW" Error is:
<br />
<b>Warning</b>: htmlspecialchars() expects parameter 1 to be string, object given in <b>C:\inetpub\wwwroot\WCR\extensions\Cargo\CargoSQLQuery.php</b> on line <b>1214</b><br />

I did a GIT Pull...

Yaron,
I used GIT to download the files and put them in place. One of the errors, is corrected. The error for the drilldown page is fixed and the page shows with the correct dates, but the "VIEW" page still has the error:

Yaron,

I changed the function from dayofmonth to day and now I am getting the following error:

Git download solved the problems!!!!
Thank You!!!!
Jerome

No, I used the Zip file download from the cargo Main page.
I will try to get it with GIT and let you know how it goes...
Thank you!!

Yaron,
This is lines 70 - 89, showing whare I placed what you sent above.
$fieldType = $fieldDescription->mType;

			// Special handling for URLs, to avoid them
			// overwhelming the page.
			// @TODO - something similar should be done for lists
			// of URLs.
			if ( $fieldType == 'URL' && !$fieldDescription->mIsList ) {
				// Thankfully, there's a message in core
				// MediaWiki that seems to just be "URL".
				$fieldName = "CONCAT('[', $fieldName, ' " .
					$this->msg( 'version-entrypoints-header-url' )->parse() . "]')";
			}

Line 83 is in the middle of an IF statement: $fieldType = $fieldDescription->mType; I placed it in there, but nothing was displayed on the screen when I went to Special:Cargo Tables, it just listed the 9 table that we have defined

Yaron, I updated to Cargo ver. 1.3 I am still getting a Concat error: A database query error has occurred. This may indicate a bug in the software.
◾Query:
SELECT TOP 100 [_pageName] AS [Page],CONCAT('[', link, ' URL]') AS [link],[sometext] AS [sometext] FROM [wiki].[cargo__hufftest1] ORDER BY [_pageName]

Yaron,