1fsOperators log
{ts '2025-01-03 13:29:26'} SQL
declare @ownerId int = ?;
    declare @ownerType varchar(3) = ?;

    with clientSegmentsRaw as (

		select clientSegId, segmentId, row_number() over ( partition by segmentId order by segmentPath ) ranking
		  from tbl_OPR_ClientSegments cs with (nolock)
		  where cs.ownerId = @ownerId
		  and cs.fsl_tablecode = @ownerType
		  and segmentId > 0

	),

    clientSegments as (
        select clientSegId, segmentId
          from clientSegmentsRaw with (nolock)
          where ranking = 1
    ),


    data as (

        select c.cho_id, c.cho_type, c.cho_name, c.cho_address, c.cho_city, c.cho_state, c.cho_zipCode, c.cho_countryId, 
            c.cho_segmentId, nullif( c.cho_url, '' ) cho_url, nullif( c.cho_phone, '' ) cho_phone,
        o.operatorId, t.territoryId, t.name as territoryName, t.territoryPath, o.crmActive,

        case when o.operatorId is not null then o.oprSegment else cs.clientSegId end clientSegId

        from tbl_cho_operators c with (nolock)
        
        left outer join tbl_OPR_ClientOperators o with (nolock)
            on o.ownerId = @ownerId
            and o.fsltablecode = @ownerType
            and o.fsl_choId = c.cho_id
            and o.territoryId > 0
        left outer join tbl_TER_Territories t with (nolock)
            on t.ownerId = o.ownerId
            and t.fsl_tablecode = o.fsltablecode
            and t.territoryId = o.territoryId
        left outer join clientSegments cs with (nolock)
           on cs.segmentId = c.cho_segmentId
        where coalesce(c.cho_acctclosed,'0') <> '1'
          and c.cho_name not like 'Insufficient%'

          
         and ( o.territoryId is null or o.territoryId in ( 11237 ))
          
            and c.cho_state in ( 'NC ','NY ','OH ','PA ','WV ' )
        
    )

    


, data_mappedData as (

	select *
		
	  from data

)

, data_preData as (

	
	select *
	  from data_mappedData with (nolock)

	
	
	where 

	(
	

	(
	[cho_name]
							
					like '%Dudle%' 	
	)
and 

	(
	[cho_countryId]
							= '27' 	
	)
and 

	(
	

	(
	[cho_type]
							= 'O' 	
	)
or 

	(
	[cho_type]
							= 'I' 	
	)
	
	)
	
	)



	)

	, data_data as (

		select * 
		        
		  from data_preData
		  

	)



	, data_return as (
		select * from data_data
		where 1 = 1


	order by cho_name
		
		
		 offset 0 rows fetch next 25 rows only
	
	)

	
	, data_result as (
		select ( select count(*) from data_data ) as totalCount, 
			   
		       ( select * from data_return for json auto, include_null_values ) as data
		)


	select * from data_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 2358
-- BRO

{ts '2025-01-03 13:30:06'} SQL
declare @ownerId int = ?;
    declare @ownerType varchar(3) = ?;

    with clientSegmentsRaw as (

		select clientSegId, segmentId, row_number() over ( partition by segmentId order by segmentPath ) ranking
		  from tbl_OPR_ClientSegments cs with (nolock)
		  where cs.ownerId = @ownerId
		  and cs.fsl_tablecode = @ownerType
		  and segmentId > 0

	),

    clientSegments as (
        select clientSegId, segmentId
          from clientSegmentsRaw with (nolock)
          where ranking = 1
    ),


    data as (

        select c.cho_id, c.cho_type, c.cho_name, c.cho_address, c.cho_city, c.cho_state, c.cho_zipCode, c.cho_countryId, 
            c.cho_segmentId, nullif( c.cho_url, '' ) cho_url, nullif( c.cho_phone, '' ) cho_phone,
        o.operatorId, t.territoryId, t.name as territoryName, t.territoryPath, o.crmActive,

        case when o.operatorId is not null then o.oprSegment else cs.clientSegId end clientSegId

        from tbl_cho_operators c with (nolock)
        
        left outer join tbl_OPR_ClientOperators o with (nolock)
            on o.ownerId = @ownerId
            and o.fsltablecode = @ownerType
            and o.fsl_choId = c.cho_id
            and o.territoryId > 0
        left outer join tbl_TER_Territories t with (nolock)
            on t.ownerId = o.ownerId
            and t.fsl_tablecode = o.fsltablecode
            and t.territoryId = o.territoryId
        left outer join clientSegments cs with (nolock)
           on cs.segmentId = c.cho_segmentId
        where coalesce(c.cho_acctclosed,'0') <> '1'
          and c.cho_name not like 'Insufficient%'

          
         and ( o.territoryId is null or o.territoryId in ( 11151 ))
          
             and left(c.cho_zipcode,3) in ( '496','498','483','493','492','499','485','480','490','487','486','497','482','494','489','495','491','481','488','484' )
        
    )

    


