german asked 4 years ago
select2 dependent dropdown empty value is not shown for the second dropdown.
2 Answers
Abu Ghufran Staff answered 4 years ago
Quick solution is to add empty value in sql result using UNION. In parent dropdown, you can set this query for child with UNION. e.g. onchange sql:
“sql”=>”select ” as k, ‘-‘ as v UNION select distinct note as k, note as v from invheader WHERE client_id = ‘{client_id}'”
[email protected] answered 4 years ago
thank you sir,
I have used these methods .this works well.What i need is just default blank or select value at first and then followed by query values.
Thank you sir.
Your Answer
