Forum Discussion

Olaf_A's avatar
Olaf_A
New Contributor III
25 days ago

Multiple DbWhere statement

Hi,

Does anyone have an example where multiple dbwheres on the same column are executed?
The syntax seems to support AND/OR, but I can't seem to get it working. 

I have the following dbWheres (without the AND/OR part):

Dim dbWhereEntity As New DbWhere("Entity", dboperator.In, entityFilter)
Dim dbWhereResignationDate As New DbWhere("TermDate", dboperator.IsGreaterThan, dateEndOfMonth)
Dim dbWhereResignationDate2 As New DbWhere("TermDate", dboperator.IsEqualTo, Nothing)

Individually, the ResignationDate dbwheres seem to work.

The SQL statement needs to look something like this:

SELECT *
FROM MyTable
WHERE (TermDate > @DateEndOfMonth OR TermDate IS NULL)
  AND Entity = 'MyEntity';

(I know I could build a SQL statement and execute that as a work-around, but I'm just curious how this works)

Any help is appreciated, thanks!

Extenders
  • Olaf_A's avatar
    Olaf_A
    New Contributor III
    25 days ago

    Yes, I am aware, but the problem I'm facing is if I need to use the 'OR' statement when executing multipe criteria against 1 column

  • MarcR's avatar
    MarcR
    VIP
    25 days ago

    Hi Olaf, you can create a list of dbwheres land add that to your query:

    Dim dbWheres As New List (Of DbWhere)
	dbwheres.Add(New DbWhere("Year", "=",dYEar))
	dbwheres.Add(New DbWhere("Sub", "=",Entity))
	dbwheres.Add(New DbWhere(PeriodValue, "=","1"))
Dim Holding As String = BRApi.Database.LookupRowFieldValue(si, "App", "OwnerShipTable", dbWheres, "Holding", String.Empty)