, data_mappedData as (

	select *
		
	  from data

)

, data_preData as (

	
	select *
	  from data_mappedData with (nolock)

	
	
	where 

	(
	

	(
	[cho_name]
							
					like '%Dudley%' 	
	)
and 

	(
	[cho_countryId]
							= '27' 	
	)
and 

	(
	

	(
	[cho_type]
							= 'O' 	
	)
or 

	(
	[cho_type]
							= 'I' 	
	)
	
	)
	
	)



	)

	, data_data as (

		select * 
		        
		  from data_preData
		  

	)



	, data_return as (
		select * from data_data
		where 1 = 1


	order by cho_name
		
		
		 offset 0 rows fetch next 25 rows only
	
	)

	
	, data_result as (
		select ( select count(*) from data_data ) as totalCount, 
			   
		       ( select * from data_return for json auto, include_null_values ) as data
		)


	select * from data_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 2358
-- BRO

{ts '2025-01-03 13:30:51'} SQL
declare @ownerId int = ?;
    declare @ownerType varchar(3) = ?;

    with clientSegmentsRaw as (

		select clientSegId, segmentId, row_number() over ( partition by segmentId order by segmentPath ) ranking
		  from tbl_OPR_ClientSegments cs with (nolock)
		  where cs.ownerId = @ownerId
		  and cs.fsl_tablecode = @ownerType
		  and segmentId > 0

	),

    clientSegments as (
        select clientSegId, segmentId
          from clientSegmentsRaw with (nolock)
          where ranking = 1
    ),


    data as (

        select c.cho_id, c.cho_type, c.cho_name, c.cho_address, c.cho_city, c.cho_state, c.cho_zipCode, c.cho_countryId, 
            c.cho_segmentId, nullif( c.cho_url, '' ) cho_url, nullif( c.cho_phone, '' ) cho_phone,
        o.operatorId, t.territoryId, t.name as territoryName, t.territoryPath, o.crmActive,

        case when o.operatorId is not null then o.oprSegment else cs.clientSegId end clientSegId

        from tbl_cho_operators c with (nolock)
        
        left outer join tbl_OPR_ClientOperators o with (nolock)
            on o.ownerId = @ownerId
            and o.fsltablecode = @ownerType
            and o.fsl_choId = c.cho_id
            and o.territoryId > 0
        left outer join tbl_TER_Territories t with (nolock)
            on t.ownerId = o.ownerId
            and t.fsl_tablecode = o.fsltablecode
            and t.territoryId = o.territoryId
        left outer join clientSegments cs with (nolock)
           on cs.segmentId = c.cho_segmentId
        where coalesce(c.cho_acctclosed,'0') <> '1'
          and c.cho_name not like 'Insufficient%'

          
         and ( o.territoryId is null or o.territoryId in ( 11240 ))
          
            and c.cho_state in ( 'IL ','IN ','KY ','MI ','OH ','WI ' )
        
    )

    


, data_mappedData as (

	select *
		
	  from data

)

