QueryDeleteColumn
Deletes a column within a query object.
Method Signature
QueryDeleteColumn(query=[query], column=[string])Arguments
Argument
Type
Required
Description
Default
query
query
true
The query object to which the column should be deleted.
column
string
true
The name of the column to delete.
Examples
Deletes a column from the query
Builds a simple query and removes the 'id' column.
news = queryNew( "id,title", "integer,varchar", [
{
"id" : 1,
"title" : "Dewey defeats Truman"
},
{
"id" : 2,
"title" : "Man walks on Moon"
}
] );
queryDeleteColumn( news, "id" );
writeOutput( JSONSerialize( news ) );
Result: {"COLUMNS":["TITLE"],"DATA":[["Dewey defeats Truman"],["Man walks on Moon"]]}
Additional Examples
qry1 = queryNew( "a,b,c", "varchar,varchar,varchar", [
[
"a1",
"b1",
"c1"
],
[
"a2",
"b2",
"c2"
],
[
"a3",
"b3",
"c3"
]
] );
queryDeleteColumn( qry1, "c" );
writeOutput( qry1.COLUMNLIST );
qry2 = queryNew( "x,y,z", "varchar,varchar,varchar", [
[
"x1",
"y1",
"z1"
],
[
"x2",
"y2",
"z2"
],
[
"x3",
"y3",
"z3"
]
] );
bx:loop query="qry2" {
queryDeleteColumn( qry2, listFirst( qry2.COLUMNLIST ) );
}
writeDump( qry2.COLUMNLIST );
Related
Last updated
Was this helpful?