JS: how to filter table using variable

Question

I have a function that I need to use for filtering table rows:

setFilterString("Filter");

But I have a problem. I can set it to

setFilterString("OrderID = 5");

and it will filter out row where OrderID is equal to 5 but if i try using a variable that has a value taken before like this

setFilterString("OrderID = vOrderID");

I get error "Invalid column name 'vOrderID'." (as vOrderID is variable and not a column, I guess)

I have seen somewhere in filter section inputting something like this ("OrderID = '" & vOrderID & "'") but it doesn't have any result at all for me. Doesn't even throw any error in the console.

Very close use + for concatenation i.e. ("OrderID = '" + vOrderID + "'") — Satpal
– Satpal, Commented Aug 1, 2017 at 13:00
@Satpal Solved. as it is a comment, cant marked as a solving answer. Co you mind telling me where i could look for information on this kind of thing? what the + means here or why it is in such syntax exactly? I imagine I'm gonna need this in the future too — NulisDefo
– NulisDefo, Commented Aug 1, 2017 at 13:03

hbulens · Accepted Answer · 2017-08-01 13:02:31Z

2

JavaScript assumes you are just passing a string to the function. If you want to use the variable, you should try this:

setFilterString("OrderID = '" + vOrderID + "'"); // Results in OrderID = '5'

or

setFilterString("OrderID = " + vOrderID); // Results in OrderID = 5

depending on the body of your function.

answered Aug 1, 2017 at 13:02

hbulens

1,9693 gold badges24 silver badges52 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

NulisDefo Over a year ago

first one means it puts 5 as a string and the second one as a number?

hbulens Over a year ago

In this function it won't make any difference as you concatenate a string with a variable which results in a string. If you would use a separate parameter in your setFilterString function for the vOrderID variable, then it would make a difference.

Vitor M. Barbosa · Accepted Answer · 2017-08-01 13:02:40Z

1

Use + instead of &: setFilterString("OrderID = " + vOrderID) should work.

answered Aug 1, 2017 at 13:02

Vitor M. Barbosa

3,6661 gold badge27 silver badges37 bronze badges

Comments

Konrad Siamro · Accepted Answer · 2017-08-01 13:04:10Z

1

Use "+" for merge strings:
setFilterString("OrderID = " + vOrderID)

You can also try to use ${idvOrderID} inside string:
setFilterString("OrderID = ${vOrderID}")

Or:
setFilterString(sprintf("OrderID = %s", vOrderID))

Remember about difference between ' and "

answered Aug 1, 2017 at 13:04

Konrad Siamro

2136 silver badges18 bronze badges

1 Comment

NulisDefo Over a year ago

first one works, the latter two don't Second ones throws an error: Parser error at line 0, character 10: Invalid input character "$".; ("OrderID = {FAILED HERE}${vOrderID}") Last one throws in console this: Uncaught ReferenceError: sprintf is not defined

Collectives™ on Stack Overflow

JS: how to filter table using variable

3 Answers 3

2 Comments

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related