问:
Read the XML data Nodes in TSQL Query and filter the XML columns data
I Have a TABLE in that one filed have XML data, below I have provided and I need to read this fields and filter the data in SQL QUery, Can someone help to read below select list fields?

XML is:

```<Order
    xmlns:Order="http://www.hp.com/namespaces/iscs/base/ordermanagement/ois/schemas/order_xml"
    UniqueId="" Id="SCEO37600056" Name="" DisplayName=""
    Description="" ShopperId="0c52f72f-d24d-492b-89e8-a8f433b652b1"
    SerializationVersion="1.0.0" SourceCode=""
    CustomerId="SCEU33684387" CustomerEmail="administratie@entis.ai"
    TaxLogic="DRC" DefaultTaxRate="21" OrderEDDMessage="UnKnown"
    QuoteCreatedOn="1901-01-01T00:00:00" OrderKey="SCEO37600056"
    CurrencyCode="EUR" Language="nl"
    CurrentApplication="NLSMBCallCenter" IPAddress=""
    DiscountType="None" CanProcess="false" AccountId="SCEA3258"
    CatalogName="NL Public (CG1926)" Tier1="false"
    ExternalAccountId="" CustomerName="Tineke van Westrenen"
    CompanyName="Default Public Account" SalesRepId="SCEU33285893"
    QuoteId="" AgentId="" AgentLogin="" QuoteCreatedBy=""
    OrderCreatedBy="" QuoteCreatedDate="1901-01-01T00:00:00"
    CommunityId="SCESG23099"
    InternalComments="DYN_BUNDLE_0008162_6B8D6EA_ABH on BC pricePGS Fraud Review\n -- Order removed from RMS Hold - X Minute Services -- Order released - X Minute Services "
    ExternalComments=""
    PSTQSTExemptionCode="" GSTHSTExemptionCode=""
    InvoiceComments="" PurchaseStatus="" PrimaryUse=""
    CatalogId="CG1926" BillingBlock="false"
    ReceivedInvoice="false" BusinessPipeline=""
    CustomerRequestedDeliveryDate="" CustomerRequestedDeliveryTime=""
    BypassAvaialblility="false" BypassAvaialblilityReason=""
    CustomerSegment="Business" ProcessingType="Regular"
    SendSiebel="false" AssociateOpportunity=""
    CheckInventory="true" IsInventoryAvailable="false"
    CountryKey="NL" Region="EMEA" ApplyForRecycleServices=""
    RegisterForInternetServiceProvider="" RequestToIssueReceipt=""
    ReceiveOrderStatusMails="" CanValidatePipeLine="true"
    IsCCRepApproved="false" FulfillmentId="EU_Direct"
    SourceCatalogKey="CAT-1157426" ShouldSettleBill="false"
    IsPriceInclusiveofTax="true" IsFrozenQuote="false"
    ShouldSettlePayPal="false" DiscountAllowanceExceeded="false"
    DiscountAllowanceExceededAmount="0"
    HasDisplayedDiscountExceededMsg="false"
    PriceIncludesRegulatoryFee="false"
    HasMultipleLSPFulfillment="false"
    IsEDDMessageRequested="false" FulfillmentSegment="SMB"
    FulfillmentSubSegment="Public" CustomerApprovalEmail=""
    ClubName="" HasOutOfStockItem="false" ISDRCEligible="true"
    ISDRCApplied="true" Doc_number="0087a107-49b337ac8-7"
    ISVIESRequired="false" OrderWithSavedCardProfile="false"
    Is3DSecure="false" IsValidGeoBlockingSoldtoCountry="false"
    ISGeoBlockingApplied="false" ISGeoBlockingEligible="false"
    GeoBlockingSoldToCountry="NL" OrderMethodType="ZCDO"
    OrderType="Regular" OrderSource="ZISCSCC" Currency=""
    Prefix="" DealDescriptor="NLEURSP" OrderCancelledBy=""
    OrderStatus="Open" OrderDate="2022-11-22T14:48:55">

    <EffectiveStartDate>1901-01-01T00:00:00</EffectiveStartDate>
    <EffectiveEndDate>1901-01-01T00:00:00</EffectiveEndDate>
    <Status>Open</Status>
    <Created UniqueId="" Id="" ActionPerformed="Created" PerformedBy="AUTH\vanVegS" PerformedDate="2022-11-22T13:48:55.2475289+00:00" />
    <LastModified UniqueId="" Id="" ActionPerformed="Modified" PerformedBy="AUTH\vanVegS" PerformedDate="2022-11-22T13:48:58.3725983+00:00" />
    <ExtendedProperties />
    <ExpirationDate>2022-12-22T00:00:00</ExpirationDate>
    <OriginationSource>CallCenter</OriginationSource>
    <SubTotal UniqueId="" Id="" Amount="23137.97" />
    <BasePriceSubTotal UniqueId="" Id="" Amount="23137.8" />
    <Total UniqueId="" Id="" Amount="20874.57" />
    <Errors />
    <LineItems>
        <Item UniqueId="" Id="1" Name="" DisplayName="" Description="HP ZBook Firefly G9 mobiele workstation met NVIDIA® T500" OSSStatus="" GroupId="1" Quantity="10" ActualQty="0" AttachId="0" DynamicBunImageURL="" IsDisplayable="true" Availability="0" ValidatePrice="true" CurrentQty="0" FutureQty="-1" ReservationQty="0" EDD="TBA" FutureUsed="false" IsValid="true" CampaignCode="" TaxLogic="DRC" PriceIncludesRegulatoryFee="false" OID="0" DynamicBundleId="" DynamicBundleName="" DynamicBundleDescription="" Sequence="0" ActualLineItemId="1" IsDynamicBundle="false" DynamicBundleQty="0" IsCouponApplicable="false" ParentSku="" isTaxRateChanged="false" ItemMaxQty="0">
            <EffectiveStartDate>1901-01-01T00:00:00</EffectiveStartDate>
            <EffectiveEndDate>1901-01-01T00:00:00</EffectiveEndDate>
            <Status>Active</Status>
            <ExtendedProperties />
            <Product UniqueId="" Id="P498222" Name="HP ZBook Firefly G9 mobiele workstation met NVIDIA® T500" DisplayName="HP ZBook Firefly G9 mobiele workstation met NVIDIA® T500" Description="HP ZBook Firefly G9 mobiele workstation met NVIDIA® T500" CategoryId="" CategoryName="" OID="" Characteristics="" Sequence="0" PrimaryImage="https://www.hp.com/nl-nl/shop/Html/Merch/Images/c08249910_209x189.jpg" CatalogId="CG1926" ParentCategoryId="" HierarchyDescription="" Hierarchy="" FulfillmentId="EU_Direct" Expressflag="false" ApplicationType="" ConsumesInventory="true" IsProductTangible="true" IsConfigurable="true" CurrentEDD="TBA" FutureEDD="TBA" CurrentInventory="9" FutureInventory="0" ConfigBaseProductPartNumber="" PreferredProduct="false" Family="" ArfFlag="false" IsNonBuyable="false" IsExternal="false" FreeShipping="false" IsProductNew="false" PartNumber="6B8D6EA#ABH" MfgName="" Unspsc="43211503" ProductLine="IK" HTSCode="8471300000" IsAncillary="false" IsSameQtyReq="false" TaxCode="OV" ProductFamily="" ProductSource="" QuickAccessCode="" Qualifier="" IsActive="true" IsVirtual="false" IsSellable="false" IsStandAlone="false" DeliveryGroup="" FulfillmentSource="" CampaignCode="" EclipseId="" TaxRate="0" TaxType="OM" BigDealId="44301913" Quantity="1" WarrantyDesc="" PscLocale="" PscReferringUrl="" PscCrossSellUrl="" PscPartNumber="" LspSku="" LSPFulfillmentId="" OutOfStock="true" LeadTime="365" ETA="261" EDDMessage="ShipIn48Hours" ActualEDDMessage="UnKnown" FreeShippingOrder="false" DFlag="false" SourceCatalogId="" HasPromotions="false" HasDiscounts="false" DynBunId="">
            <EffectiveStartDate>1901-01-01T00:00:00</EffectiveStartDate>
            <EffectiveEndDate>1901-01-01T00:00:00</EffectiveEndDate>
            <Status>Active</Status>
            <ExtendedProperties />
            <AttachId>0</AttachId>
            <CatalogItemType>Product</CatalogItemType>
            <CatalogItems />
            <Specifications />
            <MetadataList>
                <Metadata UniqueId="" Id="" Name="MarketingText" Value="" Sequence="0">
                    <MetadataType>Specification</MetadataType>
                </Metadata>
                <Metadata UniqueId="" Id="" Name="XmlContentText" Value="" Sequence="0">
                    <MetadataType>Specification</MetadataType>
                </Metadata>
            </MetadataList>
            <MetadataGroups />
            <Promotions />
            <Surcharge UniqueId="" Id="" Amount="0" />
            <CopyrightFee UniqueId="" Id="" Amount="0" />
            <ProductType>Bto</ProductType>
            <Discount
                    xmlns:d6p1="http://www.w3.org/2001/XMLSchema-instance" d6p1:type="OperatorDiscount" UniqueId="" Id="" Name="" DisplayName="" Description="" Code="" ApplyToLocation="Unknown" DiscountType="FixedAmount" ReasonCode="Deal price approval" Value="64.64" MinimumApplicableAmount="0" MaximumApplicableAmount="0">
                    <EffectiveStartDate>1901-01-01T00:00:00</EffectiveStartDate>
                    <EffectiveEndDate>1901-01-01T00:00:00</EffectiveEndDate>
                    <ApprovalId />
                </Discount>
            </ProductDiscount>
            <PscSegment>unknown</PscSegment>
            <BaseCatalogPrice UniqueId="" Id="" Amount="2152" />
            <BaseListPrice UniqueId="" Id="" Amount="2152" />
            <ListPrice UniqueId="" Id="" Amount="2603.92" />
            <CatalogFinalPrice UniqueId="" Id="" Amount="2603.92" />
            <PriceType>Unknown</PriceType>
        </Product>
        <ExternalInfo UniqueId="" Id="" Name="" DisplayName="" Description="" ProductColor="" ProductURL="" AccessoryURL="" ImageURL="" ProductLine="" ProductFamily="">
            <EffectiveStartDate>1901-01-01T00:00:00</EffectiveStartDate>
            <EffectiveEndDate>1901-01-01T00:00:00</EffectiveEndDate>
            <Status>Active</Status>
            <ExtendedProperties />
        </ExternalInfo>
        <LineItemDiscountCollection>
            <Discount
                xmlns:d5p1="http://www.w3.org/2001/XMLSchema-instance" d5p1:type="OperatorDiscount" UniqueId="" Id="" Name="" DisplayName="" Description="" Code="" ApplyToLocation="Item" DiscountType="FixedAmount" ReasonCode="Deal price approval" Value="-646.4" MinimumApplicableAmount="0" MaximumApplicableAmount="0">
                <EffectiveStartDate>1901-01-01T00:00:00</EffectiveStartDate>
                <EffectiveEndDate>1901-01-01T00:00:00</EffectiveEndDate>
                <Status>Active</Status>
                <ExtendedProperties />
                <Message />
                <DiscountTaxFactor UniqueId="" Id="" Amount="0" />
                <TypeOfDiscount>Operator</TypeOfDiscount>
                <RequestorSalesRepId />
                <ApproverSalesRepId />
                <ApprovalId />
            </Discount>
        </LineItemDiscountCollection>
        <TaxItems>
            <LineItemTax UniqueId="" Id="0" Message="" Code="OM" Type="Product">
                <TotalAmount UniqueId="" Id="" Amount="0" />
                <SubTaxes>
                    <LineItemTaxLevel UniqueId="" Id="0">
                        <_amount UniqueId="" Id="" Amount="0" />
                        <_level />
                        <_code>OM</_code>
                        <_type>OM</_type>
                        <_message />
                        <_rate>21</_rate>
                        <_certificateNumber />
                    </LineItemTaxLevel>
                </SubTaxes>
            </LineItemTax>
        </TaxItems>
        <IsExclude>false</IsExclude>
        <LineItemApportionedDiscount UniqueId="" Id="" Amount="0" />
        <RefreshedProduct UniqueId="" Id="P498222" Name="HP ZBook Firefly G9 mobiele workstation met NVIDIA® T500" DisplayName="HP ZBook Firefly G9 mobiele workstation met NVIDIA® T500" Description="HP ZBook Firefly G9 mobiele workstation met NVIDIA® T500" CategoryId="" CategoryName="" OID="" Characteristics="" Sequence="0" PrimaryImage="https://www.hp.com/nl-nl/shop/Html/Merch/Images/c08249910_209x189.jpg" CatalogId="CG1926" ParentCategoryId="" HierarchyDescription="" Hierarchy="" FulfillmentId="EU_Direct" Expressflag="false" ApplicationType="" ConsumesInventory="true" IsProductTangible="true" IsConfigurable="true" CurrentEDD="TBA" FutureEDD="TBA" CurrentInventory="9" FutureInventory="0" ConfigBaseProductPartNumber="" PreferredProduct="false" Family="" ArfFlag="false" IsNonBuyable="false" IsExternal="false" FreeShipping="false" IsProductNew="false" PartNumber="6B8D6EA#ABH" MfgName="" Unspsc="43211503" ProductLine="IK" HTSCode="8471300000" IsAncillary="false" IsSameQtyReq="false" TaxCode="OM" ProductFamily="" ProductSource="" QuickAccessCode="" Qualifier="" IsActive="true" IsVirtual="false" IsSellable="false" IsStandAlone="false" DeliveryGroup="" FulfillmentSource="" CampaignCode="" EclipseId="" TaxRate="21" TaxType="OM" BigDealId="44301913" Quantity="1" WarrantyDesc="" PscLocale="" PscReferringUrl="" PscCrossSellUrl="" PscPartNumber="" LspSku="" LSPFulfillmentId="" OutOfStock="false" LeadTime="365" ETA="261" EDDMessage="ShipIn48Hours" ActualEDDMessage="UnKnown" FreeShippingOrder="false" DFlag="false" SourceCatalogId="" HasPromotions="false" HasDiscounts="false" DynBunId="">
            <EffectiveStartDate>1901-01-01T00:00:00</EffectiveStartDate>
            <EffectiveEndDate>1901-01-01T00:00:00</EffectiveEndDate>
            <Status>Active</Status>
            <ExtendedProperties />
            <AttachId>0</AttachId>
            <CatalogItemType>Product</CatalogItemType>
            <CatalogItems />
            <Specifications />
            <MetadataList>
                <Metadata UniqueId="" Id="" Name="MarketingText" Value="" Sequence="0">
                    <MetadataType>Specification</MetadataType>
                </Metadata>
                <Metadata UniqueId="" Id="" Name="XmlContentText" Value="" Sequence="0">
                    <MetadataType>Specification</MetadataType>
                </Metadata>
            </MetadataList>
            <MetadataGroups />
            <Promotions />
            <Surcharge UniqueId="" Id="" Amount="0" />
            <CopyrightFee UniqueId="" Id="" Amount="0" />
            <ProductType>Bto</ProductType>
            <Height Value="0" UnitOfMeasure="Unknown" />
            <Length Value="0" UnitOfMeasure="Unknown" />
            <Width Value="0" UnitOfMeasure="Unknown" />
            <Weight Value="0" UnitOfMeasure="Unknown" />
            <AliasSkus />
            <TaxAmount UniqueId="" Id="" Amount="451.92" />
            <TaxAmountwithQty UniqueId="" Id="" Amount="0" />
            <ProductDiscount />
            <PscSegment>unknown</PscSegment>
            <BaseCatalogPrice UniqueId="" Id="" Amount="2152" />
            <BaseListPrice UniqueId="" Id="" Amount="2152" />
            <ListPrice UniqueId="" Id="" Amount="2603.92" />
            <CatalogFinalPrice UniqueId="" Id="" Amount="2603.92" />
            <PriceType>Unknown</PriceType>
        </RefreshedProduct>
        <SurchargeTaxFactor UniqueId="" Id="" Amount="0" />
        <CopyrightFeeTaxFactor UniqueId="" Id="" Amount="0" />
    </Item>
    </LineItems>
<ValidationErrors />

        <CreditRequestAmount UniqueId="" Id="" Amount="25259" />
        <CVResult />
    </Payment>
</Payments>
<Shipments>
    <Shipment
        xmlns:d3p1="http://www.w3.org/2001/XMLSchema-instance" d3p1:type="LSShipment" UniqueId="" Id="" AddressId="" IsDefault="false" ShippingInstructions="" ThirdPartyTrackingNo="" ShipmentNo="" ActualAdminData="" ActualProductionDate="" AcutalConsolidationDate="" ActualShipDate="" ActualDeliveryDate="" PlannedShipDate="" PlannedDeliveryDate="" OSSStatus="" StatusRefTime="" CarrierCode="LSCarrierCode" IsAssisted="false" ServiceLevelCode="LSServiceLevelCode" ServiceLevelDescCode="SS">
        <LineItems>
            <Id>1</Id>
            <Id>2</Id>
        </LineItems>
        <CarrierList />
        <EnhancedServiceList />
        <EnhancedService />
        <LsSkus>
            <LineItem UniqueId="" Id="1" Name="" DisplayName="" Description="" OSSStatus="" GroupId="" Quantity="1" ActualQty="0" AttachId="0" DynamicBunImageURL="" IsDisplayable="true" Availability="0" ValidatePrice="true" CurrentQty="0" FutureQty="0" ReservationQty="0" FutureUsed="false" IsValid="true" CampaignCode="" TaxLogic="Default" PriceIncludesRegulatoryFee="false" OID="0" DynamicBundleId="" DynamicBundleName="" DynamicBundleDescription="" Sequence="0" ActualLineItemId="" IsDynamicBundle="false" DynamicBundleQty="0" IsCouponApplicable="false" ParentSku="" isTaxRateChanged="false" ItemMaxQty="0">
                <DiscountCollection />
                <TaxItems />
                <IsExclude>false</IsExclude>
                <LineItemApportionedDiscount UniqueId="" Id="" Amount="0" />
                <SurchargeTaxFactor UniqueId="" Id="" Amount="0" />
                <CopyrightFeeTaxFactor UniqueId="" Id="" Amount="0" />
            </LineItem>
        </LsSkus>
    </Shipment>
</Shipments>
<Discounts />
<TaxItems>
    <LineItemTax UniqueId="" Id="0" Message="" Code="OM" Type="Product">
        <TotalAmount UniqueId="" Id="" Amount="0" />
        <SubTaxes>
        </SubTaxes>
    </LineItemTax>
    <LineItemTax UniqueId="" Id="1" Message="" Code="OM" Type="Product">
        <TotalAmount UniqueId="" Id="" Amount="0.2" />
        <SubTaxes>
                        </SubTaxes>
    </LineItemTax>
</TaxItems>
    <Compensations />
<SendSiebelTime>1901-01-01T00:00:00</SendSiebelTime>
<AssociateOpportunityTime>1901-01-01T00:00:00</AssociateOpportunityTime>
    </Addresses>
    <PhoneNumbers />
    <EmailAddresses>
        <Email UniqueId="" Id="SCEUE33685069" Address="administratie@entis.ai" IsDefault="false">
            <Locale>Work</Locale>
            <Status>Active</Status>
        </Email>
    </EmailAddresses>
    <ExternalKey>p1mfrp6tt34bsmpbpu9cgn4yduj61x5x</ExternalKey>
    <UserGuid>05FB4EDB-8CB3-4224-BB49-39628D21C6BF</UserGuid>
    <Type>External</Type>
    <RegistrationDate>2022-10-28T12:32:56</RegistrationDate>
    <PasswordExpirationDate>1901-01-01T00:00:00</PasswordExpirationDate>
    <SecurityQuestion1 />
    <SecurityAnswer1 />
    <SecurityQuestion2 />
    <SecurityAnswer2 />
    <SiebelContactID />
    <LastSiebelUpdatedDate>1901-01-01T00:00:00</LastSiebelUpdatedDate>
</CreatedFor>
<CreatedBy UniqueId="" Id="SCEU33285893" Name="AUTH\vanVegS" DisplayName="" Description="" FirstName="serge" MiddleInitial="" LastName="vegten" LastName2="" Salutation="" Language="nl" Notes="" UserTypeCode="" UserType="0" UserName="AUTH\vanVegS" PasswordHash="" Password="" UserSecuritySalt="" SecurityQuestion="" SecurityAnswer="" PrimaryAccountId="" Country="NL" PhoneticLastName="" PhoneticFirstName="" Gender="Unknown" DateOfBirth="1901-01-01T00:00:00" Occupation="" BusinessFunction="" PromoEmailConsent="" AdminEmailConsent="" FaxConsent="" Department="" CustomerSegment="Business" CompanyName="" CustomerSubSegment="Public" IsFarmingAccount="false">
    <EffectiveStartDate>1901-01-01T00:00:00</EffectiveStartDate>
    <EffectiveEndDate>1901-01-01T00:00:00</EffectiveEndDate>
    <Status>Active</Status>
    <Created UniqueId="" Id="" ActionPerformed="created" PerformedBy="AUTH\canovasl" PerformedDate="2020-11-16T16:40:41" ItemSource="CallCenter" />
    <LastModified UniqueId="" Id="" ActionPerformed="modified" PerformedBy="AUTH\vanVegS" PerformedDate="2022-11-22T13:47:04.0639606+00:00" ItemSource="CallCenter" />
    <ExtendedProperties />
    <Addresses>
        <Address UniqueId="" Id="SCEUA35660872" Name="" DisplayName="" Description="" AddressName="" CustomerTitle="" SalutationKey="" FirstName="" Area="" TaxId="" AlternateShippingContact="" MiddleInitial="" LastName="" CompanyName="" Line1="" Line2="" Line3="" City="" Region="" PostalCode="" Country="NL" IsDefault="false" LastName2="" AddressAssociationType="User" Locale="Unknown" CRSID="" DepartmentName="" PhoneticCompanyName="" PhoneticFirstName="" PhoneticLastName="" Email="" CYSISID="" StateName="" CRSStatusCode="RequestNotCalled" CRSErrorCode="" AVRStatusCode="SE00000800" AVRErrorCode="" IsVerified="false">
            <EffectiveStartDate>1901-01-01T00:00:00</EffectiveStartDate>
            <EffectiveEndDate>1901-01-01T00:00:00</EffectiveEndDate>
            <Status>Active</Status>
            <ExtendedProperties />
            <AddressType>Billing</AddressType>
            <CompanyPresident />
            </Address>
        </Addresses>
    <PhoneNumbers />
    <EmailAddresses>
        <Email UniqueId="" Id="SCEUE33286377" Address="serge.van.vegten@hp.com" IsDefault="false">
            <Locale>Work</Locale>
            <Status>Active</Status>
        </Email>
    </EmailAddresses>
    <ExternalKey>U</ExternalKey>
    <UserGuid>0DFFDA3D-B811-4381-8E81-DAFF3349CEC9</UserGuid>
    <Type>Internal</Type>
    <RegistrationDate>2020-11-16T16:40:41</RegistrationDate>
    <PasswordExpirationDate>1901-01-01T00:00:00</PasswordExpirationDate>
    <SecurityQuestion1 />
    <SecurityAnswer1 />
    <SecurityQuestion2 />
    <SecurityAnswer2 />
    <SiebelContactID />
    <LastSiebelUpdatedDate>1901-01-01T00:00:00</LastSiebelUpdatedDate>
</CreatedBy>
<UpdatedBy UniqueId="" Id="" Name="" DisplayName="" Description="" FirstName="" MiddleInitial="" LastName="" LastName2="" Salutation="" Language="" Notes="" UserTypeCode="" UserType="0" UserName="" PasswordHash="" Password="" UserSecuritySalt="" SecurityQuestion="" SecurityAnswer="" PrimaryAccountId="" Country="" PhoneticLastName="" PhoneticFirstName="" Gender="Unknown" DateOfBirth="1901-01-01T00:00:00" Occupation="" BusinessFunction="" Department="" CustomerSegment="Consumer" CompanyName="" CustomerSubSegment="Public" IsFarmingAccount="false">
    <EffectiveStartDate>1901-01-01T00:00:00</EffectiveStartDate>
    <EffectiveEndDate>1901-01-01T00:00:00</EffectiveEndDate>
    <Status>Active</Status>
    <ExtendedProperties />
    <Addresses />
    <PhoneNumbers />
    <EmailAddresses />
    <ExternalKey />
    <UserGuid />
    <Type>Unknown</Type>
    <RegistrationDate>1901-01-01T00:00:00</RegistrationDate>
    <PasswordExpirationDate>1901-01-01T00:00:00</PasswordExpirationDate>
    <LastSiebelUpdatedDate>1901-01-01T00:00:00</LastSiebelUpdatedDate>
</UpdatedBy>
    <PreferredShipDate>1901-01-01T00:00:00</PreferredShipDate>
<QuoteIds>
    <Id />
</QuoteIds>
```