, data_preData as (

	
	select *
	  from data_mappedData with (nolock)

	
	
	where 

	(
	

	(
	[cho_name]
							
					like '%Dudley%' 	
	)
and 

	(
	[cho_countryId]
							= '27' 	
	)
and 

	(
	

	(
	[cho_type]
							= 'O' 	
	)
or 

	(
	[cho_type]
							= 'I' 	
	)
	
	)
	
	)



	)

	, data_data as (

		select * 
		        
		  from data_preData
		  

	)



	, data_return as (
		select * from data_data
		where 1 = 1


	order by cho_name
		
		
		 offset 0 rows fetch next 25 rows only
	
	)

	
	, data_result as (
		select ( select count(*) from data_data ) as totalCount, 
			   
		       ( select * from data_return for json auto, include_null_values ) as data
		)


	select * from data_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 2358
-- BRO

{ts '2025-01-03 13:39:34'} SQL
declare @ownerId int = ?;
    declare @ownerType varchar(3) = ?;

    with clientSegmentsRaw as (

		select clientSegId, segmentId, row_number() over ( partition by segmentId order by segmentPath ) ranking
		  from tbl_OPR_ClientSegments cs with (nolock)
		  where cs.ownerId = @ownerId
		  and cs.fsl_tablecode = @ownerType
		  and segmentId > 0

	),

    clientSegments as (
        select clientSegId, segmentId
          from clientSegmentsRaw with (nolock)
          where ranking = 1
    ),


    data as (

        select c.cho_id, c.cho_type, c.cho_name, c.cho_address, c.cho_city, c.cho_state, c.cho_zipCode, c.cho_countryId, 
            c.cho_segmentId, nullif( c.cho_url, '' ) cho_url, nullif( c.cho_phone, '' ) cho_phone,
        o.operatorId, t.territoryId, t.name as territoryName, t.territoryPath, o.crmActive,

        case when o.operatorId is not null then o.oprSegment else cs.clientSegId end clientSegId

        from tbl_cho_operators c with (nolock)
        
        left outer join tbl_OPR_ClientOperators o with (nolock)
            on o.ownerId = @ownerId
            and o.fsltablecode = @ownerType
            and o.fsl_choId = c.cho_id
            and o.territoryId > 0
        left outer join tbl_TER_Territories t with (nolock)
            on t.ownerId = o.ownerId
            and t.fsl_tablecode = o.fsltablecode
            and t.territoryId = o.territoryId
        left outer join clientSegments cs with (nolock)
           on cs.segmentId = c.cho_segmentId
        where coalesce(c.cho_acctclosed,'0') <> '1'
          and c.cho_name not like 'Insufficient%'

          
         and ( o.territoryId is null or o.territoryId in ( 11240 ))
          
            and c.cho_state in ( 'IL ','IN ','KY ','MI ','OH ','WI ' )
        
    )

    


, data_mappedData as (

	select *
		
	  from data

)

, data_preData as (

	
	select *
	  from data_mappedData with (nolock)

	
	
	where 

	(
	

	(
	[cho_name]
							
					like '%G?s Pizza World%' 	
	)
and 

	(
	[cho_countryId]
							= '27' 	
	)
and 

	(
	

	(
	[cho_type]
							= 'O' 	
	)
or 

	(
	[cho_type]
							= 'I' 	
	)
	
	)
	
	)



	)

	, data_data as (

		select * 
		        
		  from data_preData
		  

	)



	, data_return as (
		select * from data_data
		where 1 = 1


	order by cho_name
		
		
		 offset 0 rows fetch next 25 rows only
	
	)

	
	, data_result as (
		select ( select count(*) from data_data ) as totalCount, 
			   
		       ( select * from data_return for json auto, include_null_values ) as data
		)


	select * from data_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 2358
-- BRO

