Refreshing JSON Var used in Script.js file
Hello,
Is there a way to refresh value of JSON Var used in included script file?
Im using @Request.my-entity-id~ in SQL WHERE clause to get the data. After that the user has the ability to change the value of @Request.my-entity-id~ (input text element), and refresh some of the elements in the report (AJAX).
Is there a way to refresh the script file variables, without reloading the page?
<Report
ID="Test"
>
<DefaultRequestParams
my-entity-id="803"
/>
<LocalData
ID="my-local-data"
>
<DataLayer
ConnectionID="SavillsPostgres"
Source="select
entity_id,
scheme_name
FROM scheme1.entity
WHERE entity_id = '@Request.my-entity-id~'
"
Type="SQL"
>
<DataLayerLink
ID="entity-link"
/>
</DataLayer>
</LocalData>
<Body>
<Label
Caption="@Local.entity_id~"
ID="my-label-one"
/>
<Label
Caption="@Local.scheme_name~"
ID="my-label-two"
/>
<InputText
Caption="Entity ID:"
DefaultValue="@Request.my-entity-id~"
ID="my-entity-id"
/>
<Button
Caption="Refresh"
ID="refresh-btn"
>
<Action
ElementID="my-label-two, my-label-one, my-local-data"
ID="action-refresh"
PostRefreshJavascript="load_js();"
Type="RefreshElement"
/>
</Button>
</Body>
<IncludeScriptFile
ID="test-js-file"
IncludedScriptFile="test.js"
>
<JsonData
ID="test-json-data"
JsonHumanReadable="True"
JsonVarName="testVar"
>
<DataLayer
ID="test-json-link"
LinkedDataLayerID="entity-link"
Type="Linked"
/>
</JsonData>
</IncludeScriptFile>
<ideTestParams
my-entity-id=""
/>
</Report>
0
-
One way you could do this is to use a Logi Data Definition and have your script perform an ajax to retrieve the updated data
Report Definition
<Report ID="LogiForum.ajaxDataDefinition">
<IncludeScriptFile IncludedScriptFile="https://ajax.googleapis.com/ajax/libs/jquery/3.6.0/jquery.min.js" />
<DefaultRequestParams CategoryName="Dairy Products" />
<LocalData>
<DataLayer Type="XMLFile" XMLFile="ApplicationCommon.data.Northwind.xml" MaxRows="50">
<DataLayerLink ID="dlNorthwind" />
<CompareFilter CompareType="=" DataColumn="CategoryName" ID="cfCategoryName" CompareValue="@Request.CategoryName~" />
<DataLayerLink ID="dlCategoryName" />
</DataLayer>
</LocalData>
<Body>
<IncludeScript IncludedScript="function test(CategoryName) {
 $.ajax({
 url: "./rdTemplate/rdData.aspx?rdData=newData&rdDataID=jsonCategoryName&CategoryName="+CategoryName, 
 success: function(data) {
 alert(data);

 }
 });
 
}" />
<InputSelectList OptionCaptionColumn="CategoryName" ID="CategoryName" OptionValueColumn="CategoryName" DefaultValue="@Request.CategoryName~" MultiSelect="False">
<DataLayer Type="Linked" LinkedDataLayerID="dlNorthwind">
<DeDuplicateFilter DataColumns="CategoryName" />
</DataLayer>
<EventHandler DhtmlEvent="onchange">
<Action Type="RefreshElement" ElementID="divReport" ID="areReport" />
</EventHandler>
</InputSelectList>
<Division ID="divReport">
<Image Caption="blank.png" ID="imgBlank">
<EventHandler DhtmlEvent="onload">
<Action Type="Javascript" ID="actjs" Javascript="test('@Request.CategoryName~');" />
</EventHandler>
</Image>
<Label Caption="@Function.DateTime~" />
</Division>
</Body>
<ideTestParams CategoryName="" />
</Report>Data Definition: newData.lgx
<Data ID="CategoryName">
<JsonData ID="jsonCategoryName" JsonVarName="data">
<DataLayer Type="XMLFile" XMLFile="ApplicationCommon.data.Northwind.xml" MaxRows="50">
<CompareFilter CompareType="=" DataColumn="CategoryName" ID="cfCategoryName" CompareValue="@Request.CategoryName~" />
</DataLayer>
</JsonData>
<ideTestParams rdDataID="jsonCategoryName" CategoryName="Dairy Products" />
</Data>ApplicationCommon.data.Northwind.xml
<rdData>
<dt ProductName="Queso Cabrales" CategoryName="Dairy Products" UnitsInStock="22" UnitsOnOrder="30" CustomerID="VINET" OrderID="10248" OrderDate="1996-07-04T00:00:00-04:00" RequiredDate="1996-08-01T00:00:00-04:00" ShippedDate="1996-07-16T00:00:00-04:00" Freight="32.3800" UnitPrice1="14.0000" Quantity="12" Discount="0"/>
<dt ProductName="Singaporean Hokkien Fried Mee" CategoryName="Grains/Cereals" UnitsInStock="26" UnitsOnOrder="0" CustomerID="VINET" OrderID="10248" OrderDate="1996-07-04T00:00:00-04:00" RequiredDate="1996-08-01T00:00:00-04:00" ShippedDate="1996-07-16T00:00:00-04:00" Freight="32.3800" UnitPrice1="9.8000" Quantity="10" Discount="0"/>
<dt ProductName="Mozzarella di Giovanni" CategoryName="Dairy Products" UnitsInStock="14" UnitsOnOrder="0" CustomerID="VINET" OrderID="10248" OrderDate="1996-07-04T00:00:00-04:00" RequiredDate="1996-08-01T00:00:00-04:00" ShippedDate="1996-07-16T00:00:00-04:00" Freight="32.3800" UnitPrice1="34.8000" Quantity="5" Discount="0"/>
<dt ProductName="Tofu" CategoryName="Produce" UnitsInStock="35" UnitsOnOrder="0" CustomerID="TOMSP" OrderID="10249" OrderDate="1996-07-05T00:00:00-04:00" RequiredDate="1996-08-16T00:00:00-04:00" ShippedDate="1996-07-10T00:00:00-04:00" Freight="11.6100" UnitPrice1="18.6000" Quantity="9" Discount="0"/>
<dt ProductName="Manjimup Dried Apples" CategoryName="Produce" UnitsInStock="20" UnitsOnOrder="0" CustomerID="TOMSP" OrderID="10249" OrderDate="1996-07-05T00:00:00-04:00" RequiredDate="1996-08-16T00:00:00-04:00" ShippedDate="1996-07-10T00:00:00-04:00" Freight="11.6100" UnitPrice1="42.4000" Quantity="40" Discount="0"/>
<dt ProductName="Jack's New England Clam Chowder" CategoryName="Seafood" UnitsInStock="85" UnitsOnOrder="0" CustomerID="HANAR" OrderID="10250" OrderDate="1996-07-08T00:00:00-04:00" RequiredDate="1996-08-05T00:00:00-04:00" ShippedDate="1996-07-12T00:00:00-04:00" Freight="65.8300" UnitPrice1="7.7000" Quantity="10" Discount="0"/>
<dt ProductName="Manjimup Dried Apples" CategoryName="Produce" UnitsInStock="20" UnitsOnOrder="0" CustomerID="HANAR" OrderID="10250" OrderDate="1996-07-08T00:00:00-04:00" RequiredDate="1996-08-05T00:00:00-04:00" ShippedDate="1996-07-12T00:00:00-04:00" Freight="65.8300" UnitPrice1="42.4000" Quantity="35" Discount="0.15"/>
<dt ProductName="Louisiana Fiery Hot Pepper Sauce" CategoryName="Condiments" UnitsInStock="76" UnitsOnOrder="0" CustomerID="HANAR" OrderID="10250" OrderDate="1996-07-08T00:00:00-04:00" RequiredDate="1996-08-05T00:00:00-04:00" ShippedDate="1996-07-12T00:00:00-04:00" Freight="65.8300" UnitPrice1="16.8000" Quantity="15" Discount="0.15"/>
<dt ProductName="Gustaf's Knäckebröd" CategoryName="Grains/Cereals" UnitsInStock="104" UnitsOnOrder="0" CustomerID="VICTE" OrderID="10251" OrderDate="1996-07-08T00:00:00-04:00" RequiredDate="1996-08-05T00:00:00-04:00" ShippedDate="1996-07-15T00:00:00-04:00" Freight="41.3400" UnitPrice1="16.8000" Quantity="6" Discount="0.05"/>
<dt ProductName="Ravioli Angelo" CategoryName="Grains/Cereals" UnitsInStock="36" UnitsOnOrder="0" CustomerID="VICTE" OrderID="10251" OrderDate="1996-07-08T00:00:00-04:00" RequiredDate="1996-08-05T00:00:00-04:00" ShippedDate="1996-07-15T00:00:00-04:00" Freight="41.3400" UnitPrice1="15.6000" Quantity="15" Discount="0.05"/>
<dt ProductName="Louisiana Fiery Hot Pepper Sauce" CategoryName="Condiments" UnitsInStock="76" UnitsOnOrder="0" CustomerID="VICTE" OrderID="10251" OrderDate="1996-07-08T00:00:00-04:00" RequiredDate="1996-08-05T00:00:00-04:00" ShippedDate="1996-07-15T00:00:00-04:00" Freight="41.3400" UnitPrice1="16.8000" Quantity="20" Discount="0"/>
<dt ProductName="Sir Rodney's Marmalade" CategoryName="Confections" UnitsInStock="40" UnitsOnOrder="0" CustomerID="SUPRD" OrderID="10252" OrderDate="1996-07-09T00:00:00-04:00" RequiredDate="1996-08-06T00:00:00-04:00" ShippedDate="1996-07-11T00:00:00-04:00" Freight="51.3000" UnitPrice1="64.8000" Quantity="40" Discount="0.05"/>
<dt ProductName="Geitost" CategoryName="Dairy Products" UnitsInStock="112" UnitsOnOrder="0" CustomerID="SUPRD" OrderID="10252" OrderDate="1996-07-09T00:00:00-04:00" RequiredDate="1996-08-06T00:00:00-04:00" ShippedDate="1996-07-11T00:00:00-04:00" Freight="51.3000" UnitPrice1="2.0000" Quantity="25" Discount="0.05"/>
<dt ProductName="Camembert Pierrot" CategoryName="Dairy Products" UnitsInStock="19" UnitsOnOrder="0" CustomerID="SUPRD" OrderID="10252" OrderDate="1996-07-09T00:00:00-04:00" RequiredDate="1996-08-06T00:00:00-04:00" ShippedDate="1996-07-11T00:00:00-04:00" Freight="51.3000" UnitPrice1="27.2000" Quantity="40" Discount="0"/>
<dt ProductName="Gorgonzola Telino" CategoryName="Dairy Products" UnitsInStock="0" UnitsOnOrder="70" CustomerID="HANAR" OrderID="10253" OrderDate="1996-07-10T00:00:00-04:00" RequiredDate="1996-07-24T00:00:00-04:00" ShippedDate="1996-07-16T00:00:00-04:00" Freight="58.1700" UnitPrice1="10.0000" Quantity="20" Discount="0"/>
<dt ProductName="Chartreuse verte" CategoryName="Beverages" UnitsInStock="69" UnitsOnOrder="0" CustomerID="HANAR" OrderID="10253" OrderDate="1996-07-10T00:00:00-04:00" RequiredDate="1996-07-24T00:00:00-04:00" ShippedDate="1996-07-16T00:00:00-04:00" Freight="58.1700" UnitPrice1="14.4000" Quantity="42" Discount="0"/>
<dt ProductName="Maxilaku" CategoryName="Confections" UnitsInStock="10" UnitsOnOrder="60" CustomerID="HANAR" OrderID="10253" OrderDate="1996-07-10T00:00:00-04:00" RequiredDate="1996-07-24T00:00:00-04:00" ShippedDate="1996-07-16T00:00:00-04:00" Freight="58.1700" UnitPrice1="16.0000" Quantity="40" Discount="0"/>
<dt ProductName="Guaraná Fantástica" CategoryName="Beverages" UnitsInStock="20" UnitsOnOrder="0" CustomerID="CHOPS" OrderID="10254" OrderDate="1996-07-11T00:00:00-04:00" RequiredDate="1996-08-08T00:00:00-04:00" ShippedDate="1996-07-23T00:00:00-04:00" Freight="22.9800" UnitPrice1="3.6000" Quantity="15" Discount="0.15"/>
<dt ProductName="Pâté chinois" CategoryName="Meat/Poultry" UnitsInStock="115" UnitsOnOrder="0" CustomerID="CHOPS" OrderID="10254" OrderDate="1996-07-11T00:00:00-04:00" RequiredDate="1996-08-08T00:00:00-04:00" ShippedDate="1996-07-23T00:00:00-04:00" Freight="22.9800" UnitPrice1="19.2000" Quantity="21" Discount="0.15"/>
<dt ProductName="Longlife Tofu" CategoryName="Produce" UnitsInStock="4" UnitsOnOrder="20" CustomerID="CHOPS" OrderID="10254" OrderDate="1996-07-11T00:00:00-04:00" RequiredDate="1996-08-08T00:00:00-04:00" ShippedDate="1996-07-23T00:00:00-04:00" Freight="22.9800" UnitPrice1="8.0000" Quantity="21" Discount="0"/>
<dt ProductName="Chang" CategoryName="Beverages" UnitsInStock="17" UnitsOnOrder="40" CustomerID="RICSU" OrderID="10255" OrderDate="1996-07-12T00:00:00-04:00" RequiredDate="1996-08-09T00:00:00-04:00" ShippedDate="1996-07-15T00:00:00-04:00" Freight="148.3300" UnitPrice1="15.2000" Quantity="20" Discount="0"/>
<dt ProductName="Pavlova" CategoryName="Confections" UnitsInStock="29" UnitsOnOrder="0" CustomerID="RICSU" OrderID="10255" OrderDate="1996-07-12T00:00:00-04:00" RequiredDate="1996-08-09T00:00:00-04:00" ShippedDate="1996-07-15T00:00:00-04:00" Freight="148.3300" UnitPrice1="13.9000" Quantity="35" Discount="0"/>
<dt ProductName="Inlagd Sill" CategoryName="Seafood" UnitsInStock="112" UnitsOnOrder="0" CustomerID="RICSU" OrderID="10255" OrderDate="1996-07-12T00:00:00-04:00" RequiredDate="1996-08-09T00:00:00-04:00" ShippedDate="1996-07-15T00:00:00-04:00" Freight="148.3300" UnitPrice1="15.2000" Quantity="25" Discount="0"/>
<dt ProductName="Raclette Courdavault" CategoryName="Dairy Products" UnitsInStock="79" UnitsOnOrder="0" CustomerID="RICSU" OrderID="10255" OrderDate="1996-07-12T00:00:00-04:00" RequiredDate="1996-08-09T00:00:00-04:00" ShippedDate="1996-07-15T00:00:00-04:00" Freight="148.3300" UnitPrice1="44.0000" Quantity="30" Discount="0"/>
<dt ProductName="Perth Pasties" CategoryName="Meat/Poultry" UnitsInStock="0" UnitsOnOrder="0" CustomerID="WELLI" OrderID="10256" OrderDate="1996-07-15T00:00:00-04:00" RequiredDate="1996-08-12T00:00:00-04:00" ShippedDate="1996-07-17T00:00:00-04:00" Freight="13.9700" UnitPrice1="26.2000" Quantity="15" Discount="0"/>
<dt ProductName="Original Frankfurter grüne Soße" CategoryName="Condiments" UnitsInStock="32" UnitsOnOrder="0" CustomerID="WELLI" OrderID="10256" OrderDate="1996-07-15T00:00:00-04:00" RequiredDate="1996-08-12T00:00:00-04:00" ShippedDate="1996-07-17T00:00:00-04:00" Freight="13.9700" UnitPrice1="10.4000" Quantity="12" Discount="0"/>
<dt ProductName="Schoggi Schokolade" CategoryName="Confections" UnitsInStock="49" UnitsOnOrder="0" CustomerID="HILAA" OrderID="10257" OrderDate="1996-07-16T00:00:00-04:00" RequiredDate="1996-08-13T00:00:00-04:00" ShippedDate="1996-07-22T00:00:00-04:00" Freight="81.9100" UnitPrice1="35.1000" Quantity="25" Discount="0"/>
<dt ProductName="Chartreuse verte" CategoryName="Beverages" UnitsInStock="69" UnitsOnOrder="0" CustomerID="HILAA" OrderID="10257" OrderDate="1996-07-16T00:00:00-04:00" RequiredDate="1996-08-13T00:00:00-04:00" ShippedDate="1996-07-22T00:00:00-04:00" Freight="81.9100" UnitPrice1="14.4000" Quantity="6" Discount="0"/>
<dt ProductName="Original Frankfurter grüne Soße" CategoryName="Condiments" UnitsInStock="32" UnitsOnOrder="0" CustomerID="HILAA" OrderID="10257" OrderDate="1996-07-16T00:00:00-04:00" RequiredDate="1996-08-13T00:00:00-04:00" ShippedDate="1996-07-22T00:00:00-04:00" Freight="81.9100" UnitPrice1="10.4000" Quantity="15" Discount="0"/>
<dt ProductName="Chang" CategoryName="Beverages" UnitsInStock="17" UnitsOnOrder="40" CustomerID="ERNSH" OrderID="10258" OrderDate="1996-07-17T00:00:00-04:00" RequiredDate="1996-08-14T00:00:00-04:00" ShippedDate="1996-07-23T00:00:00-04:00" Freight="140.5100" UnitPrice1="15.2000" Quantity="50" Discount="0.2"/>
<dt ProductName="Chef Anton's Gumbo Mix" CategoryName="Condiments" UnitsInStock="0" UnitsOnOrder="0" CustomerID="ERNSH" OrderID="10258" OrderDate="1996-07-17T00:00:00-04:00" RequiredDate="1996-08-14T00:00:00-04:00" ShippedDate="1996-07-23T00:00:00-04:00" Freight="140.5100" UnitPrice1="17.0000" Quantity="65" Discount="0.2"/>
<dt ProductName="Mascarpone Fabioli" CategoryName="Dairy Products" UnitsInStock="9" UnitsOnOrder="40" CustomerID="ERNSH" OrderID="10258" OrderDate="1996-07-17T00:00:00-04:00" RequiredDate="1996-08-14T00:00:00-04:00" ShippedDate="1996-07-23T00:00:00-04:00" Freight="140.5100" UnitPrice1="25.6000" Quantity="6" Discount="0.2"/>
<dt ProductName="Sir Rodney's Scones" CategoryName="Confections" UnitsInStock="3" UnitsOnOrder="40" CustomerID="CENTC" OrderID="10259" OrderDate="1996-07-18T00:00:00-04:00" RequiredDate="1996-08-15T00:00:00-04:00" ShippedDate="1996-07-25T00:00:00-04:00" Freight="3.2500" UnitPrice1="8.0000" Quantity="10" Discount="0"/>
<dt ProductName="Gravad lax" CategoryName="Seafood" UnitsInStock="11" UnitsOnOrder="50" CustomerID="CENTC" OrderID="10259" OrderDate="1996-07-18T00:00:00-04:00" RequiredDate="1996-08-15T00:00:00-04:00" ShippedDate="1996-07-25T00:00:00-04:00" Freight="3.2500" UnitPrice1="20.8000" Quantity="1" Discount="0"/>
<dt ProductName="Jack's New England Clam Chowder" CategoryName="Seafood" UnitsInStock="85" UnitsOnOrder="0" CustomerID="OTTIK" OrderID="10260" OrderDate="1996-07-19T00:00:00-04:00" RequiredDate="1996-08-16T00:00:00-04:00" ShippedDate="1996-07-29T00:00:00-04:00" Freight="55.0900" UnitPrice1="7.7000" Quantity="16" Discount="0.25"/>
<dt ProductName="Ravioli Angelo" CategoryName="Grains/Cereals" UnitsInStock="36" UnitsOnOrder="0" CustomerID="OTTIK" OrderID="10260" OrderDate="1996-07-19T00:00:00-04:00" RequiredDate="1996-08-16T00:00:00-04:00" ShippedDate="1996-07-29T00:00:00-04:00" Freight="55.0900" UnitPrice1="15.6000" Quantity="50" Discount="0"/>
<dt ProductName="Tarte au sucre" CategoryName="Confections" UnitsInStock="17" UnitsOnOrder="0" CustomerID="OTTIK" OrderID="10260" OrderDate="1996-07-19T00:00:00-04:00" RequiredDate="1996-08-16T00:00:00-04:00" ShippedDate="1996-07-29T00:00:00-04:00" Freight="55.0900" UnitPrice1="39.4000" Quantity="15" Discount="0.25"/>
<dt ProductName="Outback Lager" CategoryName="Beverages" UnitsInStock="15" UnitsOnOrder="10" CustomerID="OTTIK" OrderID="10260" OrderDate="1996-07-19T00:00:00-04:00" RequiredDate="1996-08-16T00:00:00-04:00" ShippedDate="1996-07-29T00:00:00-04:00" Freight="55.0900" UnitPrice1="12.0000" Quantity="21" Discount="0.25"/>
<dt ProductName="Sir Rodney's Scones" CategoryName="Confections" UnitsInStock="3" UnitsOnOrder="40" CustomerID="QUEDE" OrderID="10261" OrderDate="1996-07-19T00:00:00-04:00" RequiredDate="1996-08-16T00:00:00-04:00" ShippedDate="1996-07-30T00:00:00-04:00" Freight="3.0500" UnitPrice1="8.0000" Quantity="20" Discount="0"/>
<dt ProductName="Steeleye Stout" CategoryName="Beverages" UnitsInStock="20" UnitsOnOrder="0" CustomerID="QUEDE" OrderID="10261" OrderDate="1996-07-19T00:00:00-04:00" RequiredDate="1996-08-16T00:00:00-04:00" ShippedDate="1996-07-30T00:00:00-04:00" Freight="3.0500" UnitPrice1="14.4000" Quantity="20" Discount="0"/>
<dt ProductName="Chef Anton's Gumbo Mix" CategoryName="Condiments" UnitsInStock="0" UnitsOnOrder="0" CustomerID="RATTC" OrderID="10262" OrderDate="1996-07-22T00:00:00-04:00" RequiredDate="1996-08-19T00:00:00-04:00" ShippedDate="1996-07-25T00:00:00-04:00" Freight="48.2900" UnitPrice1="17.0000" Quantity="12" Discount="0.2"/>
<dt ProductName="Uncle Bob's Organic Dried Pears" CategoryName="Produce" UnitsInStock="15" UnitsOnOrder="0" CustomerID="RATTC" OrderID="10262" OrderDate="1996-07-22T00:00:00-04:00" RequiredDate="1996-08-19T00:00:00-04:00" ShippedDate="1996-07-25T00:00:00-04:00" Freight="48.2900" UnitPrice1="24.0000" Quantity="15" Discount="0"/>
<dt ProductName="Gnocchi di nonna Alice" CategoryName="Grains/Cereals" UnitsInStock="21" UnitsOnOrder="10" CustomerID="RATTC" OrderID="10262" OrderDate="1996-07-22T00:00:00-04:00" RequiredDate="1996-08-19T00:00:00-04:00" ShippedDate="1996-07-25T00:00:00-04:00" Freight="48.2900" UnitPrice1="30.4000" Quantity="2" Discount="0"/>
<dt ProductName="Pavlova" CategoryName="Confections" UnitsInStock="29" UnitsOnOrder="0" CustomerID="ERNSH" OrderID="10263" OrderDate="1996-07-23T00:00:00-04:00" RequiredDate="1996-08-20T00:00:00-04:00" ShippedDate="1996-07-31T00:00:00-04:00" Freight="146.0600" UnitPrice1="13.9000" Quantity="60" Discount="0.25"/>
<dt ProductName="Guaraná Fantástica" CategoryName="Beverages" UnitsInStock="20" UnitsOnOrder="0" CustomerID="ERNSH" OrderID="10263" OrderDate="1996-07-23T00:00:00-04:00" RequiredDate="1996-08-20T00:00:00-04:00" ShippedDate="1996-07-31T00:00:00-04:00" Freight="146.0600" UnitPrice1="3.6000" Quantity="28" Discount="0"/>
<dt ProductName="Nord-Ost Matjeshering" CategoryName="Seafood" UnitsInStock="10" UnitsOnOrder="0" CustomerID="ERNSH" OrderID="10263" OrderDate="1996-07-23T00:00:00-04:00" RequiredDate="1996-08-20T00:00:00-04:00" ShippedDate="1996-07-31T00:00:00-04:00" Freight="146.0600" UnitPrice1="20.7000" Quantity="60" Discount="0.25"/>
<dt ProductName="Longlife Tofu" CategoryName="Produce" UnitsInStock="4" UnitsOnOrder="20" CustomerID="ERNSH" OrderID="10263" OrderDate="1996-07-23T00:00:00-04:00" RequiredDate="1996-08-20T00:00:00-04:00" ShippedDate="1996-07-31T00:00:00-04:00" Freight="146.0600" UnitPrice1="8.0000" Quantity="36" Discount="0.25"/>
<dt ProductName="Chang" CategoryName="Beverages" UnitsInStock="17" UnitsOnOrder="40" CustomerID="FOLKO" OrderID="10264" OrderDate="1996-07-24T00:00:00-04:00" RequiredDate="1996-08-21T00:00:00-04:00" ShippedDate="1996-08-23T00:00:00-04:00" Freight="3.6700" UnitPrice1="15.2000" Quantity="35" Discount="0"/>
<dt ProductName="Jack's New England Clam Chowder" CategoryName="Seafood" UnitsInStock="85" UnitsOnOrder="0" CustomerID="FOLKO" OrderID="10264" OrderDate="1996-07-24T00:00:00-04:00" RequiredDate="1996-08-21T00:00:00-04:00" ShippedDate="1996-08-23T00:00:00-04:00" Freight="3.6700" UnitPrice1="7.7000" Quantity="25" Discount="0.15"/>
<dt ProductName="Alice Mutton" CategoryName="Meat/Poultry" UnitsInStock="0" UnitsOnOrder="0" CustomerID="BLONP" OrderID="10265" OrderDate="1996-07-25T00:00:00-04:00" RequiredDate="1996-08-22T00:00:00-04:00" ShippedDate="1996-08-12T00:00:00-04:00" Freight="55.2800" UnitPrice1="31.2000" Quantity="30" Discount="0"/>
<dt ProductName="Outback Lager" CategoryName="Beverages" UnitsInStock="15" UnitsOnOrder="10" CustomerID="BLONP" OrderID="10265" OrderDate="1996-07-25T00:00:00-04:00" RequiredDate="1996-08-22T00:00:00-04:00" ShippedDate="1996-08-12T00:00:00-04:00" Freight="55.2800" UnitPrice1="12.0000" Quantity="20" Discount="0"/>
<dt ProductName="Queso Manchego La Pastora" CategoryName="Dairy Products" UnitsInStock="86" UnitsOnOrder="0" CustomerID="WARTH" OrderID="10266" OrderDate="1996-07-26T00:00:00-04:00" RequiredDate="1996-09-06T00:00:00-04:00" ShippedDate="1996-07-31T00:00:00-04:00" Freight="25.7300" UnitPrice1="30.4000" Quantity="12" Discount="0.05"/>
<dt ProductName="Boston Crab Meat" CategoryName="Seafood" UnitsInStock="123" UnitsOnOrder="0" CustomerID="FRANK" OrderID="10267" OrderDate="1996-07-29T00:00:00-04:00" RequiredDate="1996-08-26T00:00:00-04:00" ShippedDate="1996-08-06T00:00:00-04:00" Freight="208.5800" UnitPrice1="14.7000" Quantity="50" Discount="0"/>
<dt ProductName="Raclette Courdavault" CategoryName="Dairy Products" UnitsInStock="79" UnitsOnOrder="0" CustomerID="FRANK" OrderID="10267" OrderDate="1996-07-29T00:00:00-04:00" RequiredDate="1996-08-26T00:00:00-04:00" ShippedDate="1996-08-06T00:00:00-04:00" Freight="208.5800" UnitPrice1="44.0000" Quantity="70" Discount="0.15"/>
<dt ProductName="Lakkalikööri" CategoryName="Beverages" UnitsInStock="57" UnitsOnOrder="0" CustomerID="FRANK" OrderID="10267" OrderDate="1996-07-29T00:00:00-04:00" RequiredDate="1996-08-26T00:00:00-04:00" ShippedDate="1996-08-06T00:00:00-04:00" Freight="208.5800" UnitPrice1="14.4000" Quantity="15" Discount="0.15"/>
</rdData>Video Demo: https://watch.screencastify.com/v/1KSXg455qfDQn5CRrwm4
VISUI is here to help with additional solutions.
0
Please sign in to leave a comment.
Comments
1 comment