{"recNo":5602,"appUser_recNo":10549,"area":"tripSearch_config","name":"config","selectedRecNo":18514,"mainRecNo":null,"viewList":[{"recNo":18770,"name":"Clients without bookings in past 2 years","orderId":1,"isDefault":null,"isSelected":false,"isMain":false,"isDisplayInReportMenu":false,"categoryName":null,"reportOutputFormat":null,"isAgencyLevel":true,"sortColumn":"reservationStartDateTime","sortDirection":"asc","searchAreaViewType":null,"reportFormat":true,"appUser_recNo":null,"columns":[{"recNo":101,"header":"All","width":"50px","orderId":0,"entityRecNo":null,"entityName":null,"name":null,"displayName":null,"queryFlags":null,"alignment":null,"hyperlinkUrl":null,"aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"isSelected","columnType":"CheckBox","isHidden":true,"isIncluded":true},{"recNo":2,"header":"Trip Client","width":null,"orderId":1,"entityRecNo":null,"entityName":null,"name":null,"displayName":"Client Name","queryFlags":0,"alignment":null,"hyperlinkUrl":"{baseUrl}/client-profiles/detail/{clientProfileRecNo}","aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"clientProfileName","isIncluded":true,"isDefault":true,"defaultOrderId":2},{"recNo":53,"header":"Trip Client Profile RecNo","width":null,"orderId":2,"entityRecNo":null,"entityName":null,"name":null,"displayName":null,"queryFlags":64,"alignment":null,"hyperlinkUrl":null,"aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"clientProfileRecNo","isIncluded":true,"isDefault":true,"defaultOrderId":53},{"recNo":52,"header":"Summary Count","width":null,"orderId":3,"entityRecNo":null,"entityName":null,"name":null,"displayName":"No of Trips","queryFlags":16,"alignment":null,"hyperlinkUrl":null,"aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"summaryCount","isIncluded":true,"isDefault":true,"defaultOrderId":52},{"recNo":30,"header":"Reservation Total Fare","width":null,"orderId":4,"entityRecNo":null,"entityName":null,"name":null,"displayName":"Trip Total Fare","queryFlags":16,"alignment":null,"hyperlinkUrl":null,"aggregate":7,"calc":0,"tagRecNo":null,"sortDirection":2,"sortIndex":1,"widthPercentage":null,"columnDef":"reservationTotalFare","isIncluded":true,"isDefault":true,"defaultOrderId":30,"colPipeArgs":"","alignRight":true,"doAlighRight":true},{"recNo":31,"header":"Reservation Commission Amount","width":null,"orderId":5,"entityRecNo":null,"entityName":null,"name":null,"displayName":"Commission","queryFlags":24,"alignment":null,"hyperlinkUrl":null,"aggregate":7,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"reservationCommissionAmount","isIncluded":true,"isDefault":true,"defaultOrderId":31,"colPipeArgs":"","alignRight":true,"doAlighRight":true},{"recNo":1,"header":"Trip Name","width":null,"orderId":6,"entityRecNo":null,"entityName":null,"name":null,"displayName":"Trip Name","queryFlags":0,"alignment":null,"hyperlinkUrl":"{baseUrl}/trips/detail/{recNo}","aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"name","isIncluded":true,"isDefault":true,"defaultOrderId":1},{"recNo":49,"header":"Trip Number","width":null,"orderId":7,"entityRecNo":null,"entityName":null,"name":null,"displayName":null,"queryFlags":64,"alignment":null,"hyperlinkUrl":null,"aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"recNo","isIncluded":true,"isDefault":true,"defaultOrderId":49},{"recNo":5,"header":"Trip Start Date","width":null,"orderId":8,"entityRecNo":null,"entityName":null,"name":null,"displayName":"Depart Date","queryFlags":0,"alignment":null,"hyperlinkUrl":null,"aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"startDateTime","colPipeArgs":"","isIncluded":true,"isDefault":true,"defaultOrderId":5},{"recNo":55,"header":"Trip Advisor Profile RecNo","width":null,"orderId":9,"entityRecNo":null,"entityName":null,"name":null,"displayName":null,"queryFlags":64,"alignment":null,"hyperlinkUrl":null,"aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"advisorProfileRecNo","isIncluded":true,"isDefault":true,"defaultOrderId":55},{"recNo":4,"header":"Trip Advisor","width":null,"orderId":10,"entityRecNo":null,"entityName":null,"name":null,"displayName":"Advisor","queryFlags":0,"alignment":null,"hyperlinkUrl":"{baseUrl}/advisor-profiles/detail/{advisorProfileRecNo}","aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"advisorProfileName","isIncluded":true,"isDefault":true,"defaultOrderId":4},{"recNo":24,"header":"Trip Destination","width":null,"orderId":11,"entityRecNo":null,"entityName":null,"name":null,"displayName":"Destination","queryFlags":0,"alignment":null,"hyperlinkUrl":null,"aggregate":null,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"destinationName","isIncluded":true,"isDefault":true,"defaultOrderId":24},{"recNo":30,"header":"Reservation Total Fare","width":null,"orderId":12,"entityRecNo":null,"entityName":null,"name":null,"displayName":"Trip Total Fare","queryFlags":16,"alignment":null,"hyperlinkUrl":null,"aggregate":1,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"reservationTotalFare","isIncluded":true,"isDefault":true,"defaultOrderId":30,"colPipeArgs":"","alignRight":true,"doAlighRight":true},{"recNo":31,"header":"Reservation Commission Amount","width":null,"orderId":13,"entityRecNo":null,"entityName":null,"name":null,"displayName":"Commission","queryFlags":16,"alignment":null,"hyperlinkUrl":null,"aggregate":1,"calc":0,"tagRecNo":null,"sortDirection":0,"sortIndex":null,"widthPercentage":null,"columnDef":"reservationCommissionAmount","isIncluded":true,"isDefault":true,"defaultOrderId":31,"colPipeArgs":"","alignRight":true,"doAlighRight":true}],"filters":[{"recNo":3,"type":"LookupFilter","moduleForLookup":"ClientProfile","field":"clientProfileRecNo","label":"Trip Client","isIncluded":true,"filterArea":5,"filterFieldList":[{"label":"Client","placeHolder":"Reservation Provider","field":"clientProfileRecNo","filterOperatorType":1,"type":"MultiLookupFilter","moduleForLookup":"ClientProfile","doAutofocus":true,"doClick":true,"isRequired":true,"displayText":"","value":{"trimString":null,"compareCondition":1,"value":[],"minValue":null,"maxValue":null}}]}],"filterSets":[{"isIncludeOrExclude":false,"filters":[{"recNo":37,"label":"Reservation Booking Date Range","filterArea":5,"filterFieldList":[{"recNo":0,"field":"reservationBookDateTimeFrom","label":"Reservation Booking Date Range","value":{"day":null,"dayOfWeek":null,"dayOffset":null,"month":null,"monthOffset":null,"year":null,"yearOffset":null,"compareCondition":1,"text":"=0,-24,0","relativeDate":null,"date":null,"trimString":null},"type":"DateRangeOperator","placeHolder":"Reservation Booking Date Range","displayText":"=0,-24,0"},{"recNo":0,"field":"reservationBookDateTimeTo","label":"Reservation Booking Date Range","value":{"day":null,"dayOfWeek":null,"dayOffset":null,"month":null,"monthOffset":null,"year":null,"yearOffset":null,"compareCondition":null,"text":"=0,0,0","relativeDate":null,"date":null,"trimString":null,"time":"23:59:59.9999999","dateTimeUTC":null},"type":"DateRangeOperatorHidden","placeHolder":"Reservation Booking Date Range","displayText":"=0,0,0"}]}]}]}]}