nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

37080_en-US

liliconcom

modify SQL by list selection

Hi,

how can I change a SQL by a selection of a list?

In my Example I select in a Combo Box the Line ({"AL1", "AL2", "AL3", "FTA", "FTB", "FTC"}) and then I like to change my SQL with my selction. Currently I have "WHERE (t1.tag LIKE '%AL2%' ) ". And that works. But I like to substitute "AL2" regarding my selection.

Can anybody help me?

a = {"AL1", "AL2", "AL3", "FTA", "FTB", "FTC"};
New Window( "Line",
    <<MODAL></MODAL>

Re: modify SQL by list selection

here the code I used

 CustomSQL(Eval Insert(
  "SELECT t1.tag 
FROM   pisnapshot  t1 
WHERE  (  (  (  (t1.tag LIKE  '%^selection^%' )  )  )  )"
 )),