question

Davidlan T avatar image
0 Likes"
Davidlan T asked Davidlan T commented

SQL NOT operator does not work

Hi,

the following SQL-query doesn't work for me (ignore the odd variable names):

   
                  
    
                   
  1. Table dummy = Table.query("SELECT SUM(Average*Count) FROM Input_data WHERE Variable = $1 AND Hello_world NOT IN ('Iphone', 'I like cats')", parameter_1);
    2.

However, when I remove the NOT operator, the query works fine. I believe the syntax is correct according to FlexSim documentation, so what's going on??

And FYI, I do not use any special characters for my original variable names, only what you'll find in the english alphabet.

FlexSim 21.2.1
flexsim 21.2.1iphone
5 |100000
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

1 Answer

Jeanette F avatar image
0 Likes"
Jeanette F answered Davidlan T commented

Hello @Davidlan T,

Your question states that you are using FlexSim version 21.2 which is the latest version of the software. The NOT operator is supported for versions 20.2 and later. Can you verify the version you are using?

Release Notes and History (flexsim.com)

· 1
5 |100000
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

Davidlan T avatar image Davidlan T commented ·

Hi @Jeanette F

Thank you


0 Likes 0 ·