{ts '2025-01-03 13:39:38'} SQL
declare @ownerId int = ?;
    declare @ownerType varchar(3) = ?;

    with clientSegmentsRaw as (

		select clientSegId, segmentId, row_number() over ( partition by segmentId order by segmentPath ) ranking
		  from tbl_OPR_ClientSegments cs with (nolock)
		  where cs.ownerId = @ownerId
		  and cs.fsl_tablecode = @ownerType
		  and segmentId > 0

	),

    clientSegments as (
        select clientSegId, segmentId
          from clientSegmentsRaw with (nolock)
          where ranking = 1
    ),


    data as (

        select c.cho_id, c.cho_type, c.cho_name, c.cho_address, c.cho_city, c.cho_state, c.cho_zipCode, c.cho_countryId, 
            c.cho_segmentId, nullif( c.cho_url, '' ) cho_url, nullif( c.cho_phone, '' ) cho_phone,
        o.operatorId, t.territoryId, t.name as territoryName, t.territoryPath, o.crmActive,

        case when o.operatorId is not null then o.oprSegment else cs.clientSegId end clientSegId

        from tbl_cho_operators c with (nolock)
        
        left outer join tbl_OPR_ClientOperators o with (nolock)
            on o.ownerId = @ownerId
            and o.fsltablecode = @ownerType
            and o.fsl_choId = c.cho_id
            and o.territoryId > 0
        left outer join tbl_TER_Territories t with (nolock)
            on t.ownerId = o.ownerId
            and t.fsl_tablecode = o.fsltablecode
            and t.territoryId = o.territoryId
        left outer join clientSegments cs with (nolock)
           on cs.segmentId = c.cho_segmentId
        where coalesce(c.cho_acctclosed,'0') <> '1'
          and c.cho_name not like 'Insufficient%'

          
         and ( o.territoryId is null or o.territoryId in ( 11240 ))
          
            and c.cho_state in ( 'IL ','IN ','KY ','MI ','OH ','WI ' )
        
    )

    


, data_mappedData as (

	select *
		
	  from data

)

, data_preData as (

	
	select *
	  from data_mappedData with (nolock)

	
	
	where 

	(
	

	(
	[cho_name]
							
					like '%G?s Pizza World%' 	
	)
and 

	(
	[cho_countryId]
							= '27' 	
	)
and 

	(
	

	(
	[cho_type]
							= 'O' 	
	)
or 

	(
	[cho_type]
							= 'I' 	
	)
or 

	(
	[cho_type]
							= 'U' 	
	)
	
	)
	
	)



	)

	, data_data as (

		select * 
		        
		  from data_preData
		  

	)



	, data_return as (
		select * from data_data
		where 1 = 1


	order by cho_name
		
		
		 offset 0 rows fetch next 25 rows only
	
	)

	
	, data_result as (
		select ( select count(*) from data_data ) as totalCount, 
			   
		       ( select * from data_return for json auto, include_null_values ) as data
		)


	select * from data_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 2358
-- BRO

{ts '2025-01-03 13:39:43'} SQL
declare @ownerId int = ?;
    declare @ownerType varchar(3) = ?;

    with clientSegmentsRaw as (

		select clientSegId, segmentId, row_number() over ( partition by segmentId order by segmentPath ) ranking
		  from tbl_OPR_ClientSegments cs with (nolock)
		  where cs.ownerId = @ownerId
		  and cs.fsl_tablecode = @ownerType
		  and segmentId > 0

	),

    clientSegments as (
        select clientSegId, segmentId
          from clientSegmentsRaw with (nolock)
          where ranking = 1
    ),


    data as (

        select c.cho_id, c.cho_type, c.cho_name, c.cho_address, c.cho_city, c.cho_state, c.cho_zipCode, c.cho_countryId, 
            c.cho_segmentId, nullif( c.cho_url, '' ) cho_url, nullif( c.cho_phone, '' ) cho_phone,
        o.operatorId, t.territoryId, t.name as territoryName, t.territoryPath, o.crmActive,

        case when o.operatorId is not null then o.oprSegment else cs.clientSegId end clientSegId

        from tbl_cho_operators c with (nolock)
        
        left outer join tbl_OPR_ClientOperators o with (nolock)
            on o.ownerId = @ownerId
            and o.fsltablecode = @ownerType
            and o.fsl_choId = c.cho_id
            and o.territoryId > 0
        left outer join tbl_TER_Territories t with (nolock)
            on t.ownerId = o.ownerId
            and t.fsl_tablecode = o.fsltablecode
            and t.territoryId = o.territoryId
        left outer join clientSegments cs with (nolock)
           on cs.segmentId = c.cho_segmentId
        where coalesce(c.cho_acctclosed,'0') <> '1'
          and c.cho_name not like 'Insufficient%'

          
         and ( o.territoryId is null or o.territoryId in ( 11240 ))
          
            and c.cho_state in ( 'IL ','IN ','KY ','MI ','OH ','WI ' )
        
    )

    


