Home
last modified time | relevance | path

Searched refs:SQLWhere (Results 1 – 10 of 10) sorted by relevance

/dports/www/otrs/otrs-rel-6_0_29/Kernel/System/
H A DVirtualFS.pm373 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 DAutoResponse.pm406 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 DSLA.pm96 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 DLinkObject.pm2217 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 Dmyddas_prolog2sql_optimizer.ypp22 % --- 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 Dmyddas_prolog2sql.ypp251 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 DCustomerPurchases.php59 $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 DDB.pm371 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 DDB.pm624 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 DDB.pm4348 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;