SELECT
T0.ItemCode AS 'Item',
T0.ItemName AS 'Name',
CASE
WHEN T0.QryGroup37 = 'Y' THEN 'FG'
WHEN T0.QryGroup48 = 'Y' THEN 'SA'
WHEN T0.QryGroup11 = 'Y' THEN 'RAW'
END AS 'RAW-SA-FG',
T1.ItmsGrpNam AS 'Group',

CASE
WHEN T0.QryGroup55 = 'Y' THEN 'x - No Recount Need'
WHEN T0.QryGroup56 = 'Y' AND T0.QryGroup12 = 'N' THEN 'Ilya (Plastic)' /* Not CO2 */
WHEN T0.QryGroup56 = 'Y' AND T0.QryGroup12 = 'Y' THEN 'Ilya (CO2)' /* CO2 */
WHEN T0.QryGroup57 = 'Y' THEN 'Sofi (Chemical)'
WHEN T0.QryGroup58 = 'Y' THEN 'Ilya (Electronic)'
WHEN T0.QryGroup59 = 'Y' THEN 'Alex (Laboratory)'
WHEN T0.QryGroup60 = 'Y' THEN 'Shay (Salt)'
END AS 'Dept Manager',

CASE
WHEN T0.QryGroup12 = 'Y' THEN 'CO2'
WHEN T0.QryGroup13 = 'Y' THEN 'Ozonizers'
WHEN T0.QryGroup14 = 'Y' THEN 'Controllers'
WHEN T0.QryGroup15 = 'Y' THEN 'Heating'
WHEN T0.QryGroup18 = 'Y' THEN 'Berlin'
WHEN T0.QryGroup19 = 'Y' THEN 'Prizm'
WHEN T0.QryGroup20 = 'Y' THEN 'Prizm Pro'
WHEN T0.QryGroup22 = 'Y' THEN 'Merlin'
WHEN T0.QryGroup29 = 'Y' AND T0.QryGroup60 = 'Y' THEN 'Marine'
WHEN T0.QryGroup30 = 'Y' AND T0.QryGroup60 = 'Y' THEN 'Fresh'
WHEN T0.QryGroup24 = 'Y' AND T0.QryGroup57 = 'Y' THEN 'Food'
ELSE '--'
END AS 'Type',

CASE
WHEN T0.QryGroup38 = 'Y' THEN 'Labels'
WHEN T0.QryGroup39 = 'Y' THEN 'Charts'
WHEN T0.QryGroup40 = 'Y' THEN 'Bottles'
WHEN T0.QryGroup41 = 'Y' THEN 'Boxes'
WHEN T0.QryGroup42 = 'Y' THEN 'Manual'
WHEN T0.QryGroup52 = 'Y' THEN 'Packing'
WHEN T0.QryGroup54 = 'Y' THEN 'Box-Outer'
WHEN T0.QryGroup63 = 'Y' AND T0.QryGroup60 = 'Y' THEN 'Bulk Packs'
ELSE '--'
END AS 'SubType',

CAST(T0.SellItem AS VARCHAR(5)) AS 'Sale',
CAST(T0.QryGroup33 AS VARCHAR(5)) AS 'Import',
CAST(T0.TreeType AS VARCHAR(5)) AS 'Tree Type',
CAST(T0.PrchseItem AS VARCHAR(5)) AS 'Purchase'

FROM OITM T0
INNER JOIN OITB T1 ON T0.ItmsGrpCod = T1.ItmsGrpCod

WHERE T0.Canceled ='N' AND
T0.InvntItem = 'Y' AND
( T0.QryGroup58 = 'Y' AND T0.ItemName LIKE '%Zone%' )

ORDER BY T0.ItemCode

1.Extract InfoPath form
2. Open View.xsl file
3. In the control property put xd:disableEditing="yes"
4. Save the file

exec sp_attach_db @dbname = 'Portal', @filename1 ='C:\Program Files\Microsoft SQL Server\MSSQL$VISHAL\Data\Portal.mdf', @filename2 ='C:\Program Files\Microsoft SQL Server\MSSQL$VISHAL\Data\Portal_log.LDF'
go

exec sp_detach_db 'Portal'
go

SELECT * FROM sys.dm_os_cluster_nodes

SELECT SERVERPROPERTY('ComputerNamePhysicalNetBIOS') ActiveNode

# Unpack XSN file using extract.exe utility to the local temporary directory.
# Find manifest.xsf file and open it as a plain XML file.
# Replace the corresponding URLs using the XML DOM.
# Save the modified manifest.xsf.
# Pack all files into the XSN using makecab.exe utility.
# Clean up your temporary directory.

check URL

String.prototype.trim = function() { return this.replace(/^\s+|\s+$/, ''); };

Now use

var str = "vishal";
str.trim();

fso.GetAbsolutePathName(".")

XDocument.IsNew

If this property is true it means the form is first time opened.
If false, already submitted form is opened.