```SELECT X.Y.value('ProductType[1]','VARCHAR(20)') AS ProductType, X.Y.value('ISDRCEligible[1]','VARCHAR(20)') AS ISDRCEligible,
X.Y.value('ISDRCApplied[1]','VARCHAR(20)') AS ISDRCApplied,
X.Y.value('type[1]','NVARCHAR(20)') AS type,
X.Y.value('IsAncillary[1]','VARCHAR(20)') AS  IsAncillary,X.Y.value('IsSameQtyReq[1]','VARCHAR(20)') AS IsSameQtyReq,X.Y.value('TaxCode[1]','VARCHAR(20)') AS TaxCode,
X.Y.value('Country[1]','VARCHAR(20)') AS Country
FROM (
SELECT top 100000 CAST(SerializedOrder AS XML) as SerializedOrder
FROM TransactionOrder WITH(NOLOCK))a
CROSS APPLY a.SerializedOrder.nodes('Order/LineItems/Item') AS X(Y)
WHERE X.Y.value('ProductType[1]','VARCHAR(20)')='Bto' AND X.Y.value('ISDRCEligible[1]','VARCHAR(20)')='true' AND
X.Y.value('ISDRCApplied[1]','VARCHAR(20)')='true' AND --X.Y.value('type[1]','NVARCHAR(20)')='CarePack' AND
X.Y.value('IsAncillary[1]','VARCHAR(20)')='true' AND X.Y.value('IsSameQtyReq[1]','VARCHAR(20)')='true' AND
X.Y.value('TaxCode[1]','VARCHAR(20)')='OM' AND X.Y.value('Country[1]','VARCHAR(20)')='NL'
```

