Welcome Guest! Log in
×

Notice

The forum is in read only mode.
Stambia versions 2.x, 3.x, S17, S18, S19 and S20 are reaching End of Support January, 15th, 2024. Please consider upgrading to the supported Semarchy xDI versions. See Global Policy Support and the Semarchy Documentation.

The Stambia User Community is moving to Semarchy! All the applicable resources have already been moved or are currently being moved to their new location. Read more…

Topic-icon Solved Issue in using query as source

More
06 Mar 2017 11:40 - 18 Apr 2017 09:18 #1 by Prashant.Sangle
Issue in using query as source was created by Prashant.Sangle
Hi,

I facing issue while executing query as source.
In my table data like

emp_id
001
002
003
004
em1
emp2
zy

I want to fetch only those records which start with numbers

So I am using below query and which is executing properly
select emp_id from emp
where emp_id like '[0-9]%'

but when I use above query as source query then stambia removing data which is written under square bracket ('')

guide me to resolve above issue


Note : Even in this editior whatever written inside square bracket is getting deleted. :dry::dry:

Regards,
Prashant
Last edit: 18 Apr 2017 09:18 by Prashant.Sangle. Reason: Issue solved
More
07 Mar 2017 09:08 - 07 Mar 2017 09:08 #2 by Thomas BLETON
Replied by Thomas BLETON on topic Issue in using query as source
Hello Prashant,

I observe the same behavior as you. Can you try doubling the square brackets ?
select emp_id from emp
where emp_id like '[[0-9]]%'
I'll ask the dev team the reason for this necessity. I guess it is related to some feature, I will tell you.[code generation] feature, I will tell you.
Last edit: 07 Mar 2017 09:08 by Thomas BLETON.
More
07 Mar 2017 10:50 - 07 Mar 2017 10:51 #3 by Prashant.Sangle
Replied by Prashant.Sangle on topic Issue in using query as source
Hello Thomas,

Thanks for your reply

yes 2 square bracket is working fine.

Regards,
Prashant
Last edit: 07 Mar 2017 10:51 by Prashant.Sangle.