{
"searchText": "KH2208050957WKPFJ",
"filedList": [
"customer_full_name",
"project_name",
"related_party_name",
"related_party_number",
"salesman_name",
"number",
"salesman_name",
"depart_name",
"project_industry_name",
"project_type_name",
"project_type_top_name",
"customer_number"
],
"sortingColumn": "create_time",
"sortingColumnType": "timestamp",
"sortingType": "2",
"sqlConditionList": [
{
"columnName": "create_time",
"condition": ">=",
"keywordList": [
"2025-01-01 00:00:00"
]
},
{
"columnName": "create_time",
"condition": "<=",
"keywordList": [
"2025-12-31 23:59:59"
]
},
{
"columnName": "state",
"condition": "=",
"keywordList": [
9
]
},
{
"columnName": "is_archive",
"condition": "=",
"keywordList": [
0
]
}
],
"timeout": 60000
}curl --location --request POST 'https://crm-dev.e-lansen.com/api/sales/project/query-project-filing-list?page=1&limit=20' \
--header 'token: {{token}}' \
--header 'token: {{token}}' \
--header 'Content-Type: application/json' \
--data-raw '{
"searchText": "KH2208050957WKPFJ",
"filedList": [
"customer_full_name",
"project_name",
"related_party_name",
"related_party_number",
"salesman_name",
"number",
"salesman_name",
"depart_name",
"project_industry_name",
"project_type_name",
"project_type_top_name",
"customer_number"
],
"sortingColumn": "create_time",
"sortingColumnType": "timestamp",
"sortingType": "2",
"sqlConditionList": [
{
"columnName": "create_time",
"condition": ">=",
"keywordList": [
"2025-01-01 00:00:00"
]
},
{
"columnName": "create_time",
"condition": "<=",
"keywordList": [
"2025-12-31 23:59:59"
]
},
{
"columnName": "state",
"condition": "=",
"keywordList": [
9
]
},
{
"columnName": "is_archive",
"condition": "=",
"keywordList": [
0
]
}
],
"timeout": 60000
}'{}