Body:
I Have a TABLE in that one filed have XML data, below I have provided and I need to read this fields and filter the data in SQL QUery, Can someone help to read below select list fields?

XML is:

<Order
    xmlns:Order="http://www.hp.com/namespaces/iscs/base/ordermanagement/ois/schemas/order_xml"
    UniqueId="" Id="SCEO37600056" Name="" DisplayName=""
    Description="" ShopperId="0c52f72f-d24d-492b-89e8-a8f433b652b1"
    SerializationVersion="1.0.0" SourceCode=""
    CustomerId="SCEU33684387" CustomerEmail="administratie@entis.ai"
    TaxLogic="DRC" DefaultTaxRate="21" OrderEDDMessage="UnKnown"
    QuoteCreatedOn="1901-01-01T00:00:00" OrderKey="SCEO37600056"
    CurrencyCode="EUR" Language="nl"
    CurrentApplication="NLSMBCallCenter" IPAddress=""
    DiscountType="None" CanProcess="false" AccountId="SCEA3258"
    CatalogName="NL Public (CG1926)" Tier1="false"
    ExternalAccountId="" CustomerName="Tineke van Westrenen"
    CompanyName="Default Public Account" SalesRepId="SCEU33285893"
    QuoteId="" AgentId="" AgentLogin="" QuoteCreatedBy=""
    OrderCreatedBy="" QuoteCreatedDate="1901-01-01T00:00:00"
    CommunityId="SCESG23099"
    InternalComments="DYN_BUNDLE_0008162_6B8D6EA_ABH on BC pricePGS Fraud Review
 -- Order removed from RMS Hold - X Minute Services -- Order released - X Minute Services "
    ExternalComments=""
    PSTQSTExemptionCode="" GSTHSTExemptionCode=""
    InvoiceComments="" PurchaseStatus="" PrimaryUse=""
    CatalogId="CG1926" BillingBlock="false"
    ReceivedInvoice="false" BusinessPipeline=""
    CustomerRequestedDeliveryDate="" CustomerRequestedDeliveryTime=""
    BypassAvaialblility="false" BypassAvaialblilityReason=""
    CustomerSegment="Business" ProcessingType="Regular"
    SendSiebel="false" AssociateOpportunity=""
    CheckInventory="true" IsInventoryAvailable="false"
    CountryKey="NL" Region="EMEA" ApplyForRecycleServices=""
    RegisterForInternetServiceProvider="" RequestToIssueReceipt=""
    ReceiveOrderStatusMails="" CanValidatePipeLine="true"
    IsCCRepApproved="false" FulfillmentId="EU_Direct"
    SourceCatalogKey="CAT-1157426" ShouldSettleBill="false"
    IsPriceInclusiveofTax="true" IsFrozenQuote="false"
    ShouldSettlePayPal="false" DiscountAllowanceExceeded="false"
    DiscountAllowanceExceededAmount="0"
    HasDisplayedDiscountExceededMsg="false"
    PriceIncludesRegulatoryFee="false"
    HasMultipleLSPFulfillment="false"
    IsEDDMessageRequested="false" FulfillmentSegment="SMB"
    FulfillmentSubSegment="Public" CustomerApprovalEmail=""
    ClubName="" HasOutOfStockItem="false" ISDRCEligible="true"
    ISDRCApplied="true" Doc_number="0087a107-49b337ac8-7"
    ISVIESRequired="false" OrderWithSavedCardProfile="false"
    Is3DSecure="false" IsValidGeoBlockingSoldtoCountry="false"
    ISGeoBlockingApplied="false" ISGeoBlockingEligible="false"
    GeoBlockingSoldToCountry="NL" OrderMethodType="ZCDO"
    OrderType="Regular" OrderSource="ZISCSCC" Currency=""
    Prefix="" DealDescriptor="NLEURSP" OrderCancelledBy=""
    OrderStatus="Open" OrderDate="2022-11-22T14:48:55">

    <EffectiveStartDate>1901-01-01T00:00:00</EffectiveStartDate>
    <EffectiveEndDate>1901-01-01T00:00:00</EffectiveEndDate>
    <Status>Open</Status>
    <Created UniqueId="" Id="" ActionPerformed="Created" PerformedBy="AUTH\vanVegS" PerformedDate="2022-11-22T13:48:55.2475289+00:00" />
    <LastModified UniqueId="" Id="" ActionPerformed="Modified" PerformedBy="AUTH\vanVegS" PerformedDate="2022-11-22T13:48:58.3725983+00:00" />
    <ExtendedProperties />
    <ExpirationDate>2022-12-22T00:00:00</ExpirationDate>
    <OriginationSource>CallCenter</OriginationSource>
    <SubTotal UniqueId="" Id="" Amount="23137.97" />
    <BasePriceSubTotal UniqueId="" Id="" Amount="23137.8" />
    <Total UniqueId="" Id="" Amount="20874.57" />
    <Errors />
    <LineItems>
        <Item UniqueId="" Id="1" Name="" DisplayName="" Description="HP ZBook Firefly G9 mobiele workstation met NVIDIA® T500" OSSStatus="" GroupId="1" Quantity="10" ActualQty="0" AttachId="0" DynamicBunImageURL="" IsDisplayable="true" Availability="0" ValidatePrice="true" CurrentQty="0" FutureQty="-1" ReservationQty="0" EDD="TBA" FutureUsed="false" IsValid="true" CampaignCode="" TaxLogic="DRC" PriceIncludesRegulatoryFee="false" OID="0" DynamicBundleId="" DynamicBundleName="" DynamicBundleDescription="" Sequence="0" ActualLineItemId="1" IsDynamicBundle="false" DynamicBundleQty="0" IsCouponApplicable="false" ParentSku="" isTaxRateChanged="false" ItemMaxQty="0">
            <EffectiveStartDate>1901-01-01T00:00:00</EffectiveStartDate>
            <EffectiveEndDate>1901-01-01T00:00:00</EffectiveEndDate>
            <Status>Active</Status>
            <ExtendedProperties />
            <Product UniqueId="" Id="P498222" Name="HP ZBook Firefly G9 mobiele workstation met NVIDIA® T500" DisplayName="HP ZBook Firefly G9 mobiele workstation met NVIDIA® T500" Description="HP ZBook Firefly G9 mobiele workstation met NVIDIA® T500" CategoryId="" CategoryName="" OID="" Characteristics="" Sequence="0" PrimaryImage="https://www.hp.com/nl-nl/shop/Html/Merch/Images/c08249910_209x189.jpg" CatalogId="CG1926" ParentCategoryId="" HierarchyDescription="" Hierarchy="" FulfillmentId="EU_Direct" Expressflag="false" ApplicationType="" ConsumesInventory="true" IsProductTangible="true" IsConfigurable="true" CurrentEDD="TBA" FutureEDD="TBA" CurrentInventory="9" FutureInventory="0" ConfigBaseProductPartNumber="" PreferredProduct="false" Family="" ArfFlag="false" IsNonBuyable="false" IsExternal="false" FreeShipping="false" IsProductNew="false" PartNumber="6B8D6EA#ABH" MfgName="" Unspsc="43211503" ProductLine="IK" HTSCode="8471300000" IsAncillary="false" IsSameQtyReq="false" TaxCode="OV" ProductFamily="" ProductSource="" QuickAccessCode="" Qualifier="" IsActive="true" IsVirtual="false" IsSellable="false" IsStandAlone="false" DeliveryGroup="" FulfillmentSource="" CampaignCode="" EclipseId="" TaxRate="0" TaxType="OM" BigDealId="44301913" Quantity="1" WarrantyDesc="" PscLocale="" PscReferringUrl="" PscCrossSellUrl="" PscPartNumber="" LspSku="" LSPFulfillmentId="" OutOfStock="true" LeadTime="365" ETA="261" EDDMessage="ShipIn48Hours" ActualEDDMessage="UnKnown" FreeShippingOrder="false" DFlag="false" SourceCatalogId="" HasPromotions="false" HasDiscounts="false" DynBunId="">
            <EffectiveStartDate>1901-01-01T00:00:00</EffectiveStartDate>
            <EffectiveEndDate>1901-01-01T00:00:00</EffectiveEndDate>
            <Status>Active</Status>
            <ExtendedProperties />
            <AttachId>0</AttachId>
            <CatalogItemType>Product</CatalogItemType>
            <CatalogItems />
            <Specifications />
            <MetadataList>
                <Metadata UniqueId="" Id="" Name="MarketingText" Value="" Sequence="0">
                    <MetadataType>Specification</MetadataType>
                </Metadata>
                <Metadata UniqueId="" Id="" Name="XmlContentText" Value="" Sequence="0">
                    <MetadataType>Specification</MetadataType>
                </Metadata>
            </MetadataList>
            <MetadataGroups />
            <Promotions />
            <Surcharge UniqueId="" Id="" Amount="0" />
            <CopyrightFee UniqueId="" Id="" Amount="0" />
            <ProductType>Bto</ProductType>
            <Discount
                    xmlns:d6p1="http://www.w3.org/2001/XMLSchema-instance" d6p1:type="OperatorDiscount" UniqueId="" Id="" Name="" DisplayName="" Description="" Code="" ApplyToLocation="Unknown" DiscountType="FixedAmount" ReasonCode="Deal price approval" Value="64.64" MinimumApplicableAmount="0" MaximumApplicableAmount="0">
                    <EffectiveStartDate>1901-01-01T00:00:00</EffectiveStartDate>
                    <EffectiveEndDate>1901-01-01T00:00:00</EffectiveEndDate>
                    <ApprovalId />
                </Discount>
            </ProductDiscount>
            <PscSegment>unknown</PscSegment>
            <BaseCatalogPrice UniqueId="" Id="" Amount="2152" />
            <BaseListPrice UniqueId="" Id="" Amount="2152" />
            <ListPrice UniqueId="" Id="" Amount="2603.92" />
            <CatalogFinalPrice UniqueId="" Id="" Amount="2603.92" />
            <PriceType>Unknown</PriceType>
        </Product>
        <ExternalInfo UniqueId="" Id="" Name="" DisplayName="" Description="" ProductColor="" ProductURL="" AccessoryURL="" ImageURL="" ProductLine="" ProductFamily="">
            <EffectiveStartDate>1901-01-01T00:00:00</EffectiveStartDate>
            <EffectiveEndDate>1901-01-01T00:00:00</EffectiveEndDate>
            <Status>Active</Status>
            <ExtendedProperties />
        </ExternalInfo>
        <LineItemDiscountCollection>
            <Discount
                xmlns:d5p1="http://www.w3.org/2001/XMLSchema-instance" d5p1:type="OperatorDiscount" UniqueId="" Id="" Name="" DisplayName="" Description="" Code="" ApplyToLocation="Item" DiscountType="FixedAmount" ReasonCode="Deal price approval" Value="-646.4" MinimumApplicableAmount="0" MaximumApplicableAmount="0">
                <EffectiveStartDate>1901-01-01T00:00:00</EffectiveStartDate>
                <EffectiveEndDate>1901-01-01T00:00:00</EffectiveEndDate>
                <Status>Active</Status>
                <ExtendedProperties />
                <Message />
                <DiscountTaxFactor UniqueId="" Id="" Amount="0" />
                <TypeOfDiscount>Operator</TypeOfDiscount>
                <RequestorSalesRepId />
                <ApproverSalesRepId />
                <ApprovalId />
            </Discount>
        </LineItemDiscountCollection>
        <TaxItems>
            <LineItemTax UniqueId="" Id="0" Message="" Code="OM" Type="Product">
                <TotalAmount UniqueId="" Id="" Amount="0" />
                <SubTaxes>
                    <LineItemTaxLevel UniqueId="" Id="0">
                        <_amount UniqueId="" Id="" Amount="0" />
                        <_level />
                        <_code>OM</_code>
                        <_type>OM</_type>
                        <_message />
                        <_rate>21</_rate>
                        <_certificateNumber />
                    </LineItemTaxLevel>
                </SubTaxes>
            </LineItemTax>
        </TaxItems>
        <IsExclude>false</IsExclude>
        <LineItemApportionedDiscount UniqueId="" Id="" Amount="0" />
        <RefreshedProduct UniqueId="" Id="P498222" Name="HP ZBook Firefly G9 mobiele workstation met NVIDIA® T500" DisplayName="HP ZBook Firefly G9 mobiele workstation met NVIDIA® T500" Description="HP ZBook Firefly G9 mobiele workstation met NVIDIA® T500" CategoryId="" CategoryName="" OID="" Characteristics="" Sequence="0" PrimaryImage="https://www.hp.com/nl-nl/shop/Html/Merch/Images/c08249910_209x189.jpg" CatalogId="CG1926" ParentCategoryId="" HierarchyDescription="" Hierarchy="" FulfillmentId="EU_Direct" Expressflag="false" ApplicationType="" ConsumesInventory="true" IsProductTangible="true" IsConfigurable="true" CurrentEDD="TBA" FutureEDD="TBA" CurrentInventory="9" FutureInventory="0" ConfigBaseProductPartNumber="" PreferredProduct="false" Family="" ArfFlag="false" IsNonBuyable="false" IsExternal="false" FreeShipping="false" IsProductNew="false" PartNumber="6B8D6EA#ABH" MfgName="" Unspsc="43211503" ProductLine="IK" HTSCode="8471300000" IsAncillary="false" IsSameQtyReq="false" TaxCode="OM" ProductFamily="" ProductSource="" QuickAccessCode="" Qualifier="" IsActive="true" IsVirtual="false" IsSellable="false" IsStandAlone="false" DeliveryGroup="" FulfillmentSource="" CampaignCode="" EclipseId="" TaxRate="21" TaxType="OM" BigDealId="44301913" Quantity="1" WarrantyDesc="" PscLocale="" PscReferringUrl="" PscCrossSellUrl="" PscPartNumber="" LspSku="" LSPFulfillmentId="" OutOfStock="false" LeadTime="365" ETA="261" EDDMessage="ShipIn48Hours" ActualEDDMessage="UnKnown" FreeShippingOrder="false" DFlag="false" SourceCatalogId="" HasPromotions="false" HasDiscounts="false" DynBunId="">
            <EffectiveStartDate>1901-01-01T00:00:00</EffectiveStartDate>
            <EffectiveEndDate>1901-01-01T00:00:00</EffectiveEndDate>
            <Status>Active</Status>
            <ExtendedProperties />
            <AttachId>0</AttachId>
            <CatalogItemType>Product</CatalogItemType>
            <CatalogItems />
            <Specifications />
            <MetadataList>
                <Metadata UniqueId="" Id="" Name="MarketingText" Value="" Sequence="0">
                    <MetadataType>Specification</MetadataType>
                </Metadata>
                <Metadata UniqueId="" Id="" Name="XmlContentText" Value="" Sequence="0">
                    <MetadataType>Specification</MetadataType>
                </Metadata>
            </MetadataList>
            <MetadataGroups />
            <Promotions />
            <Surcharge UniqueId="" Id="" Amount="0" />
            <CopyrightFee UniqueId="" Id="" Amount="0" />
            <ProductType>Bto</ProductType>
            <Height Value="0" UnitOfMeasure="Unknown" />
            <Length Value="0" UnitOfMeasure="Unknown" />
            <Width Value="0" UnitOfMeasure="Unknown" />
            <Weight Value="0" UnitOfMeasure="Unknown" />
            <AliasSkus />
            <TaxAmount UniqueId="" Id="" Amount="451.92" />
            <TaxAmountwithQty UniqueId="" Id="" Amount="0" />
            <ProductDiscount />
            <PscSegment>unknown</PscSegment>
            <BaseCatalogPrice UniqueId="" Id="" Amount="2152" />
            <BaseListPrice UniqueId="" Id="" Amount="2152" />
            <ListPrice UniqueId="" Id="" Amount="2603.92" />
            <CatalogFinalPrice UniqueId="" Id="" Amount="2603.92" />
            <PriceType>Unknown</PriceType>
        </RefreshedProduct>
        <SurchargeTaxFactor UniqueId="" Id="" Amount="0" />
        <CopyrightFeeTaxFactor UniqueId="" Id="" Amount="0" />
    </Item>
    </LineItems>
