Hello everyone!
i want to create a dynamic where condition, (BI related) to create a select for every extractor. But this is just additional information
Though i need to create a dynamic where condition to have generic selects.
Actually i use FM CRS_CREATE_WHERE_CONDITION. But this FM got a restriction. When i want to have a where condition like:
WHERE TEXT CP 'A**'
this FM masks the * with #* and this leads to the result that i only get texts containing the string 'A*' and not every text starting with A.
Though i tried FM RH_DYNAMIC_WHERE_BUILD because it was recommended very often here in the forum-discussions.
But this FM can only work with Fields shorter than 20 signs. And it also can not work with SIGNS, so only SIGN = I is possible.
the most disadvantage is that it creates a where condition that can not be used for SQL-Select statements. Because in a SQL Statement you can not write TEXT EQ 'A*' -> you need to write TEXT = 'A*'.
i also had a look on FREE_SELECTIONS_INIT. but this seems to be something different. But looking to the function Group of this FM i found the FM FREE_SELECTIONS_RANGE_2_WHERE. But this FM also does not produce legit SQL Where-Statements.
can you help me out? do you know any methods / FMs beside these to create dynamic where condition?
the where condition i need is for this statement:
OPEN CURSOR WITH HOLD ca_curser FOR SELECT * FROM (pi_table_name)
WHERE (ca_t_where_condition).
regards
Stefan Seebruger
