Searched refs:SQLWhere (Results 1 – 10 of 10) sorted by relevance
/dports/www/otrs/otrs-rel-6_0_29/Kernel/System/ |
H A D | VirtualFS.pm | 373 my $SQLWhere = ''; 379 $SQLWhere .= "vfs.filename LIKE '$Like' $LikeEscapeString"; 386 if ($SQLWhere) { 387 $SQLWhere .= ' AND '; 389 $SQLWhere .= 'vfs.id = vfsp.virtual_fs_id '; 411 $SQLWhere .= " AND ($SQL)"; 416 SQL => "SELECT $SQLResult FROM $SQLTable WHERE $SQLWhere",
|
H A D | AutoResponse.pm | 406 my ( @SQLWhere, @Bind ); 409 …push @SQLWhere, "ar.valid_id IN ( ${\(join ', ', $Kernel::OM->Get('Kernel::System::Valid')->ValidI… 414 push @SQLWhere, "ar.type_id = ?"; 418 if (@SQLWhere) { 419 $SQL .= " WHERE " . join( ' AND ', @SQLWhere );
|
H A D | SLA.pm | 96 my @SQLWhere; 103 push @SQLWhere, "s.id = r.sla_id AND r.service_id = $Param{ServiceID}"; 115 push @SQLWhere, "s.valid_id IN ( $ValidIDs )"; 120 my $WhereString = @SQLWhere ? ' WHERE ' . join q{ AND }, @SQLWhere : '';
|
H A D | LinkObject.pm | 2217 my $SQLWhere = ''; 2223 $SQLWhere = "WHERE valid_id IN ( $ValidIDs )"; 2231 SQL => "SELECT id, name FROM link_state $SQLWhere",
|
/dports/lang/yap/yap-6.2.2/library/MYDDAS/ |
H A D | myddas_prolog2sql_optimizer.ypp | 22 % --- optimize_subquery(SQLFrom,SQLWhere) ------------------------------- 41 optimize_subquery(SQLSelect,SQLSelect,SQLFrom,OptFrom,SQLWhere,OptWhere):- 43 once(member(negated_existential_subquery(_,SubQueryRelations,_),SQLWhere)) 45 once(member(existential_subquery(_,SubQueryRelations,_),SQLWhere)) 50 comparasion_analysis(SQLWhere,From1,From2,RelTotal1,RelTotal2), 51 delete_surplous_tables(SQLWhere,RelTotal2,OptWhere),
|
H A D | myddas_prolog2sql.ypp | 251 append(SQLWhereTemp,[once],SQLWhere) 256 Query = query(SQLSelect,SQLFrom,SQLWhere), 275 translate_goal(SimpleGoal,[SQLFrom],SQLWhere,Dict,NewDict):- 305 translate_conjunction(ExistsGoals,SQLFrom,SQLWhere,Dict,_), 312 translate_conjunction(ExistsGoals,SQLFrom,SQLWhere,Dict,_), 349 translate_conjunction(Goal,SQLFrom,SQLWhere,Dict,NewDict):- 354 translate_goal(Goal,SQLFrom,SQLWhere,Dict,NewDict). 363 append(WhereBegin,WhereRest,SQLWhere). 480 append(Where,RestWhere,SQLWhere). 678 translate_conjunction(AggGoal,SQLFrom,SQLWhere,Dict,_), [all …]
|
/dports/finance/weberp/webERP/ |
H A D | CustomerPurchases.php | 59 $SQLWhere=" WHERE stockmoves.debtorno='" . $DebtorNo . "'"; variable 64 $SQLWhere .= " AND custbranch.salesman='" . $_SESSION['SalesmanLogin'] . "'"; 67 $SQL .= $SQLWhere . " ORDER BY trandate DESC";
|
/dports/www/otrs/otrs-rel-6_0_29/Kernel/System/CustomerCompany/ |
H A D | DB.pm | 371 my @SQLWhere; 387 push @SQLWhere, 561 push @SQLWhere, $SQLQueryInCondition; 579 push @SQLWhere, $SQLQueryInCondition; 587 push @SQLWhere, 677 if (@SQLWhere) { 678 my $SQLWhereString = join ' AND ', map {"( $_ )"} @SQLWhere;
|
/dports/www/otrs/otrs-rel-6_0_29/Kernel/System/CustomerUser/ |
H A D | DB.pm | 624 my @SQLWhere; 640 push @SQLWhere, 811 push @SQLWhere, $SQLQueryInCondition; 829 push @SQLWhere, $SQLQueryInCondition; 841 push @SQLWhere, $SQLQueryInCondition; 854 push @SQLWhere, $SQLQueryInCondition; 862 push @SQLWhere, 948 if (@SQLWhere) { 949 my $SQLWhereString = join ' AND ', map {"( $_ )"} @SQLWhere;
|
/dports/www/otrs/otrs-rel-6_0_29/Kernel/System/SysConfig/ |
H A D | DB.pm | 4348 my $SQLWhere = 'sd.is_dirty = 1 OR (sm.user_id IS NULL AND sm.is_dirty = 1)'; 4352 … $SQLWhere = 'sd.is_dirty = 1 OR (sm.user_id IS NULL AND sm.is_dirty = 1 AND sm.change_by = ? )'; 4356 $SQL .= $SQLWhere;
|