<ValidationErrors />

        <CreditRequestAmount UniqueId="" Id="" Amount="25259" />
        <CVResult />
    </Payment>
</Payments>
<Shipments>
    <Shipment
        xmlns:d3p1="http://www.w3.org/2001/XMLSchema-instance" d3p1:type="LSShipment" UniqueId="" Id="" AddressId="" IsDefault="false" ShippingInstructions="" ThirdPartyTrackingNo="" ShipmentNo="" ActualAdminData="" ActualProductionDate="" AcutalConsolidationDate="" ActualShipDate="" ActualDeliveryDate="" PlannedShipDate="" PlannedDeliveryDate="" OSSStatus="" StatusRefTime="" CarrierCode="LSCarrierCode" IsAssisted="false" ServiceLevelCode="LSServiceLevelCode" ServiceLevelDescCode="SS">
        <LineItems>
            <Id>1</Id>
            <Id>2</Id>
        </LineItems>
        <CarrierList />
        <EnhancedServiceList />
        <EnhancedService />
        <LsSkus>
            <LineItem UniqueId="" Id="1" Name="" DisplayName="" Description="" OSSStatus="" GroupId="" Quantity="1" ActualQty="0" AttachId="0" DynamicBunImageURL="" IsDisplayable="true" Availability="0" ValidatePrice="true" CurrentQty="0" FutureQty="0" ReservationQty="0" FutureUsed="false" IsValid="true" CampaignCode="" TaxLogic="Default" PriceIncludesRegulatoryFee="false" OID="0" DynamicBundleId="" DynamicBundleName="" DynamicBundleDescription="" Sequence="0" ActualLineItemId="" IsDynamicBundle="false" DynamicBundleQty="0" IsCouponApplicable="false" ParentSku="" isTaxRateChanged="false" ItemMaxQty="0">
                <DiscountCollection />
                <TaxItems />
                <IsExclude>false</IsExclude>
                <LineItemApportionedDiscount UniqueId="" Id="" Amount="0" />
                <SurchargeTaxFactor UniqueId="" Id="" Amount="0" />
                <CopyrightFeeTaxFactor UniqueId="" Id="" Amount="0" />
            </LineItem>
        </LsSkus>
    </Shipment>
</Shipments>
<Discounts />
<TaxItems>
    <LineItemTax UniqueId="" Id="0" Message="" Code="OM" Type="Product">
        <TotalAmount UniqueId="" Id="" Amount="0" />
        <SubTaxes>
        </SubTaxes>
    </LineItemTax>
    <LineItemTax UniqueId="" Id="1" Message="" Code="OM" Type="Product">
        <TotalAmount UniqueId="" Id="" Amount="0.2" />
        <SubTaxes>
                        </SubTaxes>
    </LineItemTax>
</TaxItems>
    <Compensations />
<SendSiebelTime>1901-01-01T00:00:00</SendSiebelTime>
<AssociateOpportunityTime>1901-01-01T00:00:00</AssociateOpportunityTime>
    </Addresses>
    <PhoneNumbers />
    <EmailAddresses>
        <Email UniqueId="" Id="SCEUE33685069" Address="administratie@entis.ai" IsDefault="false">
            <Locale>Work</Locale>
            <Status>Active</Status>
        </Email>
    </EmailAddresses>
    <ExternalKey>p1mfrp6tt34bsmpbpu9cgn4yduj61x5x</ExternalKey>
    <UserGuid>05FB4EDB-8CB3-4224-BB49-39628D21C6BF</UserGuid>
    <Type>External</Type>
    <RegistrationDate>2022-10-28T12:32:56</RegistrationDate>
    <PasswordExpirationDate>1901-01-01T00:00:00</PasswordExpirationDate>
    <SecurityQuestion1 />
    <SecurityAnswer1 />
    <SecurityQuestion2 />
    <SecurityAnswer2 />
    <SiebelContactID />
    <LastSiebelUpdatedDate>1901-01-01T00:00:00</LastSiebelUpdatedDate>
</CreatedFor>
<CreatedBy UniqueId="" Id="SCEU33285893" Name="AUTH\vanVegS" DisplayName="" Description="" FirstName="serge" MiddleInitial="" LastName="vegten" LastName2="" Salutation="" Language="nl" Notes="" UserTypeCode="" UserType="0" UserName="AUTH\vanVegS" PasswordHash="" Password="" UserSecuritySalt="" SecurityQuestion="" SecurityAnswer="" PrimaryAccountId="" Country="NL" PhoneticLastName="" PhoneticFirstName="" Gender="Unknown" DateOfBirth="1901-01-01T00:00:00" Occupation="" BusinessFunction="" PromoEmailConsent="" AdminEmailConsent="" FaxConsent="" Department="" CustomerSegment="Business" CompanyName="" CustomerSubSegment="Public" IsFarmingAccount="false">
    <EffectiveStartDate>1901-01-01T00:00:00</EffectiveStartDate>
    <EffectiveEndDate>1901-01-01T00:00:00</EffectiveEndDate>
    <Status>Active</Status>
    <Created UniqueId="" Id="" ActionPerformed="created" PerformedBy="AUTH\canovasl" PerformedDate="2020-11-16T16:40:41" ItemSource="CallCenter" />
    <LastModified UniqueId="" Id="" ActionPerformed="modified" PerformedBy="AUTH\vanVegS" PerformedDate="2022-11-22T13:47:04.0639606+00:00" ItemSource="CallCenter" />
    <ExtendedProperties />
    <Addresses>
        <Address UniqueId="" Id="SCEUA35660872" Name="" DisplayName="" Description="" AddressName="" CustomerTitle="" SalutationKey="" FirstName="" Area="" TaxId="" AlternateShippingContact="" MiddleInitial="" LastName="" CompanyName="" Line1="" Line2="" Line3="" City="" Region="" PostalCode="" Country="NL" IsDefault="false" LastName2="" AddressAssociationType="User" Locale="Unknown" CRSID="" DepartmentName="" PhoneticCompanyName="" PhoneticFirstName="" PhoneticLastName="" Email="" CYSISID="" StateName="" CRSStatusCode="RequestNotCalled" CRSErrorCode="" AVRStatusCode="SE00000800" AVRErrorCode="" IsVerified="false">
            <EffectiveStartDate>1901-01-01T00:00:00</EffectiveStartDate>
            <EffectiveEndDate>1901-01-01T00:00:00</EffectiveEndDate>
            <Status>Active</Status>
            <ExtendedProperties />
            <AddressType>Billing</AddressType>
            <CompanyPresident />
            </Address>
        </Addresses>
    <PhoneNumbers />
    <EmailAddresses>
        <Email UniqueId="" Id="SCEUE33286377" Address="serge.van.vegten@hp.com" IsDefault="false">
            <Locale>Work</Locale>
            <Status>Active</Status>
        </Email>
    </EmailAddresses>
    <ExternalKey>U</ExternalKey>
    <UserGuid>0DFFDA3D-B811-4381-8E81-DAFF3349CEC9</UserGuid>
    <Type>Internal</Type>
    <RegistrationDate>2020-11-16T16:40:41</RegistrationDate>
    <PasswordExpirationDate>1901-01-01T00:00:00</PasswordExpirationDate>
    <SecurityQuestion1 />
    <SecurityAnswer1 />
    <SecurityQuestion2 />
    <SecurityAnswer2 />
    <SiebelContactID />
    <LastSiebelUpdatedDate>1901-01-01T00:00:00</LastSiebelUpdatedDate>
</CreatedBy>
<UpdatedBy UniqueId="" Id="" Name="" DisplayName="" Description="" FirstName="" MiddleInitial="" LastName="" LastName2="" Salutation="" Language="" Notes="" UserTypeCode="" UserType="0" UserName="" PasswordHash="" Password="" UserSecuritySalt="" SecurityQuestion="" SecurityAnswer="" PrimaryAccountId="" Country="" PhoneticLastName="" PhoneticFirstName="" Gender="Unknown" DateOfBirth="1901-01-01T00:00:00" Occupation="" BusinessFunction="" Department="" CustomerSegment="Consumer" CompanyName="" CustomerSubSegment="Public" IsFarmingAccount="false">
    <EffectiveStartDate>1901-01-01T00:00:00</EffectiveStartDate>
    <EffectiveEndDate>1901-01-01T00:00:00</EffectiveEndDate>
    <Status>Active</Status>
    <ExtendedProperties />
    <Addresses />
    <PhoneNumbers />
    <EmailAddresses />
    <ExternalKey />
    <UserGuid />
    <Type>Unknown</Type>
    <RegistrationDate>1901-01-01T00:00:00</RegistrationDate>
    <PasswordExpirationDate>1901-01-01T00:00:00</PasswordExpirationDate>
    <LastSiebelUpdatedDate>1901-01-01T00:00:00</LastSiebelUpdatedDate>
</UpdatedBy>
    <PreferredShipDate>1901-01-01T00:00:00</PreferredShipDate>
<QuoteIds>
    <Id />
</QuoteIds>

SELECT X.Y.value('ProductType[1]','VARCHAR(20)') AS ProductType, X.Y.value('ISDRCEligible[1]','VARCHAR(20)') AS ISDRCEligible,
X.Y.value('ISDRCApplied[1]','VARCHAR(20)') AS ISDRCApplied,
X.Y.value('type[1]','NVARCHAR(20)') AS type,
X.Y.value('IsAncillary[1]','VARCHAR(20)') AS  IsAncillary,X.Y.value('IsSameQtyReq[1]','VARCHAR(20)') AS IsSameQtyReq,X.Y.value('TaxCode[1]','VARCHAR(20)') AS TaxCode,
X.Y.value('Country[1]','VARCHAR(20)') AS Country
FROM (
SELECT top 100000 CAST(SerializedOrder AS XML) as SerializedOrder
FROM TransactionOrder WITH(NOLOCK))a
CROSS APPLY a.SerializedOrder.nodes('Order/LineItems/Item') AS X(Y)
WHERE X.Y.value('ProductType[1]','VARCHAR(20)')='Bto' AND X.Y.value('ISDRCEligible[1]','VARCHAR(20)')='true' AND
X.Y.value('ISDRCApplied[1]','VARCHAR(20)')='true' AND --X.Y.value('type[1]','NVARCHAR(20)')='CarePack' AND
X.Y.value('IsAncillary[1]','VARCHAR(20)')='true' AND X.Y.value('IsSameQtyReq[1]','VARCHAR(20)')='true' AND
X.Y.value('TaxCode[1]','VARCHAR(20)')='OM' AND X.Y.value('Country[1]','VARCHAR(20)')='NL'


来源: stackexchange

问:
How can I make a copy of Data from a google sheet with importrange static?
I have created a number of large result spreadsheets to store data that pull data from another master spreadsheet using importrange that can be updated throughout the year.