, data_mappedData as (

	select *
		
	  from data

)

, data_preData as (

	
	select *
	  from data_mappedData with (nolock)

	
	
	where 

	(
	

	(
	[cho_name]
							
					like '%Duley%' 	
	)
and 

	(
	[cho_countryId]
							= '27' 	
	)
and 

	(
	

	(
	[cho_type]
							= 'O' 	
	)
or 

	(
	[cho_type]
							= 'I' 	
	)
or 

	(
	[cho_type]
							= 'U' 	
	)
	
	)
	
	)



	)

	, data_data as (

		select * 
		        
		  from data_preData
		  

	)



	, data_return as (
		select * from data_data
		where 1 = 1


	order by cho_name
		
		
		 offset 0 rows fetch next 25 rows only
	
	)

	
	, data_result as (
		select ( select count(*) from data_data ) as totalCount, 
			   
		       ( select * from data_return for json auto, include_null_values ) as data
		)


	select * from data_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 2358
-- BRO

{ts '2025-01-03 13:39:45'} SQL
declare @ownerId int = ?;
    declare @ownerType varchar(3) = ?;

    with clientSegmentsRaw as (

		select clientSegId, segmentId, row_number() over ( partition by segmentId order by segmentPath ) ranking
		  from tbl_OPR_ClientSegments cs with (nolock)
		  where cs.ownerId = @ownerId
		  and cs.fsl_tablecode = @ownerType
		  and segmentId > 0

	),

    clientSegments as (
        select clientSegId, segmentId
          from clientSegmentsRaw with (nolock)
          where ranking = 1
    ),


    data as (

        select c.cho_id, c.cho_type, c.cho_name, c.cho_address, c.cho_city, c.cho_state, c.cho_zipCode, c.cho_countryId, 
            c.cho_segmentId, nullif( c.cho_url, '' ) cho_url, nullif( c.cho_phone, '' ) cho_phone,
        o.operatorId, t.territoryId, t.name as territoryName, t.territoryPath, o.crmActive,

        case when o.operatorId is not null then o.oprSegment else cs.clientSegId end clientSegId

        from tbl_cho_operators c with (nolock)
        
        left outer join tbl_OPR_ClientOperators o with (nolock)
            on o.ownerId = @ownerId
            and o.fsltablecode = @ownerType
            and o.fsl_choId = c.cho_id
            and o.territoryId > 0
        left outer join tbl_TER_Territories t with (nolock)
            on t.ownerId = o.ownerId
            and t.fsl_tablecode = o.fsltablecode
            and t.territoryId = o.territoryId
        left outer join clientSegments cs with (nolock)
           on cs.segmentId = c.cho_segmentId
        where coalesce(c.cho_acctclosed,'0') <> '1'
          and c.cho_name not like 'Insufficient%'

          
         and ( o.territoryId is null or o.territoryId in ( 11240 ))
          
            and c.cho_state in ( 'IL ','IN ','KY ','MI ','OH ','WI ' )
        
    )

    


, data_mappedData as (

	select *
		
	  from data

)

, data_preData as (

	
	select *
	  from data_mappedData with (nolock)

	
	
	where 

	(
	

	(
	[cho_name]
							
					like '%Dudley%' 	
	)
and 

	(
	[cho_countryId]
							= '27' 	
	)
and 

	(
	

	(
	[cho_type]
							= 'O' 	
	)
or 

	(
	[cho_type]
							= 'I' 	
	)
or 

	(
	[cho_type]
							= 'U' 	
	)
	
	)
	
	)



	)

	, data_data as (

		select * 
		        
		  from data_preData
		  

	)



	, data_return as (
		select * from data_data
		where 1 = 1


	order by cho_name
		
		
		 offset 0 rows fetch next 25 rows only
	
	)

	
	, data_result as (
		select ( select count(*) from data_data ) as totalCount, 
			   
		       ( select * from data_return for json auto, include_null_values ) as data
		)


	select * from data_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 2358
-- BRO