The code looks like this:

public virtual string[] ToColumns(string alias, string propertyName)
        {
            //TODO: *two* hashmap lookups here is one too many...
            string[] columns = GetColumns(propertyName);

            string[] templates;
            formulaTemplatesByPropertyPath.TryGetValue(propertyName, out
templates);
            var result = new string[columns.Length];
            for (int i = 0; i < columns.Length; i++)
            {
                if (columns[i] == null)
*                    // Next line is LINE 58 in current master:*
                    result[i] = StringHelper.Replace(templates[i],
Template.Placeholder, alias);
                else
                    result[i] = StringHelper.Qualify(alias, columns[i]);
            }
            return result;
        }

So NRE could occur if templates is null because there is no check on return
value from formulaTemplatesByPropertyPath.TryGetValue(). Probably because
the intention/belief was that this would never happen, so the actual
problem could be elsewhere. Unless you know the code well, it would likely
be time consuming to debug this without a minimal reproducible test case.

/Oskar


2016-11-07 20:52 GMT+00:00 Taber Loveless <[email protected]>:

> Exception occurs BEFORE sql is emitted.
> The example query was produced by changing only the mapping to use column
> names instead of formulas
>
> Here is the stack with line numbers - Ill see if I cam make time to add a
> test case and provide link but it might take a few days:
>
>    at NHibernate.Persister.Entity.AbstractPropertyMapping.ToColumns(String
> alias, String propertyName) in c:\Projects\nhibernate-core\
> src\NHibernate\Persister\Entity\AbstractPropertyMapping.cs:line 58
>    at NHibernate.Persister.Entity.BasicEntityPropertyMapping.ToColumns(String
> alias, String propertyName) in c:\Projects\nhibernate-core\
> src\NHibernate\Persister\Entity\BasicEntityPropertyMapping.cs:line 31
>    at NHibernate.Persister.Entity.AbstractEntityPersister.ToColumns(String
> alias, String propertyName) in c:\Projects\nhibernate-core\
> src\NHibernate\Persister\Entity\AbstractEntityPersister.cs:line 1740
>    at NHibernate.Loader.Criteria.CriteriaQueryTranslator.GetColumns(ICriteria
> subcriteria, String propertyName) in c:\Projects\nhibernate-core\
> src\NHibernate\Loader\Criteria\CriteriaQueryTranslator.cs:line 587
>    at NHibernate.Loader.Criteria.CriteriaQueryTranslator.
> GetColumnsUsingProjection(ICriteria subcriteria, String propertyName) in
> c:\Projects\nhibernate-core\src\NHibernate\Loader\Criteria\
> CriteriaQueryTranslator.cs:line 547
>    at NHibernate.Loader.Criteria.CriteriaQueryTranslator.
> GetColumnsUsingProjection(ICriteria subcriteria, String propertyName) in
> c:\Projects\nhibernate-core\src\NHibernate\Loader\Criteria\
> CriteriaQueryTranslator.cs:line 554
>    at 
> NHibernate.Criterion.CriterionUtil.GetColumnNamesUsingPropertyName(ICriteriaQuery
> criteriaQuery, ICriteria criteria, String propertyName) in
> c:\Projects\nhibernate-core\src\NHibernate\Criterion\CriterionUtil.cs:line
> 64
>    at NHibernate.Criterion.CriterionUtil.GetColumnNames(String
> propertyName, IProjection projection, ICriteriaQuery criteriaQuery,
> ICriteria criteria, IDictionary`2 enabledFilters) in
> c:\Projects\nhibernate-core\src\NHibernate\Criterion\CriterionUtil.cs:line
> 20
>    at NHibernate.Criterion.PropertyExpression.ToSqlString(ICriteria
> criteria, ICriteriaQuery criteriaQuery, IDictionary`2 enabledFilters) in
> c:\Projects\nhibernate-core\src\NHibernate\Criterion\PropertyExpression.cs:line
> 76
>    at NHibernate.Loader.Criteria.CriteriaQueryTranslator.
> GetWhereCondition(IDictionary`2 enabledFilters) in
> c:\Projects\nhibernate-core\src\NHibernate\Loader\Criteria\
> CriteriaQueryTranslator.cs:line 204
>    at NHibernate.Loader.Criteria.CriteriaJoinWalker..ctor(IOuterJoinLoadable
> persister, CriteriaQueryTranslator translator, ISessionFactoryImplementor
> factory, ICriteria criteria, String rootEntityName, IDictionary`2
> enabledFilters) in c:\Projects\nhibernate-core\src\NHibernate\Loader\
> Criteria\CriteriaJoinWalker.cs:line 48
>    at NHibernate.Criterion.SubqueryExpression.ToSqlString(ICriteria
> criteria, ICriteriaQuery criteriaQuery, IDictionary`2 enabledFilters) in
> c:\Projects\nhibernate-core\src\NHibernate\Criterion\SubqueryExpression.cs:line
> 60
>    at NHibernate.Criterion.Junction.ToSqlString(ICriteria criteria,
> ICriteriaQuery criteriaQuery, IDictionary`2 enabledFilters) in
> c:\Projects\nhibernate-core\src\NHibernate\Criterion\Junction.cs:line 95
>    at NHibernate.Loader.Criteria.CriteriaQueryTranslator.
> GetWhereCondition(IDictionary`2 enabledFilters) in
> c:\Projects\nhibernate-core\src\NHibernate\Loader\Criteria\
> CriteriaQueryTranslator.cs:line 204
>    at NHibernate.Loader.Criteria.CriteriaJoinWalker..ctor(IOuterJoinLoadable
> persister, CriteriaQueryTranslator translator, ISessionFactoryImplementor
> factory, ICriteria criteria, String rootEntityName, IDictionary`2
> enabledFilters) in c:\Projects\nhibernate-core\src\NHibernate\Loader\
> Criteria\CriteriaJoinWalker.cs:line 48
>    at NHibernate.Loader.Criteria.CriteriaLoader..ctor(IOuterJoinLoadable
> persister, ISessionFactoryImplementor factory, CriteriaImpl rootCriteria,
> String rootEntityName, IDictionary`2 enabledFilters) in
> c:\Projects\nhibernate-core\src\NHibernate\Loader\
> Criteria\CriteriaLoader.cs:line 42
>    at NHibernate.Impl.MultiCriteriaImpl.CreateCriteriaLoaders() in
> c:\Projects\nhibernate-core\src\NHibernate\Impl\MultiCriteriaImpl.cs:line
> 305
>    at NHibernate.Impl.MultiCriteriaImpl.List() in
> c:\Projects\nhibernate-core\src\NHibernate\Impl\MultiCriteriaImpl.cs:line
> 67
>    at NHibernate.Impl.FutureCriteriaBatch.GetResultsFrom(IMultiCriteria
> multiApproach) in 
> c:\Projects\nhibernate-core\src\NHibernate\Impl\FutureCriteriaBatch.cs:line
> 24
>    at NHibernate.Impl.FutureBatch`2.GetResults() in
> c:\Projects\nhibernate-core\src\NHibernate\Impl\FutureBatch.cs:line 73
>    at NHibernate.Impl.FutureBatch`2.get_Results() in
> c:\Projects\nhibernate-core\src\NHibernate\Impl\FutureBatch.cs:line 29
>    at NHibernate.Impl.FutureBatch`2.GetCurrentResult[TResult](Int32
> currentIndex) in 
> c:\Projects\nhibernate-core\src\NHibernate\Impl\FutureBatch.cs:line
> 79
>    at 
> NHibernate.Impl.FutureBatch`2.<>c__DisplayClass1`1.<GetFutureValue>b__0()
> in c:\Projects\nhibernate-core\src\NHibernate\Impl\FutureBatch.cs:line 57
>    at NHibernate.Impl.FutureValue`1.get_Value() in
> c:\Projects\nhibernate-core\src\NHibernate\Impl\FutureValue.cs:line 22
>    at DriverTech.NH.Repositories.PagedResult`1.Paginate(IQueryOver`2
> queryOver, GridDataFilter filter) in C:\Projects\DriverTech\
> WebServices\FWAPI\DriverTech.NH\Repositories\PagedResult.cs:line 53
>    at DriverTech.NH.Repositories.LinqExtensions.Paginate[T](IQueryOver`2
> query, GridDataFilter filter) in C:\Projects\DriverTech\
> WebServices\FWAPI\DriverTech.NH\Repositories\LinqExtensions.cs:line 66
>    at DriverTech.NH.Repositories.Data.MessageRepository.<>c__
> DisplayClass1.<Get_Paged>b__0() in C:\Projects\DriverTech\
> WebServices\FWAPI\DriverTech.NH\Repositories\Data\MessageRepository.cs:line
> 54
>    at DriverTech.NH.Repositories.Repository`1.Transact[TResult](Func`1
> func, IsolationLevel isolationLevel) in C:\Projects\DriverTech\
> WebServices\FWAPI\DriverTech.NH\Repositories\RepositoryBase.cs:line 626
>    at 
> DriverTech.NH.Repositories.Data.MessageRepository.Get_Paged(GridDataFilter
> filter, Nullable`1 driverId, Nullable`1 vehicleId, Nullable`1
> viewInboundOnly, Nullable`1 viewReadOnly) in C:\Projects\DriverTech\
> WebServices\FWAPI\DriverTech.NH\Repositories\Data\MessageRepository.cs:line
> 54
>    at DriverTech.Execution.MessageProcessor.Process(PagedRequestForJQGrid
> pagedRequest, Nullable`1 driverId, Nullable`1 vehicleId, Nullable`1
> viewInboundOnly, Nullable`1 viewReadOnly, Int32& TotalRowCount) in
> C:\Projects\DriverTech\WebServices\FWAPI\DriverTech.
> Execution\MessageProcessor2.cs:line 103
>
>
>
>
> On Saturday, November 5, 2016 at 4:36:24 AM UTC-6, Oskar Berggren wrote:
>>
>>
>> > "Query which *should* be issued to sql server:"
>> So you are saying the the exception occurs BEFORE the query is emitted?
>> Or is the SQL you show exactly what NHibernate produced?
>>
>> I think it would be good if you also deploy the NHibernate.pdb file, so
>> we get line numbers in the stack trace.
>>
>> Also, can you create a minimized test case with the bare minimum to
>> reproduce the problem?
>>
>> /Oskar
>>
>>
>> 2016-11-01 18:20 GMT+00:00 Taber Loveless <[email protected]>:
>>
>>> Is this a bug or am I doing something wrong?
>>> QueryOver disjunction on Field mapped from Formula throws Object Null
>>> Exception but is field mapped normally it works
>>> Also, does not make a difference if I am Eager fetching or not and the
>>> actual query which would be issued to sql server does work
>>>
>>> *Message Mapping - *
>>> <hibernate-mapping xmlns="urn:nhibernate-mapping-2.2">
>>>   <class xmlns="urn:nhibernate-mapping-2.2" dynamic-update="true"
>>> name="DriverTech.NH.Entities.Message, DriverTech.NH,
>>> Version=1.0.4.19900, Culture=neutral, PublicKeyToken=null"
>>> table="DTECH_Msg">
>>>     <id name="Id" type="System.Int32, mscorlib, Version=4.0.0.0,
>>> Culture=neutral, PublicKeyToken=b77a5c561934e089">
>>>       <column name="msgID" />
>>>       <generator class="identity" />
>>>     </id>
>>>     <property name="MsgType" type="System.Int32, mscorlib,
>>> Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089">
>>>       <column name="msgType" />
>>>     </property>
>>>      SNIPPED
>>>     <many-to-one class="DriverTech.NH.Entities.TruckPCBase,
>>> DriverTech.NH, Version=1.0.4.19900, Culture=neutral, PublicKeyToken=null"
>>> name="TruckPCBase" not-found="ignore">
>>>       <column name="truckPCID" />
>>>     </many-to-one>
>>>     <many-to-one class="DriverTech.NH.Entities.DriverBase,
>>> DriverTech.NH, Version=1.0.4.19900, Culture=neutral, PublicKeyToken=null"
>>> name="DriverBase" not-found="ignore" formula=" CASE WHEN UserId = 0 THEN
>>> NULL ELSE UserId END " />
>>>     <many-to-one class="DriverTech.NH.Entities.ManagerBase,
>>> DriverTech.NH, Version=1.0.4.19900, Culture=neutral, PublicKeyToken=null"
>>> name="ReadByManager" not-found="ignore" formula=" CASE WHEN readManagerId
>>> &lt; 1 THEN NULL ELSE readManagerId END " />
>>>     <many-to-one class="DriverTech.NH.Entities.ManagerBase,
>>> DriverTech.NH, Version=1.0.4.19900, Culture=neutral, PublicKeyToken=null"
>>> name="FromManager" not-found="ignore">
>>>       <column name="fromManagerID" not-null="false" />
>>>     </many-to-one>
>>>     <many-to-one class="DriverTech.NH.Entities.ManagerBase,
>>> DriverTech.NH, Version=1.0.4.19900, Culture=neutral, PublicKeyToken=null"
>>> name="ToManager" not-found="ignore">
>>>       <column name="toManagerID" not-null="false" />
>>>     </many-to-one>
>>>   </class>
>>> </hibernate-mapping>
>>>
>>> *Code creating query over:*
>>>                 T typeAlias = null;
>>>
>>>                 var vehicleSubquery = NHibernate.Criterion.QueryOver
>>> .Of<ReportingGroupMembersDistinctByManager>()
>>>                     .Where(v => v.GroupType ==
>>> ReportingGroupType.Vehicle)
>>>                     .And(v => v.ManagerId == filter.PortalUserId)
>>>                     .And(v => v.RecordId == typeAlias.TruckPCBase.Id)
>>>                     .Select(Projections.Constant(0));
>>>
>>>                 var driverSubquery = NHibernate.Criterion.QueryOver
>>> .Of<ReportingGroupMembersDistinctByManager>()
>>>                     .Where(v => v.GroupType == ReportingGroupType.User)
>>>                     .And(v => v.ManagerId == filter.PortalUserId)
>>>                     .And(v => v.RecordId == typeAlias.DriverBase.Id)
>>>                     .Select(Projections.Constant(0));
>>>
>>>                 query = Session.QueryOver<T>(() => typeAlias)
>>>                     .Where(Restrictions.Disjunction()
>>>                         .Add(Subqueries.WhereExists(vehicleSubquery))
>>>                         .Add(Subqueries.WhereExists(driverSubquery)))
>>>                     ;
>>>
>>>
>>> *Exception stack:*
>>>
>>>    at NHibernate.Persister.Entity.AbstractPropertyMapping.ToColumns(String
>>> alias, String propertyName)
>>>    at 
>>> NHibernate.Persister.Entity.BasicEntityPropertyMapping.ToColumns(String
>>> alias, String propertyName)
>>>    at NHibernate.Persister.Entity.AbstractEntityPersister.ToColumns(String
>>> alias, String propertyName)
>>>    at 
>>> NHibernate.Loader.Criteria.CriteriaQueryTranslator.GetColumns(ICriteria
>>> subcriteria, String propertyName)
>>>    at 
>>> NHibernate.Loader.Criteria.CriteriaQueryTranslator.GetColumnsUsingProjection(ICriteria
>>> subcriteria, String propertyName)
>>>    at 
>>> NHibernate.Loader.Criteria.CriteriaQueryTranslator.GetColumnsUsingProjection(ICriteria
>>> subcriteria, String propertyName)
>>>    at 
>>> NHibernate.Criterion.CriterionUtil.GetColumnNamesUsingPropertyName(ICriteriaQuery
>>> criteriaQuery, ICriteria criteria, String propertyName)
>>>    at NHibernate.Criterion.CriterionUtil.GetColumnNames(String
>>> propertyName, IProjection projection, ICriteriaQuery criteriaQuery,
>>> ICriteria criteria, IDictionary`2 enabledFilters)
>>>    at NHibernate.Criterion.PropertyExpression.ToSqlString(ICriteria
>>> criteria, ICriteriaQuery criteriaQuery, IDictionary`2 enabledFilters)
>>>    at 
>>> NHibernate.Loader.Criteria.CriteriaQueryTranslator.GetWhereCondition(IDictionary`2
>>> enabledFilters)
>>>    at NHibernate.Loader.Criteria.CriteriaJoinWalker..ctor(IOuterJoinLoadable
>>> persister, CriteriaQueryTranslator translator, ISessionFactoryImplementor
>>> factory, ICriteria criteria, String rootEntityName, IDictionary`2
>>> enabledFilters)
>>>    at NHibernate.Criterion.SubqueryExpression.ToSqlString(ICriteria
>>> criteria, ICriteriaQuery criteriaQuery, IDictionary`2 enabledFilters)
>>>    at NHibernate.Criterion.Junction.ToSqlString(ICriteria criteria,
>>> ICriteriaQuery criteriaQuery, IDictionary`2 enabledFilters)
>>>    at 
>>> NHibernate.Loader.Criteria.CriteriaQueryTranslator.GetWhereCondition(IDictionary`2
>>> enabledFilters)
>>>    at NHibernate.Loader.Criteria.CriteriaJoinWalker..ctor(IOuterJoinLoadable
>>> persister, CriteriaQueryTranslator translator, ISessionFactoryImplementor
>>> factory, ICriteria criteria, String rootEntityName, IDictionary`2
>>> enabledFilters)
>>>    at NHibernate.Loader.Criteria.CriteriaLoader..ctor(IOuterJoinLoadable
>>> persister, ISessionFactoryImplementor factory, CriteriaImpl rootCriteria,
>>> String rootEntityName, IDictionary`2 enabledFilters)
>>>    at NHibernate.Impl.MultiCriteriaImpl.CreateCriteriaLoaders()
>>>    at NHibernate.Impl.MultiCriteriaImpl.List()
>>>    at NHibernate.Impl.FutureCriteriaBatch.GetResultsFrom(IMultiCriteria
>>> multiApproach)
>>>    at NHibernate.Impl.FutureBatch`2.GetResults()
>>>    at NHibernate.Impl.FutureBatch`2.get_Results()
>>>    at NHibernate.Impl.FutureBatch`2.GetCurrentResult[TResult](Int32
>>> currentIndex)
>>>    at NHibernate.Impl.FutureBatch`2.<>c__DisplayClass1`1.<GetFutur
>>> eValue>b__0()
>>>    at NHibernate.Impl.FutureValue`1.get_Value()
>>>    at DriverTech.NH.Repositories.PagedResult`1.Paginate(IQueryOver`2
>>> queryOver, GridDataFilter filter) in C:\Projects\DriverTech\WebServ
>>> ices\FWAPI\DriverTech.NH\Repositories\PagedResult.cs:line 53
>>>    at DriverTech.NH.Repositories.LinqExtensions.Paginate[T](IQueryOver`2
>>> query, GridDataFilter filter) in C:\Projects\DriverTech\WebServ
>>> ices\FWAPI\DriverTech.NH\Repositories\LinqExtensions.cs:line 66
>>>    at 
>>> DriverTech.NH.Repositories.Data.MessageRepository.<>c__DisplayClass1.<Get_Paged>b__0()
>>> in C:\Projects\DriverTech\WebServices\FWAPI\DriverTech.NH\
>>> Repositories\Data\MessageRepository.cs:line 96
>>>    at DriverTech.NH.Repositories.Repository`1.Transact[TResult](Func`1
>>> func, IsolationLevel isolationLevel) in C:\Projects\DriverTech\WebServ
>>> ices\FWAPI\DriverTech.NH\Repositories\RepositoryBase.cs:line 626
>>>    at 
>>> DriverTech.NH.Repositories.Data.MessageRepository.Get_Paged(GridDataFilter
>>> filter, Nullable`1 viewInboundOnly, Nullable`1 viewReadOnly) in
>>> C:\Projects\DriverTech\WebServices\FWAPI\DriverTech.NH\
>>> Repositories\Data\MessageRepository.cs:line 96
>>>    at DriverTech.Execution.MessageProcessor.Process(PagedRequestForJQGrid
>>> pagedRequest, Nullable`1 viewInboundOnly, Nullable`1 viewReadOnly, Int32&
>>> TotalRowCount) in C:\Projects\DriverTech\WebServ
>>> ices\FWAPI\DriverTech.Execution\MessageProcessor2.cs:line 97
>>>
>>>
>>> *Query which should be issued to sql server:*
>>> SELECT TOP (60 /* @p7 */) this_.msgID                      as
>>> msgID43_5_,
>>>                  this_.msgType                    as msgType43_5_,
>>>                  this_.iTime                      as iTime43_5_,
>>>                  this_.time                       as time43_5_,
>>>                  this_.bInbound                   as bInbound43_5_,
>>>                  this_.status                     as status43_5_,
>>>                  this_._to                        as column7_43_5_,
>>>                  this_._from                      as column8_43_5_,
>>>                  this_.subject                    as subject43_5_,
>>>                  this_.body                       as body43_5_,
>>>                  this_.rxTime                     as rxTime43_5_,
>>>                  this_.formID                     as formID43_5_,
>>>                  this_.stateID                    as stateID43_5_,
>>>                  this_.readTime                   as readTime43_5_,
>>>                  this_.priority                   as priority43_5_,
>>>                  this_.transport                  as transport43_5_,
>>>                  this_.bWantReceipt               as bWantRe17_43_5_,
>>>                  this_.receiptTime                as receipt18_43_5_,
>>>                  this_.iCustomerLink              as iCustom19_43_5_,
>>>                  this_.szCustomerLink             as szCusto20_43_5_,
>>>                  this_.bVolumeOverride            as bVolume21_43_5_,
>>>                  this_.replyID                    as replyID43_5_,
>>>                  this_.bImportant                 as bImportant43_5_,
>>>                  this_.DataXml                    as DataXml43_5_,
>>>                  this_.bHasAttachment             as bHasAtt25_43_5_,
>>>                  this_.fromManagerID              as fromMan26_43_5_,
>>>                  this_.toManagerID                as toManag27_43_5_,
>>>                  CASE
>>>                    WHEN this_.truckPCID < 1 THEN NULL
>>>                    ELSE this_.truckPCID
>>>                  END                              as formula3_5_,
>>>                  CASE
>>>                    WHEN this_.UserId = 0 THEN NULL
>>>                    ELSE this_.UserId
>>>                  END                              as formula4_5_,
>>>                  CASE
>>>                    WHEN this_.readManagerId < 1 THEN NULL
>>>                    ELSE this_.readManagerId
>>>                  END                              as formula5_5_,
>>>                  truckpcbas2_.truckPCID           as truckPCID71_0_,
>>>                  truckpcbas2_.truckName           as truckName71_0_,
>>>                  driverbase3_.userID              as userID25_1_,
>>>                  driverbase3_.employeeID          as employeeID25_1_,
>>>                  driverbase3_.logon               as logon25_1_,
>>>                  driverbase3_.driverName          as driverName25_1_,
>>>                  driverbase3_.bDeleted            as bDeleted25_1_,
>>>                  driverbase3_.timezone            as timezone25_1_,
>>>                  driverbase3_.buseDaylightSavings as buseDayl7_25_1_,
>>>                  managerbas4_.ManagerId           as ManagerId40_2_,
>>>                  managerbas4_.Login               as Login40_2_,
>>>                  managerbas4_.Name                as Name40_2_,
>>>                  managerbas5_.ManagerId           as ManagerId40_3_,
>>>                  managerbas5_.Login               as Login40_3_,
>>>                  managerbas5_.Name                as Name40_3_,
>>>                  managerbas6_.ManagerId           as ManagerId40_4_,
>>>                  managerbas6_.Login               as Login40_4_,
>>>                  managerbas6_.Name                as Name40_4_
>>> FROM   dbo.DTECH_Msg this_
>>>        left outer join dbo.vwVehicleSimple truckpcbas2_
>>>          on CASE
>>>               WHEN this_.truckPCID < 1 THEN NULL
>>>               ELSE this_.truckPCID
>>>             END = truckpcbas2_.truckPCID
>>>        left outer join dbo.vwDriverSimple driverbase3_
>>>          on CASE
>>>               WHEN this_.UserId = 0 THEN NULL
>>>               ELSE this_.UserId
>>>             END = driverbase3_.userID
>>>        left outer join dbo.DTECH_Managers managerbas4_
>>>          on CASE
>>>               WHEN this_.readManagerId < 1 THEN NULL
>>>               ELSE this_.readManagerId
>>>             END = managerbas4_.ManagerId
>>>        left outer join dbo.DTECH_Managers managerbas5_
>>>          on this_.fromManagerID = managerbas5_.ManagerId
>>>        left outer join dbo.DTECH_Managers managerbas6_
>>>          on this_.toManagerID = managerbas6_.ManagerId
>>> WHERE
>>> (exists (
>>>                /* criteria query */ SELECT 0 /* @p0 */ as y0_
>>>                 FROM   dbo.vwReportingGroupsMembers_GetDistinctByManagerId
>>> this_0_
>>>                 WHERE  this_0_.GroupType = 1 /* @p1 */
>>>                        and this_0_.ManagerId = 34 /* @p2 */
>>>                        and this_0_.RecordId = this_.truckPCID)
>>>          or exists (
>>>                    /* criteria query */ SELECT 0 /* @p3 */ as y0_
>>>                     FROM   
>>> dbo.vwReportingGroupsMembers_GetDistinctByManagerId
>>> this_0_
>>>                     WHERE  this_0_.GroupType = 0 /* @p4 */
>>>                            and this_0_.ManagerId = 34 /* @p5 */
>>>                            and this_0_.RecordId = this_.userID))
>>>  and(this_.msgType = 1 /* @p8 */
>>>          or this_.msgType = 10 /* @p9 */)
>>>        and this_.bInbound = 1 /* @p10 */
>>>        and (((this_.bInbound = 1 /* @p11 */
>>>               and this_.readTime is null)
>>>               or ((this_.bInbound = 0 /* @p12 */
>>>                    and this_.receiptTime is null)
>>>                   and this_.bWantReceipt = 1 /* @p13 */))
>>>              or (this_.bInbound = 0 /* @p14 */
>>>                  and this_.rxTime is null));
>>>
>>> --
>>> You received this message because you are subscribed to the Google
>>> Groups "nhusers" group.
>>> To unsubscribe from this group and stop receiving emails from it, send
>>> an email to [email protected].
>>> To post to this group, send email to [email protected].
>>> Visit this group at https://groups.google.com/group/nhusers.
>>> For more options, visit https://groups.google.com/d/optout.
>>>
>>
>> --
> You received this message because you are subscribed to the Google Groups
> "nhusers" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to [email protected].
> To post to this group, send email to [email protected].
> Visit this group at https://groups.google.com/group/nhusers.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
You received this message because you are subscribed to the Google Groups 
"nhusers" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/nhusers.
For more options, visit https://groups.google.com/d/optout.

Reply via email to