My problem is that at the end of the year I want to store the data values from my results spreadsheets from this year statically in say copies but then have the dynamic spreadsheets continue on the next year with new values etc being populated.

Worst case I can copy the spreadsheets and change the importrange links but there are lots of sheets and links so I'm wondering if there is a good way to simply make a copy of the sheet then make it static so it no longer pulls data from the master sheet but keeps it's values.

I tried to download to google sheets as an excel file and re upload but they break when re uploading to google drive.

How can I make a copy of Data from a google sheet with importrange static?

ContentLicense: CC BY-SA 4.0


问:
How to open the remote file in vscode without vscode server?
I am using the vs code for most of my development, but often I am accessing the FreeBSD system or low-resource machine which cannot handle having vs code server.

is there any way to open a remote file, without vscode server?
only basic edit capability is enough.


问:
Typescript - what's the difference between Obj[] and [Obj]
let assume I have an interface like below.

```<code>interface Obj {
  name: string;
  age: number;
}
</code>```

If I declare a new variable in these 2 ways

1)

```<code>const obj: Obj[];
</code>```

```<code>const obj: [Obj]
</code>```

What's the difference of these 2 type declaration?

Body:
let assume I have an interface like below.

interface Obj {
  name: string;
  age: number;
}

If I declare a new variable in these 2 ways

1)

const obj: Obj[];

const obj: [Obj]

What's the difference of these 2 type declaration?


问:
Plotly Isosurface: isovalues isn't in closed interval [isomin, isomax]
I'm using plotly.graph_objects.Isosurface to plot isosurfaces from my data. I noted that some isovalues of interactive plot are not in closed interval [isomin, isomax]. I wonder if it's a bug.

According to plotly official repository  https://plotly.github.io/plotly.py-docs/generated/plotly.graph_objects.Isosurface.html

**isomax – Sets the maximum boundary for iso-surface plot.

isomin – Sets the minimum boundary for iso-surface plot.**

so it's unusual for isovalues to be either smaller than isomin or larger than isomax.

This problem was observed not only in my plot but also in many example plot from Plotly official page https://plotly.com/python/3d-isosurface-plots/

```<code>import plotly.graph_objects as go
import numpy as np

X, Y, Z = np.mgrid[-5:5:40j, -5:5:40j, -5:5:40j]

# ellipsoid
values = X * X * 0.5 + Y * Y + Z * Z * 2

fig = go.Figure(data=go.Isosurface(
    x=X.flatten(),
    y=Y.flatten(),
    z=Z.flatten(),
    value=values.flatten(),
    isomin=10,
    isomax=50,
    surface_count=5, # number of isosurfaces, 2 by default: only min and max
    colorbar_nticks=5, # colorbar ticks correspond to isosurface values
    caps=dict(x_show=False, y_show=False)
    ))
fig.show()
</code>```

As can be seen from above example, the isomin = 10, isomax = 50, but it's easy to find an isovalue that locates outside the closed interval [10,50] from interactive plot.

isovalue's smaller than isomin
isovalue's larger than isomax

Any help would be appreciated. Thank you in advance.

Goal: 3d isosurfaces plot using plotly.graph_objects.Isosurface
Resulted: Some isovalues are not inside [isomin,isomax] as expected

Body:
I'm using plotly.graph_objects.Isosurface to plot isosurfaces from my data. I noted that some isovalues of interactive plot are not in closed interval [isomin, isomax]. I wonder if it's a bug.

According to plotly official repository  https://plotly.github.io/plotly.py-docs/generated/plotly.graph_objects.Isosurface.html

**isomax – Sets the maximum boundary for iso-surface plot.

isomin – Sets the minimum boundary for iso-surface plot.**

so it's unusual for isovalues to be either smaller than isomin or larger than isomax.

This problem was observed not only in my plot but also in many example plot from Plotly official page https://plotly.com/python/3d-isosurface-plots/

import plotly.graph_objects as go
import numpy as np

X, Y, Z = np.mgrid[-5:5:40j, -5:5:40j, -5:5:40j]

# ellipsoid
values = X * X * 0.5 + Y * Y + Z * Z * 2

fig = go.Figure(data=go.Isosurface(
    x=X.flatten(),
    y=Y.flatten(),
    z=Z.flatten(),
    value=values.flatten(),
    isomin=10,
    isomax=50,
    surface_count=5, # number of isosurfaces, 2 by default: only min and max
    colorbar_nticks=5, # colorbar ticks correspond to isosurface values
    caps=dict(x_show=False, y_show=False)
    ))
fig.show()

As can be seen from above example, the isomin = 10, isomax = 50, but it's easy to find an isovalue that locates outside the closed interval [10,50] from interactive plot.

isovalue's smaller than isomin
isovalue's larger than isomax

Any help would be appreciated. Thank you in advance.

Goal: 3d isosurfaces plot using plotly.graph_objects.Isosurface
Resulted: Some isovalues are not inside [isomin,isomax] as expected


问:
How to let PySide2 WebEngineView Show a video successfully？
I'm building a simple browser using PySide2+Python 3.9, but I find that it doesn't play any videos correctly. I don't know how to solve it.

I tried to visithttps://v.qq.com/x/page/w3041d29ecr.htmlHowever, in the page, I saw that your browser does not support this video. On the console, I see these outputs:

```<code>js: A cookie associated with a cross-site resource at http://mediav.com/ was set without the `SameSite` attribute. A future release of Chrome will only deliver cookies with cross-site requests if they are set with `SameSite=None` and `Secure`. You can review cookies in developer tools under Application>Storage>Cookies and see more details at https://www.chromestatus.com/feature/5088147346030592 and https://www.chromestatus.com/feature/5633521622188032.
js: Uncaught (in promise) NotSupportedError: The element has no supported sources.
</code>```

It seems that my code does not support video resources.
I used the following code to configure WebEngineView:

self.browser.settings().setAttribute(QWebEngineSettings.PluginsEnabled, True)
self.browser.settings().setAttribute(QWebEngineSettings.JavascriptEnabled, True)
self.browser.settings().setAttribute(QWebEngineSettings.AllowRunningInsecureContent, True)
self.browser.settings().setAttribute(QWebEngineSettings.LocalContentCanAccessFileUrls, True)
self.browser.settings().setAttribute(QWebEngineSettings.LocalContentCanAccessRemoteUrls, True)
```

But I found that the browser still could not display the video correctly.
From some questions, I learned that maybe I need to recompile PySide2, but how should I compile it? Or how can I solve this problem?

Body:
I'm building a simple browser using PySide2+Python 3.9, but I find that it doesn't play any videos correctly. I don't know how to solve it.

I tried to visithttps://v.qq.com/x/page/w3041d29ecr.htmlHowever, in the page, I saw that your browser does not support this video. On the console, I see these outputs:

js: A cookie associated with a cross-site resource at http://mediav.com/ was set without the `SameSite` attribute. A future release of Chrome will only deliver cookies with cross-site requests if they are set with `SameSite=None` and `Secure`. You can review cookies in developer tools under Application>Storage>Cookies and see more details at https://www.chromestatus.com/feature/5088147346030592 and https://www.chromestatus.com/feature/5633521622188032.
js: Uncaught (in promise) NotSupportedError: The element has no supported sources.

It seems that my code does not support video resources.
I used the following code to configure WebEngineView:

self.browser.settings().setAttribute(QWebEngineSettings.PluginsEnabled, True)
self.browser.settings().setAttribute(QWebEngineSettings.JavascriptEnabled, True)
self.browser.settings().setAttribute(QWebEngineSettings.AllowRunningInsecureContent, True)
self.browser.settings().setAttribute(QWebEngineSettings.LocalContentCanAccessFileUrls, True)
self.browser.settings().setAttribute(QWebEngineSettings.LocalContentCanAccessRemoteUrls, True)

But I found that the browser still could not display the video correctly.
From some questions, I learned that maybe I need to recompile PySide2, but how should I compile it? Or how can I solve this problem?


问:
How can I show list of android native views in Flutter?
Let's say I have a widget coded in dart which shows android native view by using PlatformViewLink.

I want to make a list of that widget dynamically(want to add/remove by user's actions).

But I don't know how to add the multiple widgets dynamically to android activity because the widget uses Platform Link and it seems like they can register only one view by calling

```<code>flutterEngine
  .platformViewsController
  .registry
  .registerViewFactory("myViewTypeId", MyViewFactory())
</code>```

Creating the widget multiple times by dart but it didn't work.

Body:
Let's say I have a widget coded in dart which shows android native view by using PlatformViewLink.

I want to make a list of that widget dynamically(want to add/remove by user's actions).

But I don't know how to add the multiple widgets dynamically to android activity because the widget uses Platform Link and it seems like they can register only one view by calling

flutterEngine
  .platformViewsController
  .registry
  .registerViewFactory("myViewTypeId", MyViewFactory())

Creating the widget multiple times by dart but it didn't work.


问:
Is it possible to add keyboard and controller support to UI Toolkit buttons in Unity?
I tried looking around online, but it doesn't seem like there's support for keyboard and controller inputs for buttons in the relatively new UI Builder for Unity.

From what I can tell, the old button system used Event Systems, but I wasn't able to get that to work for the UI Builder.
Will I need to use the old button system for my game if I really want that functionality?  Does anyone have any workarounds?


问:
How can I get the last commit SHA of a branch that happened before squash and merge?
I have a branch where I then created a pull request and did a Squash and merge which generated a new commit SHA and merged to master.

Issue is I want to use that SHA from master qe55a1a to retrieve the last SHA on the branch ca10b2d, right before the squash and merge.

Is there a git command that can be used to get ca10b2d from qe55a1a programmatically - Given qe55a1a, ca10b2d must be returned.

```<code>Branch A
ca10b2d - last commit
qe55a1a - squash and merge commit

Master
qe55a1a - squash and merge commit
</code>```

I know if I had of done merge commit, i'd have a second parent commit that could be used.  That's what i'm after but for squash and merge.

Body:
I have a branch where I then created a pull request and did a Squash and merge which generated a new commit SHA and merged to master.

Issue is I want to use that SHA from master qe55a1a to retrieve the last SHA on the branch ca10b2d, right before the squash and merge.

Is there a git command that can be used to get ca10b2d from qe55a1a programmatically - Given qe55a1a, ca10b2d must be returned.

Branch A
ca10b2d - last commit
qe55a1a - squash and merge commit

Master
qe55a1a - squash and merge commit

I know if I had of done merge commit, i'd have a second parent commit that could be used.  That's what i'm after but for squash and merge.


问:
Using dimens in font size as design

I want to create a text base TextStyle to apply the image above, but I read some suggestions related to dimes then they advise me to use flutter_screenutil 5.0.3 package.

But it got errors:

```<code>LateInitializationError: Field '\_minTextAdapt@647084504' has not been initialized.
</code>```

Also using this library I'm not sure it can define the screen well when rotating the screen horizontally.

My code in app_theme.dart:

class AppText extends TextStyle {
  static TextStyle get text12 => TextStyle(
        // TODO this has an error when I using library dimens
        fontSize: 12.sp,
        fontFamily: Platform.isIOS ? Fonts.avenirNextRegular : Fonts.robotoRegular,
        fontWeight: FontWeight.normal,
        color: AppColor.mineShaft,
      );

  static TextStyle get text13 => TextStyle(
        fontSize: 13,
        fontFamily: Platform.isIOS ? Fonts.avenirNextRegular : Fonts.robotoRegular,
        fontWeight: FontWeight.normal,
        color: AppColor.mineShaft,
      );

  static TextStyle get text16 => TextStyle(
        fontSize: 16,
        fontFamily: Platform.isIOS ? Fonts.avenirNextRegular : Fonts.robotoRegular,
        fontWeight: FontWeight.normal,
        color: AppColor.mineShaft,
      );

  static TextStyle get text18 => TextStyle(
        fontSize: 18,
        fontFamily: Platform.isIOS ? Fonts.avenirNextRegular : Fonts.robotoRegular,
        fontWeight: FontWeight.normal,
        color: AppColor.mineShaft,
      );

  static TextStyle get text20 => TextStyle(
        fontSize: 20,
        fontFamily: Platform.isIOS ? Fonts.avenirNextRegular : Fonts.robotoRegular,
        fontWeight: FontWeight.normal,
        color: AppColor.mineShaft,
      );

  static TextStyle get text22 => TextStyle(
        fontSize: 22,
        fontFamily: Platform.isIOS ? Fonts.avenirNextRegular : Fonts.robotoRegular,
        fontWeight: FontWeight.normal,
        color: AppColor.mineShaft,
      );
}
```

How can I create base fontSize text and apply it to dimens app text according to the design font above?

Title: Using dimens in font size as design

Body:
I want to create a text base TextStyle to apply the image above, but I read some suggestions related to dimes then they advise me to use flutter_screenutil 5.0.3 package.

But it got errors:

LateInitializationError: Field '\_minTextAdapt@647084504' has not been initialized.

Also using this library I'm not sure it can define the screen well when rotating the screen horizontally.

My code in app_theme.dart:

class AppText extends TextStyle {
  static TextStyle get text12 => TextStyle(
        // TODO this has an error when I using library dimens
        fontSize: 12.sp,
        fontFamily: Platform.isIOS ? Fonts.avenirNextRegular : Fonts.robotoRegular,
        fontWeight: FontWeight.normal,
        color: AppColor.mineShaft,
      );

