Discovering the solution to populating and building a tree structure using jsTree in conjunction with SQL Server, addressing the challenges associated with the

Question

Discovering the solution to populating and building a tree structure using jsTree in conjunction with SQL Server, addressing the challenges associated with the

My current challenge involves using JSTREE to display a list of system modules. The issue arises from the fact that, according to the jsTree documentation, I need to use # in my query to create the tree structure. However, when I execute the following query, it results in an error:

The error message reads: "Conversion failed when converting the varchar value '#' to data type int." My SQL query looks like this:

select mod_id as id,
    (case when (mod_principal is null or mod_principal = 0)then '#' else mod_principal end) as parent, mod_modulo as text,
    mod_vista from crediguate.dbo.modulo m order by m.orden

Using # in the query works perfectly fine with MySQL as demanded by jsTree. Is there any way to list my modules using # in SQL Server?

javascript sql-server jstree

Answer 1

Answer №1

When using a CASE expression, it's important to ensure that all values in the THEN or ELSE clauses have the same data type. In this case, mod_principal is of type INT, so SQL attempts to cast '#' to an INT.</p>
<p>To resolve this issue, consider the following queries:</p>
<pre><code>select mod_id as id,
    (case 
         when (mod_principal is null or mod_principal = 0) then '#'
         else Cast(mod_principal as varchar(1000))
     end) as parent, mod_modulo as text, mod_vista 
from crediguate.dbo.modulo m 
order by m.orden

OR

select mod_id as id,
    (case 
         when (mod_principal is null or mod_principal = 0) then 0
         else mod_principal 
     end) as parent, mod_modulo as text, mod_vista 
from crediguate.dbo.modulo m 
order by m.orden

Answer 2

When using a CASE expression, it's important to ensure that all values in the THEN or ELSE clauses have the same data type. In this case, mod_principal is of type INT, so SQL attempts to cast '#' to an INT.</p>
<p>To resolve this issue, consider the following queries:</p>
<pre><code>select mod_id as id,
    (case 
         when (mod_principal is null or mod_principal = 0) then '#'
         else Cast(mod_principal as varchar(1000))
     end) as parent, mod_modulo as text, mod_vista 
from crediguate.dbo.modulo m 
order by m.orden

OR

select mod_id as id,
    (case 
         when (mod_principal is null or mod_principal = 0) then 0
         else mod_principal 
     end) as parent, mod_modulo as text, mod_vista 
from crediguate.dbo.modulo m 
order by m.orden

Discovering the solution to populating and building a tree structure using jsTree in conjunction with SQL Server, addressing the challenges associated with the

Answer №1

Similar questions

The 'innerText' property is not found in the 'Element' type

Incorporating words into the core of a pie chart: Highcharts

Arrange Raphael Objects in Their Relative Positions

What are the PropTypes for Animated.Values?

Creating a unique-looking visual representation of progress with arcs

Updating and deleting Firebase data from an HTML table: A guide

Next.js 13 app directory experiences 404 Not Found error due to dynamic routing issues

What steps do I need to take to modify the MUI Badge component and insert custom text inside?

Error in code - message gets sent immediately instead of waiting for timeout to occur

Recommendations for Configuring VPS for Angular2 and .Net Application

When the add button is clicked, I would like to implement a feature where a checkbox is added

Return an array that has been filtered to exclude any elements that are also found in a separate array

Encountering difficulty invoking a component method from d3's call() function

Exploring the differences between client-side and server-side data manipulation

What is the correct way to utilize Array.reduce with Typescript?

Cease the clicking action event

Navigating with React in ES5

Is there a method to programmatically identify enterprise mode in IE11?

Tips on resolving the distinct key issue in React and eliminating it

No traces of SOI could be detected in the stored canvas image