How to search a single field of the EncrtypedRow data

[MadhavPrabu]

Hi,
I have an issue to search a single field value & decrypt the single field value. When i tried to get the compound index for this, i got some new index. But in case, when i had given all the field data, then i got the same compound index.

What is the use of Compound index and how to search the single field data.
If i had used the blind index and it works fine like getting the same index.

For Example, i had use the ssn in blind index, and in compound index i had the fields like ssn, email, hivstatus.

$row->addBlindIndex(
    'ssn',
    new BlindIndex(
        'ssn_last_four_idx',
        [new LastFourDigits()],
        32 // 32 bits = 4 bytes
    )
);

$row->addCompoundIndex(
    (
        new CompoundIndex(
            'ssnlast4_hivstatus_cidx',
            ['ssn', 'email', 'hivstatus'],
            32, // 32 bits = 4 bytes
            true // fast hash
        )
    )->addTransform('ssn', new LastFourDigits())
);

$searchinputdata    = array('ssn'    =>  '123-45-6789');

$searchinputdata_cidx = array(''email'     => '[email protected]');


Stored indexex:
ssn_last_four_idx 		1258bc5e                // Blind Index
ssnlast4_hivstatus_cidx	9fbf99d5                  // Compound Index 

To search data,
when i use to get the blind index for ssn, it returns the same index value

$row->getBlindIndex('ssn_last_four_idx',$searchinputdata);

returns Blind Index (ssn_last_four_idx) as 1258bc5e

But when i tried to get compound index only with email, then it returns new compound index

$row->getBlindIndex('ssnlast4_hivstatus_cidx',$searchinputdata_cidx);

returns Compound Index (ssnlast4_hivstatus_cidx) as 1a1937b2

I need the clarification and help on this issue to achieve the search with compound index and decrypt the same.

Thanks

[paragonie-security]

Why are you adding two indexes for one? Choose either blind index or compound index, not both.

They're not interoperable; a single Compound Index is intended to be computed over multiple fields at once. This adds some overhead.

Additionally, the index key will always be distinct for two different indexes, even if you mostly define them the same. (Their names must differ, but that's also a requirement to get more than 1 index out of CipherSweet anyway.)

[MadhavPrabu]

Hi,
Okay, i will use only compound index and not use blind index. But i need to search a particular field value in a compound index.
For example, consider that i had created a compound index as address_cidx with the fields address,city,state.country,zip
Step:1
And the plaintext value for each fields is like address:myaddress_line, city:mycity, state:mystate. country:mycountry, zip:myzip
And compound index value created for the above data as 9fbf99d5.

Step:2
Store the encrypted data with compound index value in database.

Step:3
Now i need to search data with city:mycity using compound index without passing the other fields data. How can i get it.
If i try to do, it will give new different compound index (1a1937b2) which are not matched with existing index which we stored in Step-2.

But if i passed all the values like address:myaddress_line, city:mycity, state:mystate,. country:mycountry, zip:myzip then it gives the same index as 9fbf99d5

I need to search any of the combination or individual field value in compound index to search that if available or not.

For example, search with different combination of fields like,
address
city
state
zip
country
address,city
city,state
city,state,country
city,state,country,zip
address, city,state
address, city,state,country
address, city,state,country,zip
city, zip,
city,state,zip
address,city,zip
address,city,state,zip
zip,country

Can we do the search like this with compound index?

I need the clarification or solution to the above mentioned points that how to do this. If possible please share some examples in PHP

Thanks