  static TextStyle get text13 => TextStyle(
        fontSize: 13,
        fontFamily: Platform.isIOS ? Fonts.avenirNextRegular : Fonts.robotoRegular,
        fontWeight: FontWeight.normal,
        color: AppColor.mineShaft,
      );

  static TextStyle get text16 => TextStyle(
        fontSize: 16,
        fontFamily: Platform.isIOS ? Fonts.avenirNextRegular : Fonts.robotoRegular,
        fontWeight: FontWeight.normal,
        color: AppColor.mineShaft,
      );

  static TextStyle get text18 => TextStyle(
        fontSize: 18,
        fontFamily: Platform.isIOS ? Fonts.avenirNextRegular : Fonts.robotoRegular,
        fontWeight: FontWeight.normal,
        color: AppColor.mineShaft,
      );

  static TextStyle get text20 => TextStyle(
        fontSize: 20,
        fontFamily: Platform.isIOS ? Fonts.avenirNextRegular : Fonts.robotoRegular,
        fontWeight: FontWeight.normal,
        color: AppColor.mineShaft,
      );

  static TextStyle get text22 => TextStyle(
        fontSize: 22,
        fontFamily: Platform.isIOS ? Fonts.avenirNextRegular : Fonts.robotoRegular,
        fontWeight: FontWeight.normal,
        color: AppColor.mineShaft,
      );
}

How can I create base fontSize text and apply it to dimens app text according to the design font above?


问:
Warning: Undefined variable $id_bayar in C:\xampp\htdocs\food-order\info.php on line 79
So i made a program for food ordering and the problem come from the part of info.php where in this file the costumer can view their total product. here's the source code :

<?php include( 'partials-front/menu.php' );
?>

Informasi Orderan

Tambah Pesananan +

                    Nama
                    Pesanan
                    Harga
                    Jumlah
                    Status

            <?php

$username = $_SESSION[ 'user' ];

$sql3 = "SELECT * FROM pelanggan WHERE username= '$username'";
$res3 = mysqli_query( $conn, $sql3 );
$data_user = mysqli_fetch_assoc( $res3 );

$id_user = $data_user [ 'id_pelanggan' ];

//save the order in database
//create SQL to save the data

// var_dump ( $sql2 );

$sql = "SELECT *FROM tabel_pesanan JOIN pelanggan ON tabel_pesanan.id_pelanggan=pelanggan.id_pelanggan JOIN tabel_makanan ON tabel_makanan.id_makanan=tabel_pesanan.id_makanan WHERE pelanggan.id_pelanggan='$id_user'";
$res = mysqli_query( $conn, $sql );
$count = mysqli_num_rows( $res );

if ( $count>0 )

//pesanan tersedia
while( $row = mysqli_fetch_assoc( $res ) ) {
    // var_dump( $row );
    // die;

    //get all the order details
    $nama = $row[ 'nama' ];
    $makanan = $row[ 'title' ];
    $harga = $row[ 'harga' ];
    $jumlah = $row[ 'jumlah' ];
    $total = $row [ 'total' ];
    $status = $row[ 'status' ];
    $id_bayar = $row[ 'id_bukti_bayar' ];

    ?>

                    <?php echo $nama?>
                    <?php echo $makanan ?>
                    <?php echo $harga?>
                    <?php echo $jumlah?>
                    <?php echo $status?>

            <?php
}

?>

        <?php
         $sql = "SELECT * FROM bukti_pembayaran WHERE id_bukti_bayar='$id_bayar'";
    //execute the query
    $res = mysqli_query( $conn, $sql );
    //get the value from database
    $row = mysqli_fetch_assoc( $res );

    $nama_gambar = $row['gambar'];
    if(empty($nama_gambar)){
        ?>
        <form method='POST' action='uploadbukti.php' enctype='multipart/form-data'>

                 Upload Bukti Pembayaran :

                    <input type='file' name='image'>
                    <input type='hidden' name='id_bukti_bayar' value="<?= $id_bayar?>" />
                    <input type='Submit' class='btn-secondary'>

        </form>

 Transfer Ke Nomor rekening : 0111-01-058223-50-7 (BANK BRI)

        <?php
    }
        else
    {
        ?>

Bukti Pembayaran Telah Diupload ! Silahkan Menunggu Status Order

        <?php
        }
        ?>

    <?php

?>

<?php include( 'partials-front/footer.php' );
?>
```

and this is the error
error view

ive been trying to think thank maybe i need to add a condition when the data is empty there is a condition that show the data is empty, but i dont know how to do it

sorry for my bad english, i do my best
please if anyone there can help me

Body:
So i made a program for food ordering and the problem come from the part of info.php where in this file the costumer can view their total product. here's the source code :

<?php include( 'partials-front/menu.php' );
?>

Informasi Orderan

Tambah Pesananan +

                    Nama
                    Pesanan
                    Harga
                    Jumlah
                    Status

            <?php

$username = $_SESSION[ 'user' ];

$sql3 = "SELECT * FROM pelanggan WHERE username= '$username'";
$res3 = mysqli_query( $conn, $sql3 );
$data_user = mysqli_fetch_assoc( $res3 );

$id_user = $data_user [ 'id_pelanggan' ];

//save the order in database
//create SQL to save the data

// var_dump ( $sql2 );

$sql = "SELECT *FROM tabel_pesanan JOIN pelanggan ON tabel_pesanan.id_pelanggan=pelanggan.id_pelanggan JOIN tabel_makanan ON tabel_makanan.id_makanan=tabel_pesanan.id_makanan WHERE pelanggan.id_pelanggan='$id_user'";
$res = mysqli_query( $conn, $sql );
$count = mysqli_num_rows( $res );

if ( $count>0 )

//pesanan tersedia
while( $row = mysqli_fetch_assoc( $res ) ) {
    // var_dump( $row );
    // die;

    //get all the order details
    $nama = $row[ 'nama' ];
    $makanan = $row[ 'title' ];
    $harga = $row[ 'harga' ];
    $jumlah = $row[ 'jumlah' ];
    $total = $row [ 'total' ];
    $status = $row[ 'status' ];
    $id_bayar = $row[ 'id_bukti_bayar' ];

    ?>

                    <?php echo $nama?>
                    <?php echo $makanan ?>
                    <?php echo $harga?>
                    <?php echo $jumlah?>
                    <?php echo $status?>

            <?php
}

?>

        <?php
         $sql = "SELECT * FROM bukti_pembayaran WHERE id_bukti_bayar='$id_bayar'";
    //execute the query
    $res = mysqli_query( $conn, $sql );
    //get the value from database
    $row = mysqli_fetch_assoc( $res );

    $nama_gambar = $row['gambar'];
    if(empty($nama_gambar)){
        ?>
        <form method='POST' action='uploadbukti.php' enctype='multipart/form-data'>

                 Upload Bukti Pembayaran :

                    <input type='file' name='image'>
                    <input type='hidden' name='id_bukti_bayar' value="<?= $id_bayar?>" />
                    <input type='Submit' class='btn-secondary'>

        </form>

 Transfer Ke Nomor rekening : 0111-01-058223-50-7 (BANK BRI)

        <?php
    }
        else
    {
        ?>

Bukti Pembayaran Telah Diupload ! Silahkan Menunggu Status Order

        <?php
        }
        ?>

    <?php

?>

<?php include( 'partials-front/footer.php' );
?>

and this is the error
error view

ive been trying to think thank maybe i need to add a condition when the data is empty there is a condition that show the data is empty, but i dont know how to do it

sorry for my bad english, i do my best
please if anyone there can help me


问:
Can't close opened serial COM port on script
```<code>import serial
try:
    ser = serial.Serial(port = 'COM7', baudrate = 921600, timeout = 2, bytesize = 8)
except serial.SerialException:
    ser.close()
    ser = serial.Serial(port = 'COM7', baudrate = 921600, timeout = 2, bytesize = 8)
</code>```

Sometimes my script exits before reaching ser.close() at the end so I thought the below code would catch the exception, close the port and reopen the port:

However, I got "NameError: name 'ser' is not defined"  at ser.close() statement when running the whole script.

But strange enough, there is no issues if I highlighted the code section and run as a section.

Body:
import serial
try:
    ser = serial.Serial(port = 'COM7', baudrate = 921600, timeout = 2, bytesize = 8)
except serial.SerialException:
    ser.close()
    ser = serial.Serial(port = 'COM7', baudrate = 921600, timeout = 2, bytesize = 8)

Sometimes my script exits before reaching ser.close() at the end so I thought the below code would catch the exception, close the port and reopen the port:

However, I got "NameError: name 'ser' is not defined"  at ser.close() statement when running the whole script.

But strange enough, there is no issues if I highlighted the code section and run as a section.


问:
Kafka messages are not consumed
Kafka messages are not consumed and the lag is showing as 3 for past 12 hours. As given below, output of kafka-consumer-groups.sh, there are consumers available for those partitions but still why the lag is there.

```<code>xxxx           xxxx-topic      1          5               8               3               xxxx-consumer-0-1ab61584-e293-40cd-864f-7140d72c6467 /xx.yyy.zzz.aaa xxxx-retry-consumer-
</code>```

Here the CURRENT-OFFSET is 5 and LOG-END-OFFSET is 8.

In application logs the following messages are there

```<code>org.springframework.kafka.KafkaListenerEndpointContainer#1-0-C-1 - -  -  -  -   -       Fetcher [INFO] [Consumer clientId=xxxx-consumer-0, groupId=xxxx] Resetting offset for partition xxxx-topic-1 to offset 8.
org.springframework.kafka.KafkaListenerEndpointContainer#1-0-C-1 - -  -  -  -   -       FetchSessionHandler [INFO] [Consumer clientId=xxxx-consumer-0, groupId=xxxx] Node 1 was unable to process the fetch request with (sessionId=519998604, epoch=236): FETCH_SESSION_ID_NOT_FOUND.
</code>```

Title: Kafka messages are not consumed

Body:
Kafka messages are not consumed and the lag is showing as 3 for past 12 hours. As given below, output of kafka-consumer-groups.sh, there are consumers available for those partitions but still why the lag is there.

xxxx           xxxx-topic      1          5               8               3               xxxx-consumer-0-1ab61584-e293-40cd-864f-7140d72c6467 /xx.yyy.zzz.aaa xxxx-retry-consumer-

Here the CURRENT-OFFSET is 5 and LOG-END-OFFSET is 8.

In application logs the following messages are there

org.springframework.kafka.KafkaListenerEndpointContainer#1-0-C-1 - -  -  -  -   -       Fetcher [INFO] [Consumer clientId=xxxx-consumer-0, groupId=xxxx] Resetting offset for partition xxxx-topic-1 to offset 8.
org.springframework.kafka.KafkaListenerEndpointContainer#1-0-C-1 - -  -  -  -   -       FetchSessionHandler [INFO] [Consumer clientId=xxxx-consumer-0, groupId=xxxx] Node 1 was unable to process the fetch request with (sessionId=519998604, epoch=236): FETCH_SESSION_ID_NOT_FOUND.


问:
Expo app stuck on splash screen after exporting it from snack
I wanted to create a calculator in a snack in expo, but then I tried to use it with an external code editor and It just stopped working. It was stuck on the splash screen and neither android nor web showed anything.

The proyect in snack works perfectly, but when I exported it, it didn't show anything.

My App.js is:

```<code>import * as React from 'react';
import { NavigationContainer } from '@react-navigation/native'
import DrawerNavigator from './components/DrawerNavigator'

export default function App(){
  return(
    <NavigationContainer>
      <DrawerNavigator/>
    </NavigationContainer>
  )
}
</code>```

My package.json is:

```<code>{
  "main": "node_modules/expo/AppEntry.js",
  "scripts": {
    "start": "expo start",
    "android": "expo start --android",
    "ios": "expo start --ios",
    "web": "expo start --web"
  },
  "dependencies": {
    "expo": "~47.0.8",
    "expo-status-bar": "~1.4.2",
    "react": "18.1.0",
    "react-native": "0.70.5",
    "tinydb": "*",
    "expo-constants": "~14.0.2",
    "@expo/vector-icons": "^13.0.0",
    "react-native-paper": "4.9.2",
    "react-native-screens": "~3.18.0",
    "react-native-reanimated": "~2.12.0",
    "@react-navigation/drawer": "^5.7.2",
    "@react-navigation/native": "^5.0.5",
    "react-native-vector-icons": "*",
    "react-native-gesture-handler": "~2.8.0",
    "react-native-safe-area-context": "4.4.1",
    "react-native-responsive-fontsize": "*",
    "react-native-web": "~0.18.9",
    "react-dom": "18.1.0",
    "@expo/webpack-config": "^0.17.2"
  },
  "devDependencies": {
    "@babel/core": "^7.12.9"
  },
  "private": true
}
</code>```

Body:
I wanted to create a calculator in a snack in expo, but then I tried to use it with an external code editor and It just stopped working. It was stuck on the splash screen and neither android nor web showed anything.

The proyect in snack works perfectly, but when I exported it, it didn't show anything.

My App.js is:

import * as React from 'react';
import { NavigationContainer } from '@react-navigation/native'
import DrawerNavigator from './components/DrawerNavigator'

export default function App(){
  return(
    <NavigationContainer>
      <DrawerNavigator/>
    </NavigationContainer>
  )
}

My package.json is:

{
  "main": "node_modules/expo/AppEntry.js",
  "scripts": {
    "start": "expo start",
    "android": "expo start --android",
    "ios": "expo start --ios",
    "web": "expo start --web"
  },
  "dependencies": {
    "expo": "~47.0.8",
    "expo-status-bar": "~1.4.2",
    "react": "18.1.0",
    "react-native": "0.70.5",
    "tinydb": "*",
    "expo-constants": "~14.0.2",
    "@expo/vector-icons": "^13.0.0",
    "react-native-paper": "4.9.2",
    "react-native-screens": "~3.18.0",
    "react-native-reanimated": "~2.12.0",
    "@react-navigation/drawer": "^5.7.2",
    "@react-navigation/native": "^5.0.5",
    "react-native-vector-icons": "*",
    "react-native-gesture-handler": "~2.8.0",
    "react-native-safe-area-context": "4.4.1",
    "react-native-responsive-fontsize": "*",
    "react-native-web": "~0.18.9",
    "react-dom": "18.1.0",
    "@expo/webpack-config": "^0.17.2"
  },
  "devDependencies": {
    "@babel/core": "^7.12.9"
  },
  "private": true
}


问:
TOR with nodejs, how to add hashedcontrolpassword value while proxy
I have this code with nodejs which will connect to a hidden TOR service and make request. How can I appyl hashedcontrol password value, along declaring the host and the port ? I have a password and I need authentication before I can do anything. Please take a look at the code</p>
```<code>const url = require('url');
const http = require('http');
const https = require('https');
const SocksProxyAgent = require('socks-proxy-agent');

