Wednesday, 7 February 2018

Simple Query report

SELECT
    name,
vehicle_name as "Vehical Name:Data:120",
company_name as "Comapany Name:Data:120",
dealer_name as "Dealer Name:Data:120",
customer_name as "Customer Name:Data:120",
dealer_contact_deatail as "Dealer Contact Detail:Data:150",
customer_contact_details as "Customer Contact Detail:Data:150",
launch_date as "Launch Date:Data:120",
purchasing_date as "Purchasing Date:Data:120",
chasis_no as "Chasis No:Data:120",
licence_no as "Licence No:Data:120",
image as "Image:Data:120",
dealer_email_id as "Dealer Email Id:Data:120",
mail_id as "Mail Id Data:120",
vehicle_number as "Vehicle Number:Data:120",
uid_number as "Uid Number:Data:120",
time as "Time:Data:120",
city as "City:Data:120",
state as "State:Data:120"
from
tabBike

No comments:

Post a Comment

Django rest api - filter

views.py from django_filters.rest_framework import DjangoFilterBackend class PollList(viewsets.ModelViewSet):     queryset = X.objects...