# How to insert more than one selection criteria in adapya search buffer

**URL:** <https://techcommunity.softwareag.com/t/how-to-insert-more-than-one-selection-criteria-in-adapya-search-buffer/254703>\
**Category:** Forum\
**Tags:** Adabas-Natural, Adabas\
**Created:** [January 23, 2022, 10:49pm UTC](https://techcommunity.softwareag.com/t/how-to-insert-more-than-one-selection-criteria-in-adapya-search-buffer/254703 "2022-01-23T22:49:14Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Flavio\_Casacurta](https://avatars.discourse-cdn.com/v4/letter/f/c68b51/32.png) [@Flavio\_Casacurta](https://techcommunity.softwareag.com/u/Flavio_Casacurta)\
**Post date:** [January 23, 2022, 10:49pm UTC](https://techcommunity.softwareag.com/t/how-to-insert-more-than-one-selection-criteria-in-adapya-search-buffer/254703/1 "2022-01-23T22:49:14Z")

</div>

from adabas.datamap import \*  
from adabas.API import \*  
import pandas as pd  
c1 = Adabas(rbl=256,fbl=64,sbl=32,vbl=128,ibl=0)  
c1.cb.dbid = 12  
c1.cb.fnr = 11  
c1.cb.cid =b’1211’  
c1.fb.value = ‘AA,AC,AE,AD,AF,AG,AH,6,U,AJ,AK,AL,AN,AM,AO,AP,AU,AV.’  
c1.sb = ‘AF,1.’  
c1.vb = ‘S’

# I need to define one more filter

c1.sb = ‘AG,1.’  
c1.vb = ‘M’

row=Datamap(‘rows’,  
String(‘personnel\_id’, 8, fn=‘AA’),  
String(‘first\_name’, 20, fn=‘AC’),  
String(‘name’, 20, fn=‘AE’),  
String(‘middle\_name’, 20, fn=‘AD’),  
Char(‘mar\_stat’, fn=‘AF’),  
Char(‘sex’, fn=‘AG’),  
String(‘birth’, 6, fn=‘AH’),  
String(‘city’, 20, fn=‘AJ’),  
String(‘post\_code’, 10, fn=‘AK’),  
String(‘country’, 3, fn=‘AL’),  
String(‘area\_code’, 6, fn=‘AN’),  
String(‘phone’, 15, fn=‘AM’),  
String(‘dept’, 6, fn=‘AO’),  
String(‘job\_title’, 25, fn=‘AP’),  
String(‘leave\_due’, 2, fn=‘AU’),  
String(‘leave\_taken’, 2, fn=‘AV’))  
row.buffer = c1.rb  
row.offset = 0  
dic = {‘Personnel ID’:, ‘First Name’:, ‘Name’:, ‘Sex’:, ‘Mar Status’:, ‘Job Title’:}  
c1.find(saveisn=1)  
while True:  
try:  
c1.getnext()  
dic[‘Personnel ID’].append(row.personnel\_id)  
dic[‘First Name’].append(row.first\_name)  
dic[‘Name’].append(row.name)  
dic[‘Mar Status’].append(row.mar\_stat)  
dic[‘Sex’].append(row.sex)  
dic[‘Job Title’].append(row.job\_title)  
except DataEnd:  
print(‘Data End’)  
break  
except DatabaseError as (error, apa):  
error = error.split(‘:’)[1]  
print error  
employees\_df = pd.DataFrame(dic)  
display(employees\_df)

#### What are trying to achieve? Please describe in detail.

#### Do you get any error messages? Please provide a **full error** message screenshot and log file.

---

<div class="post-metadata">

**Author:** ![wolfgang.winter](https://sea1.discourse-cdn.com/techcommunity/user_avatar/techcommunity.softwareag.com/wolfgang.winter/32/17954_2.png) [@wolfgang.winter](https://techcommunity.softwareag.com/u/wolfgang.winter)\
**Post date:** [January 23, 2022, 11:12pm UTC](https://techcommunity.softwareag.com/t/how-to-insert-more-than-one-selection-criteria-in-adapya-search-buffer/254703/2 "2022-01-23T23:12:51Z")

</div>

Combine your criteria with a D (logical AND) and concatenate the vb values.

```auto
c1.sb = ‘AF,1,D,AG,1.’
c1.vb = ‘SM’

```

---

<div class="post-metadata">

**Author:** ![system](https://global.discourse-cdn.com/techcommunity/original/3X/c/d/cd19967bb605d28a72d77eb83a1cae22f3df2eb8.svg) [@system](https://techcommunity.softwareag.com/u/system)\
**Post date:** [April 23, 2022, 11:13pm UTC](https://techcommunity.softwareag.com/t/how-to-insert-more-than-one-selection-criteria-in-adapya-search-buffer/254703/3 "2022-04-23T23:13:46Z")

</div>

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.