// Use the SOCKS_PROXY env var if using a custom bind address or port for your TOR proxy:
const proxy = process.env.SOCKS_PROXY || 'socks5h://127.0.0.1:9050';
console.log('Using proxy server %j', proxy);
// The default HTTP endpoint here is DuckDuckGo's v3 onion address:
const endpoint = process.argv[2] || 'https://duckduckgogg42xjoc72x3sjasowoarfbgcmvfimaftt6twagswzczad.onion';
console.log('Attempting to GET %j', endpoint);
// Prepare options for the http/s module by parsing the endpoint URL:
let options = url.parse(endpoint);
const agent = new SocksProxyAgent(proxy);
// Here we pass the socks proxy agent to the http/s module:
options.agent = agent;
// Depending on the endpoint's protocol, we use http or https module:
const httpOrHttps = options.protocol === 'https:' ? https : http;
// Make an HTTP GET request:
httpOrHttps.get(options, res => {
    // Print headers on response:
    console.log('Response received', res.headers);
    // Pipe response body to output stream:
    res.pipe(process.stdout);
});
</code>```

Body:
I have this code with nodejs which will connect to a hidden TOR service and make request. How can I appyl hashedcontrol password value, along declaring the host and the port ? I have a password and I need authentication before I can do anything. Please take a look at the code

const url = require('url');
const http = require('http');
const https = require('https');
const SocksProxyAgent = require('socks-proxy-agent');

// Use the SOCKS_PROXY env var if using a custom bind address or port for your TOR proxy:
const proxy = process.env.SOCKS_PROXY || 'socks5h://127.0.0.1:9050';
console.log('Using proxy server %j', proxy);
// The default HTTP endpoint here is DuckDuckGo's v3 onion address:
const endpoint = process.argv[2] || 'https://duckduckgogg42xjoc72x3sjasowoarfbgcmvfimaftt6twagswzczad.onion';
console.log('Attempting to GET %j', endpoint);
// Prepare options for the http/s module by parsing the endpoint URL:
let options = url.parse(endpoint);
const agent = new SocksProxyAgent(proxy);
// Here we pass the socks proxy agent to the http/s module:
options.agent = agent;
// Depending on the endpoint's protocol, we use http or https module:
const httpOrHttps = options.protocol === 'https:' ? https : http;
// Make an HTTP GET request:
httpOrHttps.get(options, res => {
    // Print headers on response:
    console.log('Response received', res.headers);
    // Pipe response body to output stream:
    res.pipe(process.stdout);
});


问:
how to use both where clause and group_concat in single table in mysql?
```<code>select `Part Name` ,`Current Status` as `Current Status`,
group_concat(`Inward Qty`) as `Inward Qty` from production
where `Current Status` = 'Active' group by `Manufacturer Part Number`;
</code>```

I have been try to group_concat the value which have been already
using the where clause in mysql ,can any one help with this query.

I was expecting this answer

```<code>Part Name      Current Status     Inward Qty

ADAPTOR         Active      25,6,10,10,20,0
BATTERY         Active      0,730
BATTERY         Active      50,30,0
BATTERY         Active      0,1,25,10,3
BATTERY         Active      50,10,10,4,0,500,10,30,83
BATTERY CHARGER Active      30,0,1
BATTERY-STRAP   Active      100,0,1000,5,1000
BATTERY-STRAP   Active      0,509
BATTERY-STRAP   Active      1000,1000,5,0,100
BM-IC           Active      0,9,40,40,100
</code>```

But i am getting this

```<code>Part Name      Current Status     Inward Qty

ADAPTOR         Active              0
BATTERY         Active              0
BATTERY         Active              0
BATTERY         Active              0
BATTERY         Active              0
BATTERY CHARGER Active              0
BATTERY-STRAP   Active              0
BATTERY-STRAP   Active              0
BATTERY-STRAP   Active              0
BM-IC           Active              0
</code>```

Body:
select `Part Name` ,`Current Status` as `Current Status`,
group_concat(`Inward Qty`) as `Inward Qty` from production
where `Current Status` = 'Active' group by `Manufacturer Part Number`;

I have been try to group_concat the value which have been already
using the where clause in mysql ,can any one help with this query.

I was expecting this answer

Part Name      Current Status     Inward Qty

ADAPTOR         Active      25,6,10,10,20,0
BATTERY         Active      0,730
BATTERY         Active      50,30,0
BATTERY         Active      0,1,25,10,3
BATTERY         Active      50,10,10,4,0,500,10,30,83
BATTERY CHARGER Active      30,0,1
BATTERY-STRAP   Active      100,0,1000,5,1000
BATTERY-STRAP   Active      0,509
BATTERY-STRAP   Active      1000,1000,5,0,100
BM-IC           Active      0,9,40,40,100

But i am getting this

Part Name      Current Status     Inward Qty

ADAPTOR         Active              0
BATTERY         Active              0
BATTERY         Active              0
BATTERY         Active              0
BATTERY         Active              0
BATTERY CHARGER Active              0
BATTERY-STRAP   Active              0
BATTERY-STRAP   Active              0
BATTERY-STRAP   Active              0
BM-IC           Active              0


问:
What is the best way to parse this request.data in drf, when the request is form-data?
I have this form which sends an image along with some other data. I am using django-rest-framework in the back end. I need to take out couple of fields from this form input and do some operations and use the remaining fields to send to my ModelSerializer for posting the form data. What is the best way to achieve this?

```<code>class AreaSerializer(ModelSerializer):

    class Meta:
        model = AreaMaster
        fields = '__all__'

class AreaMaster(models.Model):
    name = models.CharField(max_length=150)
    site = models.ForeignKey("SiteMaster")
    version = models.IntegerField(default=1)
    floor_map = models.FileField(blank=True, null=True)
    status = models.SmallIntegerField(default=1)
    created_date = models.DateTimeField(auto_now_add=True)
    updated_date = models.DateTimeField(auto_now=True)
</code>```

<QueryDict: {'areaName': ['Mall-24F'], 'devices': ['[\n  {\n

"name": "device_001",\n    "coordinates": [\n      23,\n      56\n

],\n  },\n  {\n    "name": "device_002",\n    "coordinates": [\n

24,\n      57\n    ],\n  },\n  {\n    "name": "device_003",\n

"coordinates": [\n      25,\n      58\n    ],\n  }\n]'], 'floorMap':
[<InMemoryUploadedFile: 1653650801973.png (image/png)>]}>

This is how request.data looks like.

What I have tried doing is

```<code>context = request.data
context["name"] = context.pop("areaName")[0]
context["floor_map"] = context.pop("floorMap")[0]

</code>```

Basically I only want "name" and "floor_map" to be sent to ModelSerializer. I have read that request.data is immutable, but here it is mutable. I think I am missing something.

Body:
I have this form which sends an image along with some other data. I am using django-rest-framework in the back end. I need to take out couple of fields from this form input and do some operations and use the remaining fields to send to my ModelSerializer for posting the form data. What is the best way to achieve this?

class AreaSerializer(ModelSerializer):

    class Meta:
        model = AreaMaster
        fields = '__all__'

class AreaMaster(models.Model):
    name = models.CharField(max_length=150)
    site = models.ForeignKey("SiteMaster")
    version = models.IntegerField(default=1)
    floor_map = models.FileField(blank=True, null=True)
    status = models.SmallIntegerField(default=1)
    created_date = models.DateTimeField(auto_now_add=True)
    updated_date = models.DateTimeField(auto_now=True)

<QueryDict: {'areaName': ['Mall-24F'], 'devices': ['[\n  {\n

"name": "device_001",\n    "coordinates": [\n      23,\n      56\n

],\n  },\n  {\n    "name": "device_002",\n    "coordinates": [\n

24,\n      57\n    ],\n  },\n  {\n    "name": "device_003",\n

"coordinates": [\n      25,\n      58\n    ],\n  }\n]'], 'floorMap':
[<InMemoryUploadedFile: 1653650801973.png (image/png)>]}>

This is how request.data looks like.

What I have tried doing is

context = request.data
context["name"] = context.pop("areaName")[0]
context["floor_map"] = context.pop("floorMap")[0]

Basically I only want "name" and "floor_map" to be sent to ModelSerializer. I have read that request.data is immutable, but here it is mutable. I think I am missing something.


问:
How to route external HTTPS request to internal http mock service using Istio
I am using Istio with mTLS enabled.

I am trying to mock some external requests using a mock service deployed inside my cluster.

For example, I want all requests to https://httpbin.org redirect to my internal service http://mock.default.svc.cluster.local

My mock service is a simple webservice serving on 80 port.

I was able to do this using service entry & virtualservices for http requests, but I also want to be able to do the same thing for https requests.

Here's my setup:

apiVersion: networking.istio.io/v1alpha3
kind: ServiceEntry
metadata:
  name: httpbin-ext
spec:
  hosts:
  - httpbin.org
  ports:
  - number: 80
    name: http
    protocol: HTTP
  - number: 443
    name: https
    protocol: HTTPS
  resolution: DNS
  location: MESH_EXTERNAL
---
apiVersion: networking.istio.io/v1alpha3
kind: VirtualService
metadata:
  name: httpbin-mock
spec:
  hosts:
  - httpbin.org
  http:
  - route:
    - destination:
        host: mock.default.svc.cluster.local
  tls:
  - match:
    - port: 443
      sniHosts:
      - httpbin.org
    route:
    - destination:
        host: mock.default.svc.cluster.local
        port:
          number: 80
```

But when I curl the https://httpbin.org, I got the following error:
curl: (35) error:1408F10B:SSL routines:ssl3_get_record:wrong version number

I am guessing it's because on my mock service 80 port, no one is handling the https protocol.

What's the best approach to do this? A self-signed nginx and destination rule with certificates? Or there's a better way?

Body:
I am using Istio with mTLS enabled.

I am trying to mock some external requests using a mock service deployed inside my cluster.

For example, I want all requests to https://httpbin.org redirect to my internal service http://mock.default.svc.cluster.local

My mock service is a simple webservice serving on 80 port.

I was able to do this using service entry & virtualservices for http requests, but I also want to be able to do the same thing for https requests.

Here's my setup:

apiVersion: networking.istio.io/v1alpha3
kind: ServiceEntry
metadata:
  name: httpbin-ext
spec:
  hosts:
  - httpbin.org
  ports:
  - number: 80
    name: http
    protocol: HTTP
  - number: 443
    name: https
    protocol: HTTPS
  resolution: DNS
  location: MESH_EXTERNAL
---
apiVersion: networking.istio.io/v1alpha3
kind: VirtualService
metadata:
  name: httpbin-mock
spec:
  hosts:
  - httpbin.org
  http:
  - route:
    - destination:
        host: mock.default.svc.cluster.local
  tls:
  - match:
    - port: 443
      sniHosts:
      - httpbin.org
    route:
    - destination:
        host: mock.default.svc.cluster.local
        port:
          number: 80

But when I curl the https://httpbin.org, I got the following error:
curl: (35) error:1408F10B:SSL routines:ssl3_get_record:wrong version number

I am guessing it's because on my mock service 80 port, no one is handling the https protocol.

What's the best approach to do this? A self-signed nginx and destination rule with certificates? Or there's a better way?


问:
How to use Entities classes from different locations in CodeIgniter 4 using Doctrine 2
I am using CodeIgniter 4.x for my project. In my approach, I am using Module system for my project. My Module system is like below structure:

```<code>- App
    - Modules
        - ListMaster
            - User
                - Models
                    - Doctrine
                        - Entities
                            - User.php
                            - UserApp.php
            - UserGroup
                - Models
                    - Doctrine
                        - Entities
                            - Usergroup.php
        - Budget
            - Models
                - Doctrine
                    - Entities
                        - Budget.php

</code>```

In a simple word, I have designed to have my Modules under App/Modules folder. This Folder could consist a Module folder or a folder which will hold Modules. As I created two Modules App/Modules/ListMaster/User and App/Modules/ListMaster/Usergroup. My Entity Class Files will be located under ...Models/Doctrine/Entities folders.

I have downloaded Doctrine using Composer. My Composer is as follow:

```<code>{
    "require": {
        "doctrine/orm": "^2.3.3",
        "doctrine/dbal": "^3.2",
        "doctrine/annotations": "^1.14",
        "symfony/yaml": "^5.4",
        "symfony/cache": "^5.4"
    },
    "autoload": {
        "psr-0": {"": "src/"}
    },
}
</code>```

I have created a Library file under App/Libraries which is as follow:

```<code><?php
namespace App\Libraries;

//WE INCLUDING THE AUTOLOAD VENDOR
include_once dirname(__DIR__, 2) . '/vendor/autoload.php';

use Doctrine\Common\ClassLoader;
use Doctrine\ORM\EntityManager;
use Doctrine\ORM\Tools\Setup;

// TO OBTAIN THE ENTITY MANAGER
class Doctrine
{

    public $em;

    public function __construct()
    {
        // Retrieving all paths leading to entities classes
        $modulePath = APPPATH."Models/Doctrine/Entities";
        $entitiesPath = glob($modulePath, GLOB_ONLYDIR);
        $modulePath = APPPATH."Modules/*/Models/Doctrine/Entities";
        $entitiesPath = array_merge($entitiesPath, glob($modulePath, GLOB_ONLYDIR));
        $modulePath = APPPATH."Modules/*/*/Models/Doctrine/Entities";
        $entitiesPath = array_merge($entitiesPath, glob($modulePath, GLOB_ONLYDIR));

        $isDevMode = true;
    $cache = null;
        $useSimpleAnnotationReader = false;

        // CONNECTION SETUP
        $config = config("Database");
        $connection_options = array(
            'driver'   => strtolower($config->doctrine['DBDriver']),
            'user'     => $config->doctrine['username'],
            'password' => $config->doctrine['password'],
            'dbname'   => $config->doctrine['database'],
            'host'     => $config->doctrine['hostname']
        );

        $proxies_dir = APPPATH . 'Models/Doctrine/Proxies';

        $config = Setup::createAnnotationMetadataConfiguration($entitiesPath, $isDevMode, $proxies_dir, $cache, $useSimpleAnnotationReader);
        if (ENVIRONMENT === 'development') {
            $config->setAutoGenerateProxyClasses(true);
        } else {
            $config->setAutoGenerateProxyClasses(false);
        }

        try {
            $this->em = EntityManager::create($connection_options, $config);
        } catch (\Doctrine\ORM\ORMException $e) {
            log_message("Doctrine Exception : ", $e);
        }
    }

}
</code>```

As you can see from this, My Entities files will be at Models/Doctrine/Entities, Modules/{any folder}/Models/Doctrine/Entities, Modules/{any folder}/{any folder}/Models/Doctrine/Entities folders.

Now here is my sample Entities Class:

```<code><?php

namespace entities;

use Doctrine\ORM\Mapping as ORM;

/**
 * User
 *
 * @ORM\Table(name="user")
 * @ORM\Entity
 */
class User
{
  /**
   * @var smallint $id
   *
   * @ORM\Column(name="id", type="smallint", nullable=false)
   * @ORM\Id
   * @ORM\GeneratedValue(strategy="IDENTITY")
   */
  protected $id;

  /**
   * @var string $userName
   *
   * @ORM\Column(name="user_name", type="string", length=150, nullable=true)
   */
  protected $userName;

  /**
   * Constructor
   */
  public function __construct()
  {

  }

  /**
   * Get id
   *
   * @return boolean
   */
  public function getId()
  {
    return $this->id;
  }

  /**
   * Set userName
   *
   * @param string $userName
   */
  public function setUserName($userName)
  {
    $this->userName = $userName;
  }

  /**
   * Get userName
   *
   * @return string
   */
  public function getUserName()
  {
    return $this->userName;
  }
}
</code>```

Now from my Controller I am executing this Line of code which produces entities\User class not found error. Though this structure can create and update Schema in database successfully.

```<code>$users = $this->em->getRepository('entities\User')->findAll();
</code>```

Note that I have successfully Generate Proxy, Generate Entities, Create Schema, Update Schema from this installation.

So my question is, how can I fix the class not found error and get result from database from any table?

Body:
I am using CodeIgniter 4.x for my project. In my approach, I am using Module system for my project. My Module system is like below structure:

- App
    - Modules
        - ListMaster
            - User
                - Models
                    - Doctrine
                        - Entities
                            - User.php
                            - UserApp.php
            - UserGroup
                - Models
                    - Doctrine
                        - Entities
                            - Usergroup.php
        - Budget
            - Models
                - Doctrine
                    - Entities
                        - Budget.php

In a simple word, I have designed to have my Modules under App/Modules folder. This Folder could consist a Module folder or a folder which will hold Modules. As I created two Modules App/Modules/ListMaster/User and App/Modules/ListMaster/Usergroup. My Entity Class Files will be located under ...Models/Doctrine/Entities folders.

I have downloaded Doctrine using Composer. My Composer is as follow:

{
    "require": {
        "doctrine/orm": "^2.3.3",
        "doctrine/dbal": "^3.2",
        "doctrine/annotations": "^1.14",
        "symfony/yaml": "^5.4",
        "symfony/cache": "^5.4"
    },
    "autoload": {
        "psr-0": {"": "src/"}
    },
}

I have created a Library file under App/Libraries which is as follow:

<?php
namespace App\Libraries;

//WE INCLUDING THE AUTOLOAD VENDOR
include_once dirname(__DIR__, 2) . '/vendor/autoload.php';

use Doctrine\Common\ClassLoader;
use Doctrine\ORM\EntityManager;
use Doctrine\ORM\Tools\Setup;

// TO OBTAIN THE ENTITY MANAGER
class Doctrine
{

    public $em;

    public function __construct()
    {
        // Retrieving all paths leading to entities classes
        $modulePath = APPPATH."Models/Doctrine/Entities";
        $entitiesPath = glob($modulePath, GLOB_ONLYDIR);
        $modulePath = APPPATH."Modules/*/Models/Doctrine/Entities";
        $entitiesPath = array_merge($entitiesPath, glob($modulePath, GLOB_ONLYDIR));
        $modulePath = APPPATH."Modules/*/*/Models/Doctrine/Entities";
        $entitiesPath = array_merge($entitiesPath, glob($modulePath, GLOB_ONLYDIR));

        $isDevMode = true;
    $cache = null;
        $useSimpleAnnotationReader = false;

        // CONNECTION SETUP
        $config = config("Database");
        $connection_options = array(
            'driver'   => strtolower($config->doctrine['DBDriver']),
            'user'     => $config->doctrine['username'],
            'password' => $config->doctrine['password'],
            'dbname'   => $config->doctrine['database'],
            'host'     => $config->doctrine['hostname']
        );

        $proxies_dir = APPPATH . 'Models/Doctrine/Proxies';

        $config = Setup::createAnnotationMetadataConfiguration($entitiesPath, $isDevMode, $proxies_dir, $cache, $useSimpleAnnotationReader);
        if (ENVIRONMENT === 'development') {
            $config->setAutoGenerateProxyClasses(true);
        } else {
            $config->setAutoGenerateProxyClasses(false);
        }

        try {
            $this->em = EntityManager::create($connection_options, $config);
        } catch (\Doctrine\ORM\ORMException $e) {
            log_message("Doctrine Exception : ", $e);
        }
    }

}

As you can see from this, My Entities files will be at Models/Doctrine/Entities, Modules/{any folder}/Models/Doctrine/Entities, Modules/{any folder}/{any folder}/Models/Doctrine/Entities folders.

Now here is my sample Entities Class:

<?php

namespace entities;

use Doctrine\ORM\Mapping as ORM;

/**
 * User
 *
 * @ORM\Table(name="user")
 * @ORM\Entity
 */
class User
{
  /**
   * @var smallint $id
   *
   * @ORM\Column(name="id", type="smallint", nullable=false)
   * @ORM\Id
   * @ORM\GeneratedValue(strategy="IDENTITY")
   */
  protected $id;

  /**
   * @var string $userName
   *
   * @ORM\Column(name="user_name", type="string", length=150, nullable=true)
   */
  protected $userName;

  /**
   * Constructor
   */
  public function __construct()
  {

  }

  /**
   * Get id
   *
   * @return boolean
   */
  public function getId()
  {
    return $this->id;
  }

  /**
   * Set userName
   *
   * @param string $userName
   */
  public function setUserName($userName)
  {
    $this->userName = $userName;
  }

  /**
   * Get userName
   *
   * @return string
   */
  public function getUserName()
  {
    return $this->userName;
  }
}

Now from my Controller I am executing this Line of code which produces entities\User class not found error. Though this structure can create and update Schema in database successfully.

$users = $this->em->getRepository('entities\User')->findAll();

Note that I have successfully Generate Proxy, Generate Entities, Create Schema, Update Schema from this installation.

So my question is, how can I fix the class not found error and get result from database from any table?


问:
Windowmanager not show in settings android
I make app lockscreen, but Windowmanager in Services doesn't show up in the settings (package com.android.settings) of some Android devices (e.g. Samsung A51) (not all devices). When I go out of the settings, my view is then displayed.

How to show windowManager in settings?

Here is my code.

```<code>windowManager = getSystemService(WINDOW_SERVICE) as WindowManager
inflater = getSystemService(LAYOUT_INFLATER_SERVICE) as LayoutInflater
rootView = inflater.inflate(R.layout.view_lock_root, null)

paramsManager.type = WindowManager.LayoutParams.TYPE_APPLICATION_OVERLAY
paramsManager.format = PixelFormat.TRANSPARENT
paramsManager.gravity = Gravity.TOP
paramsManager.width = WindowManager.LayoutParams.MATCH_PARENT
</code>```

Update:
I think Settings uses the flag SYSTEM_FLAG_HIDE_NON_SYSTEM_OVERLAY_WINDOWS

Body:
I make app lockscreen, but Windowmanager in Services doesn't show up in the settings (package com.android.settings) of some Android devices (e.g. Samsung A51) (not all devices). When I go out of the settings, my view is then displayed.

How to show windowManager in settings?

Here is my code.

windowManager = getSystemService(WINDOW_SERVICE) as WindowManager
inflater = getSystemService(LAYOUT_INFLATER_SERVICE) as LayoutInflater
rootView = inflater.inflate(R.layout.view_lock_root, null)

paramsManager.type = WindowManager.LayoutParams.TYPE_APPLICATION_OVERLAY
paramsManager.format = PixelFormat.TRANSPARENT
paramsManager.gravity = Gravity.TOP
paramsManager.width = WindowManager.LayoutParams.MATCH_PARENT

Update:
I think Settings uses the flag SYSTEM_FLAG_HIDE_NON_SYSTEM_OVERLAY_WINDOWS


问:
ParseException with commons-codec 20041127.091804
We are currently using safe-svg 1.1.4 3rd party jar to validate the svg content. But when we upgrade to latest jar (1.1.6) we are facing below parsing exception in server level
[error] java.text.ParseException: inconsistent module descriptor file found in 'https://repo1.maven.org/maven2/commons-codec/commons-codec/20041127.091804/commons-codec-20041127.091804.pom': bad revision: expected='20041127.091804' found='1.3';

Please help us to resolve this issue.

Instead of parsing exception it should run in the server without any exception or error. This we are getting only after upgrading to latest jar


问:
Why the HttpSecurity API in Spring Security is designed as is?
In a Spring Boot project with Spring Security, I can configure the HTTP filter with the code below, where the /about endpoint is publicly accessible and the /myAccount endpoint requires authentication.

```<code>@Configuration
public class ProjectSecurityConfig {

    @Bean
    SecurityFilterChain defaultSecurityFilterChain(HttpSecurity http) throws Exception {
        http.authorizeHttpRequests()
                .requestMatchers("/myAccount").authenticated()
                .requestMatchers("/about").permitAll()
                .and().formLogin()
                .and().httpBasic();
        return http.build();
    }
}
</code>```

The chaining looks weird to me, especially the and method. My preferred API is something like:

```<code>@Configuration
public class ProjectSecurityConfig {

    @Bean
    SecurityFilterChain defaultSecurityFilterChain(HttpSecurity http) throws Exception {
        http.requireAuthentication(new RequestMatcher("/myAccount");
        http.permitAll(new RequestMatcher("/about");

        http.accept("FormLogin", "HttpBasic");

        return http.build();
    }
}
</code>```

Why is the API designed as is?

Body:
In a Spring Boot project with Spring Security, I can configure the HTTP filter with the code below, where the /about endpoint is publicly accessible and the /myAccount endpoint requires authentication.

@Configuration
public class ProjectSecurityConfig {

    @Bean
    SecurityFilterChain defaultSecurityFilterChain(HttpSecurity http) throws Exception {
        http.authorizeHttpRequests()
                .requestMatchers("/myAccount").authenticated()
                .requestMatchers("/about").permitAll()
                .and().formLogin()
                .and().httpBasic();
        return http.build();
    }
}

The chaining looks weird to me, especially the and method. My preferred API is something like:

@Configuration
public class ProjectSecurityConfig {

    @Bean
    SecurityFilterChain defaultSecurityFilterChain(HttpSecurity http) throws Exception {
        http.requireAuthentication(new RequestMatcher("/myAccount");
        http.permitAll(new RequestMatcher("/about");

        http.accept("FormLogin", "HttpBasic");

        return http.build();
    }
}

Why is the API designed as is?